Strategic Commodities Analytics & Dashboard Lead

Jobtailor

Houston (TX)

On-site

USD 90,000 - 130,000

Full time

9 days ago

Application generator

Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.

Get past ATS filters

Job summary

Jobtailor in Houston is seeking a data analytics professional to support trading operations through dashboards, data models, and reporting infrastructure. You will analyze pricing, volumes, and P&L, translate stakeholder needs into scalable solutions, and own end-to-end dashboard delivery.

The role requires 2+ years of experience, SQL/Power BI proficiency, and strong communication skills to present insights to non-technical audiences.

Qualifications

2+ years of relevant experience in data analytics or finance
Bachelor's degree in business, finance, economics, or related field
Proficiency in Excel and PowerPoint including formulas, data organization, formatting
Working knowledge of SQL and relational databases
Ability to multitask and manage priorities in a fast-paced environment
Analytical thinking with structured problem-solving
Foundational understanding of commodities markets and end-to-end trade lifecycle
Basic understanding of P&L and pricing concepts
Ability to communicate data insights clearly to non-technical audiences
Preferred: financial modeling experience
Preferred: SQL in a production reporting environment
Preferred: Power BI, Spotfire, Python, Databricks proficiency
Preferred: strong understanding of market risk exposure concepts
Preferred: knowledge of natural gas marketing concepts
Preferred: demonstrated project ownership and scalable reporting solutions
Preferred: mentoring or reviewing junior analysts

Responsibilities

Support commercial and trading organization through reporting and mid-office functions
Own components of recurring reports and dashboards
Develop and enhance dashboards and data models
Analyze pricing, volumes, P&L, and market exposure to support trading decisions
Gather and document stakeholder requirements
Identify and implement process improvements
Own end-to-end delivery of dashboards, models, and reporting processes
Develop data pipelines and reporting infrastructure
Prepare analytical presentations for internal stakeholders
Improve reporting workflows and automate processes
Translate stakeholder needs into scalable analytical solutions
Mentor junior analysts and review their work
Prepare reports and PowerPoint presentations for management
Maintain and troubleshoot BI dashboards and data pipelines (Power BI, Spotfire)
Triage data quality issues with IT Data Engineering
Build forecast models (e.g., NGL)
Support data initiatives including migrations and hierarchy builds
Ensure data accuracy and clear presentation visuals