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?
#J-18808-Ljbffr
