Senior Data Analyst - Dow Jones Energy Product Management
Dow Jones & Co.
Stand out for this role — generate a tailored resume and cover letter in about a minute.
Benefits offered by this job
Job summary
Dow Jones & Co. in Houston seeks a Senior Data Analyst to support commercial product management across energy markets. You will combine Excel, SQL, Python, and BI tools to deliver reporting, dashboards, and analytical models that inform pricing, revenue, and portfolio decisions.
You will partner with Product, Sales, Finance, and leadership to translate complex data into actionable insights, automate recurring processes, and drive data governance while exploring AI-driven analytics.
Qualifications
- 3+ years of experience in data analytics, commercial analytics, financial analysis, market research, or a related analytical role.
- Advanced proficiency in Microsoft Excel including PivotTables, XLOOKUP, INDEX/MATCH, and Power Query.
- Experience with Python (Pandas) and BI platforms such as Power BI or Looker Studio.
- Experience with B2B data/information, industry analysis, and/or applied software products is highly desirable.
- Bachelor's degree in a quantitative field or equivalent work experience.
Responsibilities
- Own end-to-end reporting for the Book of Business (ACV, renewals, new business, win/loss) and build financial models and churn diagnostics.
- Query, transform, and aggregate complex datasets across multiple sources using optimized SQL.
- Establish data quality, governance, and validation processes for core metrics.
- Design and maintain scalable dashboards (Power BI/Looker Studio) delivering visibility into product performance and financial KPIs.
- Automate recurring analytics workflows using SQL, Python, Excel/VBA, and Power Query; explore AI solutions to scale self-service analytics.
- Synthesize product usage data into customer health metrics to support Sales and Account Management teams.
- Partner with Sales, Finance, Product, and leadership to guide business decisions and portfolio strategy.
Skills
Education
Tools
Job description
Dow Jones & Co.
Since 1882, Dow Jones has been finding new ways to bring information to the world's top business entities. Beginning as a niche news agency in an obscure Wall Street basement, Dow Jones has grown to be a worldwide news and information powerhouse, with prestigious brands including The Wall Street Journal, Dow Jones Newswires, Factiva, Barron's, MarketWatch and Financial News. This longevity and success is due to a relentless pursuit of accuracy, depth and innovation, enhanced by the wisdom of past experience and a solid grasp on the future ahead. More than its individual brands, Dow Jones is a modern gateway to intelligence, with innovative technology, advanced data feeds, integrated solutions, expert research, award-winning journalism and customizable apps and delivery systems to bring the information that matters most to customers, when and where they need it, every day.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, protected veteran status, or disability status. EEO/AA/M/F/Disabled/Vets.
Dow Jones is 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, due to a disability, email us at talentresourceteam@dowjones.com. Please put “Reasonable Accommodation” in the subject line.
Houston, TX - OPIS
Full time
Job_Req_55481
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.
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.
- 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
- 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 platforms
- Power 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
- 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
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. EEO/Disabled/Vets
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 at talentresourceteam@dowjones.com. 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.
Business Area: Dow Jones - Energy
Job Category: Data Analytics/Warehousing & Business Intelligence
Union Status: Non-Union role
Base Pay Range: $75,000 - $95,000
We're committed to offering competitive and flexible compensation to attract top talent. This pay range reflects our good faith estimate for the role and may vary based on a candidate's experience, skills, location, and other relevant factors.
For bonus-eligible roles, targets are determined based on multiple considerations, including market benchmarks and individual contributions.
For benefits-eligible roles, we offer a comprehensive and competitive benefits package covering health, retirement, wellbeing, and more, along with optional benefits to meet the diverse needs of our employees.
Equal employment opportunity, including veterans and individuals with disabilities.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
