LiftmyCVLiftmyCV
OL

Senior Data Analyst

OPIS LLCOn-siteLondon, GB
AI job summary

Join Dow Jones Energy as a Senior Data Analyst and support various sectors including Energy, Chemicals, and Renewables. This role involves advanced data analytics and business intelligence to inform product strategy and enhance revenue management. You will work across large datasets, developing dashboards and models, while collaborating with multiple teams including Sales and Finance. Essential skills include advanced proficiency in Excel, SQL, and Python. The position offers comprehensive healthcare plans, PTO, retirement plans, and various lifestyle programs.

Job description

Job Description:

About the Team:

Dow Jones Energy delivers trusted price transparency, benchmarks, analytics, news, and insights across the global energy, chemicals, metals, and fuel supply value chains. Our offerings support institutional investors, analysts, and traders navigating spot, wholesale, and retail markets, as well as emerging segments tied to the global energy transition. Through authoritative data, real-time intelligence, and deep market expertise, Dow Jones Energy enables financial professionals to mitigate risk and make high-stakes commercial decisions in volatile, fast-evolving global markets.

About the Role:

This is an exciting time to join our small but growing Commercial Product Management team where you will be supporting a number of key sectors including: Energy & Feedstocks, Coal, Metals and Mining, Renewables & Clean Energy and Chemicals. We are seeking a highly analytical and detail-oriented Senior Data Analyst to support business performance, revenue management, customer analytics, sales operations, product strategy, and executive decision-making. The position requires a combination of advanced Excel, SQL, Python, business intelligence, financial analysis, data visualization, and strong business judgment. You will work across large and complex datasets to develop reporting, dashboards, analytical models, and actionable insights for product and leadership teams. You are comfortable working independently on ambiguous analytical problems, reconciling data from multiple sources, automating recurring processes, and communicating findings to both technical and non-technical stakeholders. You will also serve as a key analytical partner to the Product, Sales, Finance, Customer Care, Consulting, and leadership teams. You will report to the Vice President - Product Management.

You Will:

  • Commercial & Revenue Optimization: Own end-to-end reporting for the Book of Business (ACV, renewals, new business, win/loss), building bottoms-up financial models, scenario analyses, and churn diagnostics to drive pricing, budgeting, and revenue retention strategies
  • Advanced Data Engineering & SQL: Query, transform, and aggregate complex datasets across multiple source systems using optimized SQL to resolve data discrepancies and ensure unified, cross-system reporting integrity
  • Data Quality & Governance: Establish rigorous validation processes, data cleansing protocols, and repeatable quality assurance checks to maintain accuracy and reliability across all core business metrics
  • Business Intelligence & Dashboards: Design and maintain scalable, user-friendly Power BI/Looker Studio dashboards that deliver actionable visibility into product performance, sales activity, customer health, and financial KPIs for non-technical stakeholders
  • Process Automation & AI Integration: Streamline recurring workflows using SQL, Python, Excel/VBA, and Power Query, while exploring AI/BigQuery solutions to scale self-service analytics and reduce manual reporting dependencies
  • Customer & Usage Behavioral Analytics: Synthesize product adoption, API/web activity, and usage data into customer health scores and engagement metrics that empower Sales and Account Management teams to mitigate churn Risk
  • Product Portfolio Strategy: Conduct product performance and entitlement analyses to evaluate pricing packages, support new product launches, and inform portfolio optimization or sunsetting initiatives
  • Cross-Functional Stakeholder Partnership: Serve as a strategic analytics partner across Sales, Finance, Product, and executive leadership, effectively communicating complex methodologies and managing ad-hoc analytical priorities to guide business decisions

You Have:

  • 3+ years’ professional experience in data analytics, commercial analytics, financial analysis, market research, or a related analytical role
  • Advanced proficiency in Microsoft Excel; including complex formulas, PivotTables, XLOOKUP, INDEX/MATCH, SUMIFS, nested logic, and data manipulation, VBA, Excel Macros, or Power Query
  • Experience with some or all of the following technologies:Python (particularly Pandas and data analysis/automation)BigQuery, Snowflake, SQL Server, Athena, or other cloud/data warehouse platformsPower BI, Looker Studio, Tableau, or similar BI platforms
  • Experience with B2B data/information, industry analysis, and/or applied software products (highly desirable)
  • Domain knowledge in chemicals/energy or other related industry areas
  • An interest to pursue a career in product management and want to leverage your existing analytical skill set while deepening your product management capabilities and expertise
  • Bachelor's degree in Data Analytics, Mathematics, Statistics, Economics, Finance, Business, Computer Science, or a related quantitative field -OR- equivalent work experience

