Sr. Advisor II, Commercial Data Engineering

Phillips 66 Company; Houston, Northern (TX, KY); Hybrid; USD 160,000 - 196,000; Full time

Benefits offered by this job

VCIP bonus

8% 401k match

Medical, Dental, Vision benefits

Well-being programs

Job summary

Phillips 66 is seeking a Sr. Advisor II, Commercial Data Engineering in Houston/Bartlesville to develop and maintain data solutions that empower Market Analysts, Strategists, and Traders. You will drive data quality, build curated data products, and implement reusable transformations across the Commercial organization.

Required are a Bachelor’s degree and 1+ years in finance or energy, plus 5+ years with SQL and Python. Experience with Databricks and Azure tools is highly valued.

Qualifications

• Bachelor’s degree or higher required.
• 1+ years in the finance or energy industry.
• 5 years of experience with SQL and Python.
• Experience with Databricks, Data Factory, Azure DevOps, and Git.

Responsibilities

• Develop and implement tools and analyses to improve information across the global Commercial organization.
• Own data quality: completeness, mapping, transformation checks, duplication and history validation.
• Build and maintain silver and gold data products for commercial domains (outages, ship tracking, plant capacity and runs, market prices, balances).
• Implement standardized, reusable transformations so calculations are defined once and consistent across desks.

Skills

SQL

Python

Education

Bachelor’s degree or higher

Tools

Databricks

Data Factory

Azure DevOps

Git

Job description

At Phillips 66, we care about the whole person. That means providing access to quality programs, resources and care that support you and your family. We believe well-being — physical, emotional, social and financial — plays an important role in helping our people thrive. When our employees are supported at every stage of life, they’re empowered to do their best work and make a meaningful impact, both personally and professionally.

Sr. Advisor II, Commercial Data Engineering

Location: Houston, TX, US, 77042; Bartlesville, OK, US, 74004

Job Field: Information Technology

Phillips 66 & YOU - Together we can fuel the future

The Sr. Advisor II, 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 Houston, TX or Bartlesville, OK.

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

• Legally authorized to work in the United States
• Bachelor’s degree or higher
• 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

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
• 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

Compensation Range

This position has a base salary range of $160,200 – $195,800.

At Phillips 66, we are committed to pay transparency and competitive, equitable compensation. Each role is assigned a salary grade with a defined pay range, benchmarked against industry peers. Where a candidate offer falls within the posted range depends on the candidate's experience, skills, and alignment with the role’s requirements. Offers are made to ensure internal equity and market competitiveness. Our compensation programs are designed to reward performance and support career growth.

Total Rewards

At Phillips 66, providing access to high quality programs and care for you and your family is important to us. Maintaining a culture of well-being — physical, emotional, social, and financial — is essential for a high-performing organization. When we are at our best, we are poised to deliver exceptional results — personally and professionally. Benefits for certain eligible, full-time employees include:

• Annual Variable Cash Incentive Program (VCIP) bonus
• 8% 401k company match
• Medical, Dental, and Vision benefits with an annual company contribution to a Health Savings Account for employees on HDHP
• Total well-being programs and incentives, including Employee Assistance Plan, well-being reimbursement, and backup family care services

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. Our company is built on values of safety, honor and commitment. We call our cultural mindset Our Energy in Action, which we define through four simple, intuitive behaviors: We work for the greater good, cultivate an environment of trust, seek different perspectives and pursueexcellence.

Learn more about Phillips 66 and how we are working to meet the world's energy needs today and tomorrow, by visiting phillips66.com.

Phillips 66 is an Equal Opportunity Employer