Back to Job Search

SQL Programmer

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

Posted 9 days ago

Large Oil and Gas company based in The Woodlands / Spring, TX is seeking a Senior SQL Programmer for a 6 months+ engagement on their Greenhouse Gas (GHG) program team. This is a hybrid role, requiring this consultant to work 3 days per week onsite and 2 days per week remotely.  Excellent opportunity to work with a large Oil and Gas producer on leading edge initiatives and at a beautiful corporate campus.

RESPONSIBILITIES

In this role as the Senior SQL Programmer, you will support development and implementation of a comprehensive GHG inventory program for the company and subsidiaries. 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.  Additional duties include:
  • Enhancing the adaptive company-wide GHG database and GHG emissions calculation system that meets federal and company requirements, and that utilizes existing and future 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.
    • Company 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
  • 7+ years SQL experience
  • Bachelor of Science 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
  • Experience designing reports and dashboards in Spotfire; Tableau or equivalent BI product is a must
  • Advanced SQL skills to include:
    • 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
  • Experience/ Familiarity with Procount, SiteView, WellView databases.
  • Knowledge of SQL Server Reporting Services (SSRS)

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 consistently in the top 25 of all U.S. IT staffing firms and why our consultants rate us well above the industry average, earning us ClearlyRated's Best of Staffing awards year after year. People come to us for a job, and stay with us because of our top-notch consultant care.

MATRIX is and Equal Employment Opportunity employer including disability and veteran and provides reasonable accommodations for all qualified individuals.  Supporting medical or religious documentation will be required where applicable. If you are a qualified individual you may request a reasonable accommodation under the American Disability Act (ADA). If you are a person with a disability needing assistance applying, or at any point in the hiring process, please email us at MATRIX_HR@MatrixRes.com. To ensure a quick response to your request, please use the words “Accommodation request” as the subject line of your email.