Senior Data Analyst: Revenue & Product Analytics (Energy)

Storyful; Houston (TX); On-site; USD 75,000 - 95,000; Full time

Benefits offered by this job

Comprehensive Healthcare Plans

Paid Time Off

Retirement Plans

Education Benefits

Wellness Resources

Job summary

Dow Jones Energy is seeking a Senior Data Analyst to support commercial performance, revenue management, and product strategy. You will build financial models, dashboards, and analytics across ACV, renewals, and new business, collaborating with Product, Sales, and Finance to drive data-driven decisions.

You will work with Excel, Python, and BI tools to deliver scalable insights, automate recurring analyses, and improve data quality across multiple data sources.

Qualifications

• 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

Responsibilities

• 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

Skills

Advanced Excel

Python (Pandas)

Analytical thinking

Business judgment

Education

Bachelor's degree in a quantitative field

Tools

Python (Pandas)

BigQuery

Snowflake

SQL Server

Athena

Power BI

Looker Studio

Tableau

Job description

Dow Jones Energy is seeking a Senior Data Analyst to support commercial performance, revenue management, and product strategy. You will build financial models, dashboards, and analytics across ACV, renewals, and new business, collaborating with Product, Sales, and Finance to drive data-driven decisions.

You will work with Excel, Python, and BI tools to deliver scalable insights, automate recurring analyses, and improve data quality across multiple data sources.