SQL Programmer

29 Jun 2024

Vacancy expired!

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 companyReporting 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 Sciencein 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)

Equal Employment Opportunity

MATRIX is committed to providing a work environment that values diversity, equity, inclusion and respect. We do not discriminate based upon race, religious creed, color, national origin, ancestry, physical or mental disability, medical condition, genetic information, marital status (including registered domestic partnership status), sex (including pregnancy, childbirth, lactation and related medical conditions), gender (including gender identity and expression), age (40 and over), sexual orientation, military and veteran status and/or any other characteristic protected by federal, state or local law.

MATRIX is committed to providing access and reasonable accommodations for qualified individuals with disabilities. Supporting medical or religious documentation will be required where applicable. If you are a qualified individual with a disability, you may request a reasonable accommodation under the American Disability Act (ADA) by emailing MATRIXHR@MatrixRes.com. To ensure a quick response to your request, please use the words "Accommodation request" as the subject line of your email.

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 MatrixRes.com/Benefits 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.

  • ID: #43690786
  • State: Texas Spring 77389 Spring USA
  • City: Spring
  • Salary: USD TBD TBD
  • Job type: Contract
  • Showed: 2022-06-29
  • Deadline: 2022-08-27
  • Category: Et cetera