Back to Job Search

Senior SQL Data Analyst

  • Location: Spring, 77389
  • Salary: 65.0
  • Job Type:Contract

Posted over 1 year ago

Global Houston-based Oil and Gas company is seeking a strong Senior SQL Data Analyst for a long-term consulting assignment (1 year+) working 3 days/week at their large campus in Houston, TX, and 2 days remotely.  The mission of this team is to support the development and implementation of a comprehensive greenhouse gas (GHG) inventory program for the company. The GHG Program serves to collect and report all mandatory regulatory data required by EPA 40 CFR 98, as well as the company's internal inventory and reporting program. 

There will be a heavy focus in this role of troubleshooting Stored Procedures, troubleshooting what's in the live system, mapping database processes and improving them, writing SQL queries.  This team really needs to hire a SQL expert, who has some exposure to SQL on Azure, as well an upstream oil and gas background which would help greatly in coming up to speed with the data and projects.

RESPONSIBILITIES

  • Enhancing the adaptive company-wide GHG database and GHG emissions calculation system that meets federal and company requirements, and that utilizes existing and future company electronic data systems to collect the data, where possible.
  • Enhancing data collection procedures for fixed surface and downhole equipment, production data, and emission events that serve as source data for the GHG system.
  • Tracking operational developments and changes to existing assets, new assets, new production, new construction, and acquisitions, as they impact the GHG inventory.
  • Enhancing procedures and QA methodologies that document and define the GHG program requirements, including:
    • Regulatory and company Reporting Requirements (EPI).
    • Data collection methodologies.
    • Data source documentation.
    • Recordkeeping Requirements.
    • GHG reporting schedules.
    • System changes and updates.
    • Preparing and implementing GHG related training programs.
    • Calculating and summarizing GHG emissions in accordance with the Federal reporting rule and internal needs.
    • Interfacing (routinely) with Division mgt. and personnel to achieve program objectives.
    • Work closely with Product and Operations teams and support their analysis and data needs

REQUIRED SKILLS AND EXPERIENCE

  • 7+ years SQL experience
  • BS in statistics, engineering computer science, other technical related field
  • Experience/ Familiarity with Oil & Gas data management
  • Experience writing TSQL, views, stored procedures, functions and triggers
  • Experience with Azure SQL Database
  • Advanced SQL skills:
    • Maintaining/developing SQL queries and/or reorganizing data in various formats for routine reporting as well as ad-hoc requests
    • Implementing SQL updates as source systems change through cross-functional collaboration
    • Querying and integrating data from various sources via SSIS
  • Knowledge of and experience with programming languages, i.e. XML, VBA, Javascript, ETL frameworks, C#
  • Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, SPSS, SAS etc)
  • Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
  • Proven working experience as a Data Analyst or Business Data Analyst
  • Technical expertise regarding data models, database design development, data mining and segmentation techniques

PREFERRED SKILLS AND EXPERIENCE

  • Oil and Gas production, onshore unconventional upstream
  • Experience/ Familiarity with Procount, SiteView, WellView databases.
  • Knowledge of SQL Server Reporting Services (SSRS)
  • Experience designing reports and dashboards in Spotfire; Tableau or equivalent BI product is a must

​

Candidates will be responsible for following the client's COVID-19 protocols. Please refer to your MATRIX representative for specifics.

About Us

At MATRIX, we expertly match talented professionals with job opportunities to elevate careers. Since 1983, we have placed thousands of professionals at innovative clients across every industry ranging from small startups to Fortune 50 companies. It’s why we’re a top 15 U.S. IT staffing firm and why our consultants rate us well above the industry average. People come to us for a job, and stay with us because of our top-notch consultant care.

For hourly W2 contract roles, MATRIX offers a highly competitive benefit package including Medical, Dental, Vision, Life, Disability, HSA, and 401(k) with pre and post-tax options. Please see https://www.matrixres.com/consultants-overview/benefits-and-payroll for more information. For direct hire placement with our clients, benefits will be offered in accordance with that particular client’s offerings. This may include PTO, Medical, Dental, Vision, 401K and other pre and post-tax options.

Motion Recruitment Partners is an Equal Opportunity Employer, including Veterans/Disability/Women. All applicants must be currently authorized to work on a full-time basis in the country for which they are applying, and no sponsorship is currently available. Accommodation will be provided in all parts of the hiring process as required under Motion Recruitment Employment Accommodation policy. Applicants need to make their needs known in advance.