About the Role
Blue Orange Digital is seeking a Senior Data Engineer for a full-time, 22-week engagement (with options to extend or convert) on a large-scale enterprise data warehouse implementation in the global commodities trading and supply chain industry. You will design and build ingestion pipelines, medallion-layer transformations, and Gold-layer data products on Microsoft Fabric, covering Trader P&L, Global Position, Risk Metrics (VaR), and Financial Consolidation. You will work closely with the Solutions Architect/Tech Lead and a co-invested client engineering team, contributing across all four engagement phases.
Responsibilities
- Design and implement Bronze-layer ingestion pipelines from regional ERP systems, CTRM instances (including Irely), and SAP S/4HANA source feeds into OneLake using Microsoft Fabric Data Factory.
- Build Silver-layer transformation logic in Fabric notebooks using PySpark and SQL against Delta Lake tables, covering data cleansing, standardization, deduplication, and business rule application.
- Develop Gold-layer data product tables serving Trader P&L, Global Position, VaR risk metrics, and Financial Consolidation reporting domains.
- Implement and maintain the OneLake medallion architecture following BOD design standards and engagement coding conventions.
- Perform schema design, data modeling, and query performance optimization across Fabric Lakehouse and Warehouse layers.
- Collaborate with the Analytics/Power BI Specialist to publish clean, analytics-ready Gold-layer outputs aligned to semantic model requirements.
- Participate in code reviews, enforce development standards, and contribute to CI/CD pipeline configuration for the Fabric workspace.
- Work with client-side Fabric/Azure data engineers as a technical peer—aligning on ingestion patterns, shared schemas, and pipeline governance.
Requirements
- 7+ years of data engineering experience with a strong portfolio of end-to-end pipeline implementations.
- Hands-on proficiency with Microsoft Fabric (OneLake, Lakehouse, Notebooks, Data Factory, Warehouse)—the full core stack for this engagement.
- Strong SQL and PySpark skills with production-level experience building and maintaining Delta Lake pipelines.
- Experience building multi-hop pipelines across Bronze/Silver/Gold medallion architectures.
- Familiarity with ERP or CTRM source system integration (SAP S/4HANA or similar strongly preferred).
- Bachelor’s degree in Computer Science, Engineering, or a related technical field (or equivalent experience).
Skills
- Microsoft Fabric
- OneLake
- Lakehouse
- Notebooks
- Data Factory
- Warehouse
- SQL
- PySpark
- Delta Lake
- ERP integration
- CTRM integration
- SAP S/4HANA
- Azure DevOps
- GitHub Actions
Location
- Europe (Poland, Germany, Portugal, Spain, Italy, etc.)
- Travel to Lebanon, Burkina Faso, Vietnam, or Switzerland required
Work Type
- Full-time
- Engagement (22 weeks with options to extend or convert)
Experience Level
- Senior
Education Level
- Bachelor’s degree in Computer Science, Engineering, or a related technical field (or equivalent experience)
- Microsoft Fabric or Azure Data Engineer certification (DP-700 or DP-203) preferred
Salary/Compensations
- $6200 - $8500 USD monthly
About the Company
- Blue Orange Digital is a boutique data & AI consultancy that delivers enterprise-grade results.
- We design and build modern data platforms, analytics, and ML/AI Agent solutions for mid‑market and enterprise clients across Private Equity, Financial Services, Healthcare, and Retail.
- Our teams work with technologies like Databricks, Snowflake, dbt, and the broader Microsoft ecosystem to turn messy, real‑world data into trustworthy, actionable insight.
- We’re a builder‑led, client‑first culture that prizes ownership, clear communication, and shipping high‑impact work.
Equal Opportunity
- Blue Orange Digital is an equal-opportunity employer.
