Senior Data Engineer

High Trail, Inc.; Houston (TX); On-site; USD 120,000 - 170,000; Full time

Job summary

High Trail, Inc. seeks a Senior Advisor II Data Engineer to support Market Analysts, Strategists and Traders by developing and maintaining data solutions in energy markets.

The role emphasizes data quality, scalable transformations, and collaboration across the Commercial organization; location can be Houston, TX or Bartlesville, OK.

Qualifications

• Bachelor’s degree or higher required.
• Legally authorized to work in the United States.

Responsibilities

• Develop and implement tools and analyses to improve efficiency and consistency across the global Commercial organization.
• Own data quality including completeness, mapping, transformation checks, duplication history validation, and the defect backlog for new sources.
• Build and maintain curated silver and gold data products for commercial domains, including outages, ship tracking, plant capacity and runs, market prices, and balances.
• Implement standardized, reusable transformations so calculations are defined once and consistent across desks and downstream tools.
• Lead ad-hoc projects and analysis to support Market Analysts, Strategists and Traders.
• Lead information gathering processes and development of presentation packages as needed.
• Work to improve existing tools and processes used by the Commercial organization.
• Share knowledge freely and improve the team’s development capabilities.
• Support ad-hoc requests from Senior Management, various Commercial groups, the Chief Economist’s Office, and Investor Relations.

Skills

Finance industry experience

Energy industry experience

Data engineering

Education

Bachelor's degree or higher

Tools

SQL

Python

Databricks

Data Factory

Azure DevOps

Git

Job description

A client of ours is looking for a Senior Advisor II Data Engineer supports Market Analysts, Strategists and Traders by developing and maintaining data solutions. The Sr. Advisor II Engineer will primarily develop solutions which allow analysts and strategists to leverage and enhance existing data; while developing a strong understanding of commodity pricing, seasonality, and supply and demand drivers related to energy markets. This position can be based in Houston, TX or Bartlesville, OK.

About the Role

The Senior Advisor II Data Engineer supports Market Analysts, Strategists and Traders by developing and maintaining data solutions and will primarily develop solutions which allow analysts and strategists to leverage and enhance existing data; while developing a strong understanding of commodity pricing, seasonality, and supply and demand drivers related to energy markets.

Responsibilities

• Develop and implement tools and analyses to improve the efficiency and consistency of information communicated across the global Commercial organization
• Own data quality in practice: completeness, mapping and transformation checks, duplication and history validation, and the defect backlog that comes with new sources
• Build and maintain curated silver and gold data products for commercial domains, including outages, ship tracking, plant capacity and runs, market prices, and balances
• Implement standardized, reusable transformations so calculations are defined once, documented, and consistent across every desk and every downstream tool
• Lead ad-hoc projects and analysis to support Market Analysts, Strategists and Traders
• Lead information gathering processes and development of presentation packages as needed
• Work to improve existing tools and processes used by the Commercial organization
• Share knowledge freely and improving the team’s development capabilities
• Support ad-hoc requests from Senior Management, various Commercial groups, the Chief Economist’s Office, and Investor Relations

Qualifications

• Legally authorized to work in the United States
• Bachelor’s degree or higher

Required Skills

• 1 or more years in the finance or energy industry
• 5 years of experience with SQL and Python
• Experience with Databricks, Data Factory, Azure DevOps, and Git

Preferred Skills

• Hands-on experience with Databricks, Unity Catalog, medallion architecture, or comparable lakehouse tooling
• Bachelor’s degree in MIS, Engineering or Business
• 5 or more years in the finance or energy industry
• Experience of Web application development (Flask/Django/Dash etc.)
• Experience of at least one of the following:
• Commercial trading businesses
• Commodity Markets
• Refining/Petrochemical Process
• Willingness and ability to support internal customers in business requirements
• High degree of initiative - works proactively to anticipate needs.
• Strong ability to manage multiple projects simultaneously
• Familiarity with dbt or similar transformation frameworks, orchestration tools, and data testing libraries
• Experience translating spreadsheet-based business logic into maintained pipelines
• Real instinct for data quality: you reconcile, question anomalies, and validate before you publish
• Genuine curiosity about the business behind the data, and the willingness to learn refinery capacity, outages, logistics, and trading fundamentals rather than staying purely technical