Lead Data Analyst

Job Description

Job Description

Hybrid (Atlanta, GA preferred) - will provide full relocation package; remote opportunities available in TX for the right candidate

Full-Time, Permanent Role with Benefits

Confidential Energy & Utilities Client

Position Overview

Our VIP Client, an established energy company is seeking a Lead Data Analyst to join its enterprise risk and analytics team. This role is designed for a highly experienced data professional who brings both technical excellence and deep fluency in the wholesale natural gas market — someone who can draw meaning from complex datasets, identify value-creation opportunities, and influence strategic decisions with minimal ramp-up.

This is not a foundational role , and onboarding will not include “Natural Gas 101.” Instead, you’ll be expected to arrive with a command of market structure, storage dynamics, tariff implications, and how commercial decisions intersect with operational data. You’ll work with imperfect, third-party data feeds (from pipelines, storage operators, market indices) and transform them into usable, strategic insight.

Key Responsibilities

Own the development of models, reports, and scripts that support risk assessment , price and volumetric exposure , and storage valuation .

Clean and normalize raw data feeds from external vendors, ensuring high-integrity inputs for downstream forecasting, valuation, and optimization tools.

Apply contextual knowledge of market dynamics , including pipeline behavior, tariffs, and trading incentives, to evaluate commercial opportunities.

Build predictive analytics frameworks for weather, load, and pricing volatility.

Support arbitrage strategy development and operational decision-making through analytical rigor.

Deliver intuitive dashboards and visualizations that provide decision-makers with actionable insights.

Mentor junior analysts and act as a subject-matter expert across data infrastructure, modeling strategy, and gas market economics.

What You Bring

A strong commercial and technical command of the natural gas value chain — particularly in wholesale, trading, or risk-oriented settings.

The ability to work independently, ask the right questions , and proactively identify what data is missing, misaligned, or misleading.

Comfort working with incomplete, messy, or vendor-aggregated datasets — and the judgment to reconcile them using experience and intuition.

Exceptional communication skills, with a track record of explaining complex analytical outcomes to stakeholders across the business.

Proven ability to prioritize what's material from a business perspective, not just what’s statistically interesting.

Preferred Qualifications

Education : Bachelor’s in Data Science, Engineering, Finance, Economics, or a related field. Certifications like CAP, SDS, or MCSE in Data Management are advantageous.

Tools & Languages : Proficient in Python, SQL, DAX, PowerQuery, Excel ; experience with Git / version control. Familiarity with Java or VB is a plus.

Data Engineering : Skilled in ETL pipeline design , database development (Azure, Oracle, MySQL), and advanced data cleaning and validation.

Energy Market Expertise : Must understand tariff structures, storage optimization, pipeline scheduling , and how these intersect with market drivers.

External Data Sources : Experience working with third-party vendors (e.g., S&P Global, ICE, CME, EIA, FERC, EBBs), and able to turn raw feeds into business-ready inputs.

Visualization & Reporting : Strong background in business intelligence tools and building visual narratives that tie data to decisions.

Why This Role?

You’ll be stepping into a high-visibility role that influences pricing, risk, and trading decisions across a major energy business. This is a seat at the strategy table, not just behind a dashboard.

The team values speed, precision, and commercial fluency , and you’ll be working with leaders who expect — and empower — analysts to act as trusted advisors. This role offers full benefits, strong compensation, and the opportunity to make measurable impact every day.

Equal Opportunity & Accessibility

This employer values diversity and is committed to building an inclusive and supportive work environment. Accommodations are available throughout the hiring process upon request.