QUALIFICATIONS/EDUCATION:

• A minimum of 5+ years of experience in technology with a focus on architectural design and planning, data, coding, BI, and/or data warehousing experience
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL), as well as working familiarity with a variety of databases
• Experience building and optimizing raw data pipelines, architectures, and data sets, with strong analytics skills related to working with unstructured data sets
• Machine learning experience and experience with big data infrastructure
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions
• Proficiency in Microsoft Office Suite
• Small to high-growth company experience preferred
• Bachelor’s degree in information systems, Computer Information Systems, Engineering, Mathematics, or similar related field preferred
• Oil and Gas industry experience is a plus
• Co-Pilot and OpenAI understanding is a plus

PAY RANGE AND COMPENSATION PACKAGE:

The salary range is $95,000 - $100,000, depending on experience, plus bonus opportunities.

• Please note that this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

ABOUT THE ROLE

We are seeking a results-driven, detail-oriented Senior Data Engineer to join a best-in-class team. The ideal candidate is an innovative problem solver who is self-motivated and proactive, showing extreme passion for organizing raw data into structured and consumable reports. S/he will have a relentless approach to translating data to drive unique market insights in order to ultimately help clients win. In this position, the Engineer will be able to create structure in an unstructured and ever-changing environment, with a strong ability to challenge and be challenged in approaches, uses, and organization.
This position represents a rare opportunity to be part of the Core Data Team as a thought leader to build out the company’s data foundation, central to EDA’s strategy and market leadership. Their input and advisement of data sources, intake, processes, and implementation into production will be key to further scale product development and market insights for business stakeholders. The Senior Data Engineer will not only receive mentorship and leadership from the Lead Data Analyst but will also have unique exposure to C-Suite Executives and the long-term objectives of the business.
This is a full-time, exempt position based in Greenwood Village, Colorado, and reports to the Lead Analyst of Data Technology.
Requirements:

AND RESPONSIBILITIES:

• Advanced SQL knowledge and experience working with relational databases, query authoring (SQL), as well as working familiarity with a variety of databases. Advanced knowledge of Python, SSIS and SSRS are required.
• Ingest, clean, normalize, and combine non-uniform, automated, and manual oil and gas fundamental data sources through scraping websites, PDFs, Excel-based models, vendor FTP feeds, and raw miscellaneous data files
• Ensure that data is logically paired together in a database and collectively aggregated in a data warehouse
• Good understanding of building and designing API’s
• Develop, construct, test, and maintain databases and data warehouse architecture that supports the requirements of business stakeholders
• Develop dataset processes for data modeling, mining, and production with scheduled deployments and releases in a predictable cadence
• Recommend and implement ways to improve data reliability, efficiency, and quality within the data warehouse and for reports
• Discover opportunities for new data acquisition
• Run queries to produce consumable data and useable reports via.csv and Excel for business stakeholders, both on a real-time basis and in a cyclical fashion
• Create data tools and interfaces for analytics and team members that assist in building and optimizing products
• Intake Analyst adjustments to complex optimization models and calculations to data files and sources on an ongoing basis, feeding back into databases for reporting accuracy and system of records
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, and re-designing infrastructure for greater scalability
• Communicate with both technical and non-technical internal customers to scope business requirements and lay out detailed project plans with key milestones and owners
• Document all data sources, methodologies, and processes, as it relates to the formation and refinement of the database build out and queries