Sr Advisor, Commercial Data Engineering

Phillips 66; Greater London; On-site; GBP 90,000 - 120,000; Full time

Job summary

Phillips 66 is seeking a Sr. Advisor, Commercial Data Engineering to build and maintain data solutions for analysts, strategists and traders. The role focuses on data quality, curated data products, and standardized transformations across the global Commercial organization.

You will own data pipelines, support leadership with ad-hoc analyses, and help advance the team’s data engineering capabilities. London or Houston base, with a strong emphasis on energy markets.

Qualifications

• Bachelor's degree or higher is required.
• Experience with SQL and Python.
• Experience with Databricks, Data Factory, Azure DevOps, and Git.
• Experience in energy or finance.

Responsibilities

• Develop and implement tools and analyses to improve efficiency of information shared across the global Commercial organization.
• Own data quality: completeness, mapping, transformation checks, duplication/history validation, defect backlog.
• Build and maintain curated data products for commercial domains (outages, ship tracking, plant capacity, runs, market prices, balances).
• Implement standardized, reusable transformations for consistent calculations across desks and tools.
• Lead ad-hoc projects and analyses to support analysts, strategists and traders.
• Lead information gathering and development of presentation packages as needed.
• Improve existing tools and processes used by the Commercial organization.
• Share knowledge and improve team development capabilities.
• Support ad-hoc requests from Senior Management and Investor Relations.

Skills

SQL

Python

Databricks

Data Factory

Azure DevOps

Git

energy/finance

Education

Bachelor's degree or higher

Tools

Databricks

Unity Catalog

medallion architecture

dbt

orchestration tools

data testing libraries

Job description

Phillips 66 & YOU - Together we can fuel the future

The Sr. Advisor, Commercial Data Engineering supports Market Analysts, Strategists and Traders by developing and maintaining data solutions. The Sr. Advisor 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 London or Houston - a separate posting (62546) is open for Houston-based candidates.

What You’ll Do

• 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

What You’ll Bring - Required

• Hold the legal right to live and work in the UK on a permanent basis, or the role you are applying for meets the criteria for employer sponsorship
• Bachelor’s degree or higher
• Experience with SQL and Python
• Experience with Databricks, Data Factory, Azure DevOps, and Git
• Experience in energy or finance

What Makes You Stand Out - Preferred

• Hands-on experience with Databricks, Unity Catalog, medallion architecture, or comparable lakehouse tooling
• Bachelor’s degree in MIS, Engineering or Business
• Experience of Web application development (Flask/Django/Dash etc.)
• Experience with 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

We are on an exciting journey, are you ready to join us?

Phillips 66 has more than 140 years of experience in providing the energy that enables people to dream bigger and go farther, faster. We are committed to improving lives, and that is our promise to our employees and our communities. We are sustained by the backgrounds and experiences of our diverse teams, which reflect who we are, the environment we create and how we work together. We have been recognized by the Human Rights Campaign, U.S. Department of Labor and the Military Times for our continued commitment to inclusive practices and policies in the hiring and retention of those in the LGBTQ+ community and military veterans.

Phillips 66 is an Equal Opportunity Employer