Our Benefits

  • Comprehensive Healthcare Plans
  • Paid Time Off
  • Retirement Plans
  • Comprehensive Insurance Plans
  • Lifestyle Programs & Wellness Resources
  • Education Benefits
  • Family Care Benefits & Caregiving Support
  • Commuter Transit Program
  • Subscription Discounts
  • Employee Referral Program
  • Financial Health Programs
  • Cybersecurity Protection

Learn more about us and our benefits click here. #LI-Hybrid

Equal Opportunity Employer

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status or any other protected characteristic under applicable law.

Reasonable Accommodation

We are committed to providing reasonable accommodation for qualified individuals with disabilities in our job application and/or interview process. If you need assistance or accommodation in completing your application or participating in an interview due to a disability, email us. Please put "Reasonable Accommodation" in the subject line and provide a brief description of the type of assistance you need. This inbox will not be monitored for application status updates. Please refer to the privacy notice at the bottom of this page for submitting any data access, deletion, or other data subject rights requests, where permitted under your local laws and regulations.

Business Area:

Dow Jones - Energy

Job Category:

Data Analytics/Warehousing & Business Intelligence

Union Status:

Non-Union / A clear and likely internal candidate

Responsibilities

Own end-to-end reporting for the Book of Business, building financial models and scenario analyses; query and transform complex datasets using SQL; establish data validation processes; design and maintain dashboards; automate processes using SQL and Python; synthesize product adoption metrics; conduct product performance analyses; serve as a strategic partner across teams.

Job details

Published
October 12, 2026
Experience
Senior
Job source
myworkdayjobs
Workplace
On-site · London, GB
First seen
October 13, 2026

Requirements

3+ years' professional experience in data analytics; advanced proficiency in Microsoft Excel; experience with Python and cloud/data warehouse platforms; Bachelor's degree in a related quantitative field or equivalent work experience.

Benefits

Comprehensive Healthcare Plans, Paid Time Off, Retirement Plans, Insurance Plans, Wellness Resources, Education Benefits, Commuter Transit Program, Subscription Discounts, Employee Referral Program, Financial Health Programs.

Skills mentioned in this job

ExcelSQLPythonPower BI

LiftmyCV exclusive data

OPIS LLC hiring intelligence

OPIS LLC currently has 4 active jobs tracked by LiftmyCV. 4 new jobs in the past 7 days.

Active openings

4

Currently tracked by LiftmyCV

New in 7 days

4

4 new jobs in the past 30 days

Published salaries

100%

Median disclosed salary: $178,750

Average opening age

2 days

Across 4 active openings

Workplace breakdown

Remote0%
Hybrid25%
On-site75%

Hiring countries

United States of America

Top hiring cities

Houston
Gaithersburg

Most in-demand roles

  • • Associate Director, Planning & Performance
  • • Director - Aromatics Market Research & Analysis (Americas)
  • • Executive Director - Aromatics Market Research & Analysis (Americas)
  • • Price Reporter - US Refined Products Markets

Median disclosed salary: $178,750 · 100% of jobs publish a salary

As of November 18, 2026

Hiring insights calculated from active jobs tracked by LiftmyCV.

AI match explained

See how well you match this job

Log in or sign up and Eva will compare your profile with this role, explain your strengths and show what to improve.

Sign up to see your matchAlready have an account? Log in

More at OPIS LLC

Similar jobs from this company

Across the market

Similar jobs from other companies

Third-party content disclaimer

Full job descriptions are sourced directly from third-party applicant tracking systems (ATS), job boards, recruitment platforms, and employer career pages.

LiftmyCV does not claim ownership of this content or guarantee its accuracy or current availability. All original content is the intellectual property of the respective employers or other rights holders.

LiftmyCV hiring intelligence, availability checks, and related-job recommendations are generated from LiftmyCV data and public sources.

If you prefer, you may apply directly via the original listing for transparency.