ABOUT US
Jonah Energy is an oil and gas exploration and development company headquartered in Denver, Colorado and operating in the Jonah and Pinedale Fields in Sublette County, Wyoming. The company is one of the largest privately held natural gas producers in the US and focuses on producing natural gas in an environmentally responsible manner.
POSITION SUMMARY
Under general direction, the Data Engineer is responsible for monitoring and administering the Data Warehouse and associated ETL processes, working with business users to create reports and dashboards, developing and maintaining inhouse data pipelines to ensure high availability, and troubleshooting any technical data issues that a user or company employee might encounter. Other duties may include creating cross system interfaces, establishing best practices, creating/documenting processes and procedures, and managing data-related projects, identifying and implementing opportunities to improve data workflows, processes, and visualization tools. The Data Engineer is also responsible to work with the Infrastructure and IIOT teams to discuss the need for network changes and the feasibility of projects recommended by company users and IT personnel. This position reports to the Manager Data Engineering & Analytics in the Denver office.
ESSENTIAL RESPONSIBILITIESEstablish relationships with key partners throughout the business from diverse departments such as Accounting, Land, Engineering, and Field Operations.
Build scalable systems, participate in discussions, while following development best practices. Must be able to write quality code and build high availability systems.
Work with business users to identify and automate manual processes.
Map, develop, and maintain ETL processes for the Enterprise Data Warehouse and various other cross-system interfaces.
Develop, implement, and maintain reports, visualizations and dashboards based on user requirements and needs that support and improve business decisions.
Act as a subject matter expert on the data models and interfaces used across our software products. Provide guidance to stakeholders and create a shared understanding among analysts and technical teams.
Build confidence with our business partners by adding value to discussions, being responsive, and following through on action items.
Maintain respectful and productive working relationships within and across all work groups, ensuring effective collaboration and cooperation.
Create a work environment that is consistent with the company's Purpose, Vision & Core Values.
Perform other duties and project tasks as assigned to support the success of the department and company.
None
- Highly detailed with a systematic approach, sense of responsibility and strong, positive customer focus. Results focused to drive the defined team and organizational goals.
- Self-manage time and projects. Make recommendations to improve existing projects and to identify opportunities for new automation and process improvements while balancing existing workload and customer expectations.
- Understand both the business processes of the groups we work with, and the technical details of the software to be an effective liaison for the IT department.
- Work in a team that designs, develops, troubleshoots and debugs ETLs, interfaces, and automation for databases, applications, tools etc.
- Strong conceptual and creative problem-solving skills; work with ambiguity; learn new and complex concepts quickly. Independently resourceful.
- Experience with Microsoft Power Platform tools.
- Proficient knowledge in creating BI reporting dashboards (PowerBI and/or Spotfire).
- Strong knowledge in programming languages such as Python, SQL or R for data wrangling, aggregation, and manipulation.
- Experience working with SQL Server to query, create, and manage databases.
- Experience deploying, optimizing, and maintaining cloud and on-prem data solutions (e.g., SqlServer, Azure, Snowflake).
- Solid understanding of data quality concepts.
- A great communicator, strong project management skills, and superb attention to details.
- Strong collaborator to work with all business units.
- Bachelor's Degree or equivalent relevant experience.
- 3+ years of experience in MSSQL, SSRS, SSIS, SSAS, and Power BI.
- Expertise in taking data projects from ideation to implementation.
- 3+ years of Data Analytics experience.
- None
- Previous experience in Oil and Gas Exploration & Production
- 1-2+ years' experience in Azure
- Spotfire experience
- SCADA systems experience
- None
- Individual contributor impacting department and companywide.
- Work in a climate-controlled office and routinely use standard office equipment.
- Up to 10%, as business requires.
Physical Requirements
% of Work Time
Remain in a seated position
90%
Speak and hear clearly
100%
Lift office products and supplies, up to 20lbs.
10%
Stoop, kneel, bend and reach
5%
Dexterity to write and manipulate keyboard and mouse
100%
We are not sponsoring work visa's at this time. In addition there is no relocation available.
The date the application window is anticipated to close is Februray 26, 2024.The date of the application window has been extended until March 8, 2024
We offer a comprehensive benefit package including generous PTO, parental leave, 401k match and discretionary profit sharing, tuition assistance, professional development, and eligibility for incentive programs. Additionally, eligible employees may enroll in health, dental, vision and life insurance on their first day of employment and elect from several voluntary group benefits. As an employee you have the opportunity to make a difference in a company where your position is critical to project success!
It has been and will continue to be the policy of Jonah Energy LLC not to discriminate against any employee or applicant for employment because of their race, color, religion, national origin, age, sex, sexual orientation, gender identity, gender expression, veteran status, disability, or other legally protected status. Employment is contingent upon successful completion of pre-employment screenings.