Senior Data Analyst

Overview

Join Dow Jones Energy as a Senior Data Analyst to empower commercial product decisions through advanced analytics, data governance, and actionable insights. You’ll support revenue optimization, product strategy, and leadership decision-making across Energy, Metals, Renewables, and Chemicals sectors. Expect to work with cross-functional teams to transform data into trusted visuals and models at scale. This role blends technical rigor with business judgment to drive pricing, retention, and portfolio strategy.

Pay / Benefits

• Comprehensive Healthcare Plans
• Paid Time Off
• Retirement Plans
• Education Benefits
• Family Care Benefits & Caregiving Support
• Commuter Transit Program

Responsibilities

• Own end-to-end reporting for the Book of Business (ACV, renewals, new business, win/loss) and build financial models to inform pricing and revenue strategies
• Develop and maintain advanced SQL-based data pipelines and cross-system reporting integrity
• Establish data quality and governance processes including validation, cleansing, and QA checks
• Design scalable dashboards (Power BI/Looker Studio) to track product performance, sales activity, customer health, and financial KPIs
• Automate recurring analytics workflows using SQL, Python, Excel/VBA, and Power Query; explore AI/BigQuery solutions for self-service analytics
• Synthesize product usage, adoption, and engagement data into customer health scores to reduce churn
• Conduct product performance and pricing analyses to inform portfolio decisions and new product launches
• Collaborate with Sales, Finance, Product, and leadership to prioritize analytics work and communicate methodologies

Key requirements

• 3+ years of experience in data analytics, commercial analytics, financial analysis, or related roles
• Advanced proficiency in Excel (formulas, PivotTables, XLOOKUP, INDEX/MATCH, SUMIFS, VBA/Power Query)
• Experience with Python (Pandas for data analysis/automation)
• Experience with cloud/data warehouse platforms (BigQuery, Snowflake, SQL Server, Athena)
• Experience with BI tools (Power BI, Looker Studio, Tableau)
• Experience with B2B data, industry analysis, or applied software products (desirable)
• Domain knowledge in chemicals/energy or related industries (desirable)
• Bachelor’s degree in a quantitative field or equivalent work experience

• strong communication to translate complex methods for non-technical stakeholders
• cross-functional collaboration and stakeholder management
• analytical curiosity and problem-solving with attention to detail
• Python (Pandas)
• SQL (complex querying, data transformation)
• BigQuery/Snowflake/SQL Server/Athena

…