Business Analyst - Commodity Trading

Key Responsibilities:

1. Requirements Engineering & Stakeholder Management:

- Engage with commodity traders, risk managers, and business analysts to capture, analyze, and document requirements for market data and trading analytics platforms.

- Translate complex business logic into clear functional specifications, data mapping documents, technical user stories, and acceptance criteria for engineering teams.

- Act as the primary liaison between business end-users and cloud data engineers, ensuring aligned priorities and seamless delivery.

2. Data Analysis & Solution Architecture Support:

- Analyze raw commodity datasets (supply, demand, prices, inventory/stocks, cross-border imports/exports, trade flows) to identify patterns, data quality issues, and transformation requirements.

- Collaborate with data engineering teams on schema design, data modeling, and distributed pipeline architectures across cloud and on-premise platforms.

- Validate complex SQL transformations, business rules, and aggregation logic before deployment to downstream BI tools and analytics platforms.

3. Pipeline Monitoring, Data Governance & Quality:

- Partner with engineering teams to define and implement data quality frameworks, validation checks, and operational SLAs across batch workloads.

- Assist in troubleshooting data anomalies, source-to-target reconciliation, and pipeline outages impacting business-critical dashboards and reporting tools.

- Define and document data dictionaries, metadata, lineage, and data governance best practices for commodity market datasets.

Required Qualifications Experience & Education:

- Education: Bachelor's degree in Business Analytics, Computer Science, Information Systems, Finance, or a related quantitative field.

- Experience: 5+ years of experience as a Business Analyst, Data Analyst, or Systems Analyst working closely with production-grade ETL/ELT pipelines and scalable data processing environments.

Domain Expertise:

- Commodity Trading & Market Data: Strong domain expertise in commodity trading, including deep understanding of market fundamentals - commodity supply/demand, pricing benchmarks, physical/paper stocks, import/export trade flows, and vessel/shipping data.

Technical Skills & Tools:

- Database & Querying: Hands-on expertise in writing complex SQL queries for data profiling, source-to-target mapping, data validation, and transformation verification.

- Programming & Big Data Ecosystem: Functional understanding and hands-on exposure to Python, PySpark, Apache Spark, and Databricks for analyzing large-scale datasets.

- Orchestration & Data Integration: Familiarity with pipeline orchestration tools like Apache Airflow and cloud integration services like AWS Glue.

- Cloud & Storage Technologies: Familiarity with cloud storage and database systems including Amazon S3, Amazon Aurora, and object storage like MinIO.

- Analytics & Quality: Solid grasp of distributed data processing concepts, batch workload optimization, data quality controls, and pipeline troubleshooting.

Preferred Qualifications:

- Prior background working in energy, metals, agricultural commodities, or physical trading houses.

- Hands-on experience building or specifying datasets for BI and visualization tools (e.g., Power BI, Tableau, Looker).

- Familiarity with Agile/Scrum development practices and toolsets (Jira, Confluence)