Business Analyst with commodity/energy market data experience

Kainos Innovative Solutions; Houston (TX); Vor Ort; USD 90.000 - 140.000; Vollzeit

Zusammenfassung

Kainos Innovative Solutions in Houston, TX seeks a Senior Business Analyst with commodity/energy market data experience to bridge business users and data delivery teams. You will translate needs into detailed requirements, coordinate with data engineering and offshore resources, and ensure accuracy through QA and UAT.

Responsibilities include validating datasets, defining data sources and calculations, and supporting migrations and new integrations.

Qualifikationen

• Bachelor's degree or higher in Business, Finance, Economics, Information Systems, CS, Engineering, Mathematics, or related discipline.
• Experience as a Business Analyst, BSA, or similar role supporting data, analytics, or tech delivery.
• Strong knowledge of commodity markets and Commercial data and analytics.
• Understanding of commodity market data, fundamentals, pricing, forward curves, and related workflows.
• Experience translating business needs into detailed functional and data requirements with acceptance criteria.
• Experience working with data engineers, developers, or other technical delivery resources.
• Experience performing data QA, reconciliation, source-to-target validation, testing, and UAT.
• Working knowledge of SQL for data investigation and validation.
• Strong Excel and analytical skills with complex datasets.
• Strong problem-solving and attention to detail.
• Excellent written and verbal communication skills.

Aufgaben

• 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 analytical workflows.
• Define requirements for data sources, definitions, transformations, calculations, frequency, granularity, history, and expected outputs.
• Coordinate day-to-day implementation with data engineering and offshore resources, providing business context and clarifying requirements.
• Review delivered functionality and data against documented requirements and acceptance criteria.
• Perform detailed QA and validation of datasets, data pipelines, reports, calculations, and outputs for accuracy and timeliness.
• Perform source-to-target validation and data reconciliation and investigate discrepancies with technical teams.
• Document defects and requirements gaps and coordinate remediation and retesting.
• Coordinate user acceptance testing and support validation and final sign-off.
• Support data migrations, new data integrations, reporting and analytics enhancements, and modernization of workflows.
• Track requirements, issues, dependencies, and risks and provide status to leadership.
• Collaborate with analysts, engineers, architects, developers, vendors, and stakeholders as part of the delivery team.

Kenntnisse

SQL

Excel

Communication

Data analysis

Problem solving

Requirements gathering

Ausbildung

Bachelor's degree or higher in Business/IT/Finance

Tools

Snowflake

Python

Power BI

APIs

Dash Apps

Jobbeschreibung

Position: Sr. Business Analyst with commodity/energy market data experience
Location: Houston, TX

Description

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.