Lead BI Consultant
Use your Power BI, SQL & Microsoft Fabric skills to build scalable BI solutions, lead a growing team, and thrive in a diverse, innovative, international environment.
We usually respond within three days
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 Lead BI Consultant to join our team and make an impact in the fast-paced world of commodity trading.
Your role as Lead BI Consultant
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. A successful candidate will have extensive knowledge of Business Intelligence solutions, product development, and data management, as well as proficiency in Microsoft tools including Microsoft Power BI, Power Platform, SQL Server, and Microsoft Fabric. This role involves consulting with clients, managing expectations, and delivering BI solutions that aim to enhance business growth and efficiency.
The consultant's responsibilities include leading client engagements, advising on BI strategy, and overseeing the implementation of impactfull solutions. This position requires strong communication, project management, and leadership abilities to effectively manage complex BI projects and collaborate with senior stakeholders.
What we are looking for
We are looking for a Lead BI Consultant who thrives in a dynamic and international environment.
Responsibilities
Leadership & Team Management
- Lead and mentor a cross-functional BI team.
- Foster a culture of collaboration, knowledge sharing, and continuous improvement.
- Define and execute the BI strategy in alignment with organizational goals.
- Drive the development of scalable, future-proof BI solutions.
- Partner with stakeholders to translate business needs into a clear BI roadmap.
- Oversee the design and optimization of data pipelines and semantic models for reporting and analytics.
- Enforce data quality, security, and compliance standards.
- Act as the primary point of contact between business stakeholders and the BI team.
- Translate complex business requirements into actionable technical solutions and communicate BI insights to non-technical audiences.
- Establish best practices for monitoring, troubleshooting of BI solutions.
- Ensure timely delivery of BI initiatives.
- Stay current with industry trends, emerging BI tools, and Microsoft data ecosystem.
- Evaluate and introduce new technologies, methodologies, and frameworks to improve BI delivery.
- Promote data-driven decision-making across the organization.
BI Strategy & Roadmap
Data Architecture & Governance
Stakeholder Engagement
Performance & Delivery Excellence
Innovation & Continuous Improvement
You bring
- At least 5 years of experience with Data Analytics and Power BI.
- Strong communication skills in English (Dutch is a plus).
- Proven expertise in managing client expectations, and engaging with stakeholders.
- Extensive experience in creating Power BI dashboards, data modelling, and implementing data pipelines using Microsoft Fabric.
- Proficiency in product development processes.
- Skilled in managing multiple BI projects, delivering results within scope, time, and budget constraints.
- Commodity/trade experience is a plus.
What we offer
Joining DycoTrade means becoming part of an ambitious and innovative team. We offer:
- Career growth opportunities – Professional development and training programs.
- Competitive salary package – Including pension, a lease car, laptop & phone
- International work environment – Work with diverse teams and global clients.
- Office perks – Gym discounts, a great salad bar as addition to your own lunch, a pool table and fun colleagues.
Ready to make an impact?
Do you see yourself in this role? Apply now!
- Afdeling
- Product & Technologie
- Locations
- DycoTrade
- Remote status
- Hybrid

Colleagues
About DycoTrade
For over two decades, our unwavering focus has been on serving Commodity Trading companies globally. Today, DycoTrade has translated that focus into a market-leading ISV solution. This makes us one of the very few (if not the only) end-to-end solutions in commodity trading.
We excel in translating customer needs and processes into software solutions and vice versa, integrating new software functionalities into the daily operations of our clients. This expertise ensures we understand the nuances of running a commodity trading business and how to bolster traders, logistics teams, and finance departments.
Already working at DycoTrade?
Let’s recruit together and find your next colleague.