Senior Data Engineer/ BI Consultant

About DycoTrade

DycoTrade is a fast-growing international company based in Aalsmeer, the Netherlands. Our team of over 80 talented professionals develops cutting-edge software solutions for commodity trading companies worldwide. With a diverse team representing more than 10 different nationalities, we foster an open and dynamic culture where innovation, collaboration, and personal growth are key.

Our CTRM (Commodity Trading & Risk Management) software, built on Microsoft Dynamics 365, helps companies efficiently manage the trading of essential commodities like metals, grains, cocoa, coffee, and dairy. By providing real-time insights and risk management tools, we empower businesses to trade smarter and more securely.

Due to our continued success and growth, we are looking for a Senior Data Engineer/ BI Consultant to join our Data Analytics team and make an impact in the fast-paced world of commodity trading.

Your role as Senior Data Engineer

In the world of commodity trading, knowledge is power. DycoTrade’s BI solution provides clients with valuable insights that help them perform better, grow their revenue, and reduce risks. As a Senior Data Engineer/ BI Consultant, you will be responsible for designing, building, and optimizing enterprise-grade data pipelines and architectures to support DycoTrade’s BI solutions. This role ensures that data from Dynamics 365 and related sources is efficiently ingested, transformed, governed, and delivered across the Bronze, Curated, and Semantic layers for analytics and reporting.

Key Responsibilities 

Data Architecture & Pipeline Development

• Design, maintain, and optimize ETL/ELT pipelines from Dynamics 365 (Finance & CRM) into the data lakehouse (OneLake) and SQL-based curated layers.

• Manage ingestion from the Bronze layer (raw Dataverse data) to Curated and Semantic layers.

• Ensure scalability, performance tuning, and efficient incremental loads.

Data Modeling & Integration

• Develop robust data models for BI consumption (Power BI semantic models, tabular models).

• Implement star/snowflake schemas for analytical performance.

• Ensure consistency of business definitions and KPIs across domains.

Data Governance & Quality

• Establish and enforce data quality checks, validation rules, and error handling in pipelines.

• Collaborate with governance teams to maintain metadata, lineage, and data cataloging.

• Support integration with Microsoft Purview or equivalent.

Collaboration & Stakeholder Management

• Work closely with functional consultants, BI developers, and SMEs to translate business requirements into technical solutions.

• Review and approve BI architecture documents for standard client rollout.

• Provide technical guidance to junior engineers.

Performance Monitoring & Maintenance

• Set up monitoring, logging, and alerting for data pipelines.

• Troubleshoot failures, bottlenecks, and data anomalies.

• Maintain optimal performance of queries, views, and reports.

What we are looking for

You thrive in a dynamic, international environment, turning complex data challenges into reliable, high-value BI solutions.

Expectations

• Deliver high-quality, reusable, and documented pipeline solutions that can be replicated for new client rollouts.

• Maintain low-latency and high-availability data flows from source to dashboard.

• Adhere to DycoTrade’s data governance and security guidelines.

• Proactively suggest process improvements and automation opportunities.

• Act as a technical lead in data engineering discussions.

Must-haves

• Strong experience with Azure Data Platform (Data Factory, Synapse, Fabric, SQL DB/DW, Data Lake/OneLake).

• Proficiency in SQL Server (T-SQL), query optimization, and view creation.

• Experience with Dynamics 365 Finance & CRM Dataverse schema.

• Solid understanding of BI architecture: Bronze–Curated–Semantic layers.

• Proven skills in data modeling (Kimball/Dimensional, Data Vault is a plus).

• Knowledge of data governance principles and tools (Microsoft Purview preferred).

• Experience with Power BI datasets and DAX.

• Strong debugging and performance tuning skills.

• Excellent communication skills for cross-functional collaboration.

Nice-to-haves

• Experience with CI/CD for data pipelines (Azure DevOps, GitHub Actions).

• Familiarity with Python or PySpark for advanced transformations.

• Exposure to Kusto Query Language (KQL) for monitoring/log analytics.

• Knowledge of Event-driven architectures (Azure Event Grid, Service Bus).

• Experience with Dynamics 365 F&O customization for data extraction.

• Understanding of financial trading, commodity management, or hedging domains (DycoTrade-specific).

What we offer

Joining DycoTrade means becoming part of an ambitious and innovative team. We offer:

• An impactful role in global commodity trading and exposure to high-performance BI solutions.

• Work with clients across Europe, Africa, Asia, and the Americas

• A multi-national, cross-functional environment

• A competitive salary, depending on experience.

• A lease car, laptop, pension scheme.

• An informal, relaxed atmosphere where quality comes first.

• Freedom to contribute to product development.

• Opportunities for certification and continuous learning.

• Hybrid working model.

Ready to make an impact?

Do you see yourself in this role? Apply now!