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.
- 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
- Experience/ Familiarity with Procount, SiteView, WellView databases.
- Knowledge of SQL Server Reporting Services (SSRS)