Senior Data Analyst
Dow Jones & Co.
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
- 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
- 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
Reference: WJ-747_31053920