Business Analyst with commodity/energy market data experience

Kainos Innovative Solutions Inc; Alabama; On-site; USD 90,000 - 120,000; Full time

Job summary

First Roles in Houston, TX is seeking a Senior Business Analyst with commodity/energy market data experience to join the Commercial Data & Analytics team. You will translate business needs into detailed requirements and coordinate with data engineering and offshore resources to deliver analytics solutions.

You will support QA, validation, and sign-off, ensuring data accuracy and timely delivery for trading, risk, and other Commercial workflows.

Qualifications

• Bachelor's degree or higher in a relevant field (Business, Finance, Economics, IS, CS, Eng, Math).
• Experience as a Business Analyst or similar role supporting data, analytics, or technology delivery.
• Strong knowledge of commodity markets and Commercial data and analytics.
• Experience translating business needs into detailed functional and data requirements.
• Experience with data QA, reconciliation, and validation.
• Proficiency in SQL and Excel for data investigation.

Responsibilities

• Serve as a day-to-day liaison between Commercial users and data engineering, analytics, and other technical delivery resources.
• Gather, analyze, and document business, functional, data, reporting, and analytics requirements.
• Translate business needs into detailed requirements, user stories, acceptance criteria, data mappings, calculations, and process documentation.
• Coordinate day-to-day implementation with data engineering and offshore resources and review delivered functionality against requirements.
• Perform QA and validation of datasets, data pipelines, reports, calculations, and outputs for accuracy and timeliness.

Skills

SQL

Excel

Data QA

UAT

Data pipelines

Stakeholder comms

Education

Bachelor's degree

Tools

Snowflake

Python

Power BI

APIs

Job description

Position: Sr. Business Analyst with commodity/energy market data experience

Location: Houston, TX

We are seeking an experienced Senior Business Analyst to join our Commercial Data & Analytics team. Reporting to the Director, Commercial Data & Analytics, this role will serve as a liaison between Commercial business users and technical delivery teams to support the delivery of data and analytics solutions.

The Senior Business Analyst will translate business and analytical needs into detailed requirements, coordinate implementation with data engineering and offshore technical resources, perform data and analytics quality assurance, and support business validation and sign-off.

The successful candidate will bring strong knowledge of commodity markets, Commercial data, and analytics, with an understanding of how market and fundamental data supports trading, analysis, risk, and other Commercial workflows.

This role contributes as part of the Commercial Data & Analytics team, with a focus on assigned initiatives and delivery support. The Senior Business Analyst will provide business analysis, coordination, and quality assurance support in alignment with Commercial Data & Analytics priorities, working closely with leadership and delivery partners to ensure scope, approach, and outcomes remain clear and well managed.

Your Responsibilities May Include:

• Serve as a day-to-day liaison between Commercial users and data engineering, analytics, and other technical delivery resources.
• Gather, analyze, and document business, functional, data, reporting, and analytics requirements for assigned initiatives.
• Translate business needs into detailed requirements, user stories, acceptance criteria, business rules, data mappings, calculations, and process documentation.
• Apply knowledge of commodity markets and Commercial data and analytics, including market data, pricing, forward curves, fundamentals, trading and risk data, and associated analytical workflows.
• Define requirements for data sources, definitions, transformations, calculations, frequency, granularity, history, and expected analytical outputs.
• Coordinate day-to-day implementation with data engineering and offshore technical resources, providing business context and clarifying requirements throughout development.
• Review delivered functionality and data against documented requirements and acceptance criteria.
• Perform detailed QA and validation of datasets, data pipelines, reports, calculations, and analytical outputs for accuracy, completeness, consistency, timeliness, and adherence to business rules.
• Perform source-to-target validation and data reconciliation and investigate discrepancies in partnership with technical resources.
• Document defects and requirements gaps and coordinate remediation and retesting with technical teams.
• Coordinate user acceptance testing, document business feedback, and support Commercial users through validation and final sign-off.
• Support data migrations, new data integrations, reporting and analytics enhancements, and modernization of existing Commercial data and analytical workflows.
• Track assigned requirements, issues, dependencies, and risks through development and business acceptance, providing status to Commercial Data & Analytics leadership.
• Collaborate effectively with analysts, engineers, architects, developers, vendors, and Commercial stakeholders as part of the broader delivery team.

Basic / Required Qualifications:

• Bachelor's degree or higher in Business, Finance, Economics, Information Systems, Computer Science, Engineering, Mathematics, or related discipline.
• Experience as a Business Analyst, Business Systems Analyst, Business Consultant, or similar role supporting data, analytics, or technology delivery.
• Strong knowledge of commodity markets and Commercial data and analytics.
• Demonstrated understanding of commodity market data, fundamentals, pricing, forward curves, and related Commercial analytical workflows.
• Experience translating business and analytical needs into detailed functional and data requirements, business rules, mappings, calculations, and acceptance criteria.
• Experience working directly with data engineers, developers, or other technical delivery resources.
• Experience performing data QA, reconciliation, source-to-target validation, functional testing, and UAT.
• Working knowledge of SQL for data investigation and validation.
• Strong Excel and analytical skills with experience working with complex datasets.
• Strong problem-solving skills and attention to detail.
• Ability to communicate effectively between business and technical audiences.
• Strong written and verbal communication skills.
• Demonstrated ability to work collaboratively within a team while independently managing assigned work through requirements, development, QA, remediation, and business acceptance.

Preferred Qualifications:

• Experience supporting energy, commodity trading, marketing, risk, market analysis, fundamental analysis, or related Commercial functions.
• Experience working with third-party commodity market and fundamental data providers.
• Experience with Snowflake or other modern enterprise data platforms.
• Experience with Python, Dash Apps, Power BI, APIs, and other data and analytics technologies.
• Experience with data migrations, source-to-target mapping, and reconciliation.
• Understanding of data quality, metadata, lineage, governance, and data stewardship concepts.
• Experience working with geographically distributed or offshore technical teams.
• Experience modernizing legacy reports, spreadsheets, or manually intensive analytical workflows.