Algoleap - 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)