Business Intelligence (BI) Data Engineer

**About Us** At Semex / Boviteq, we truly believe that your work and workplace should be more than just a job - they are an invaluable part of your career and personal journey. We believe you should have opportunities to grow, develop relationships, and contribute to our important work of ensuring that farmers worldwide have the genetics, technology, and hands-on solutions needed to feed the world. **About the Role** We are currently looking for a BI Data Engineer to fill a new role and join our Information Technology team. Reporting to the Data Platform Lead, this role will be responsible for designing, developing, testing and supporting Semex's modern data, analytics and business intelligence solutions. The role focuses on delivering scalable data products using Microsoft Fabric, Power BI and related Microsoft technologies, while supporting the controlled modernization of existing SQL Server, SSIS and SSAS solutions. Working under the technical direction of the Data Platform Lead, the position transforms business requirements into reliable pipelines, lakehouse and warehouse solutions, semantic models, dashboards, integrations and AI-enabled or agentic solutions. The role contributes directly to trusted enterprise reporting, self-service analytics and the delivery of measurable business value from data. **What You Will Do:** **Data Engineering & Integration** * Design, build, test, deploy and support data pipelines and transformations using Microsoft Fabric and approved cloud-native patterns. * Develop Fabric lakehouse and warehouse solutions that integrate data from D365, operational applications, external services and existing data platforms. * Create reusable, parameterized and supportable ingestion and transformation processes using SQL, notebooks, Dataflows Gen2 and pipelines as appropriate. * Ensure solutions meet requirements for performance, scalability, reliability, supportability and security. **Analytics & Business Intelligence** * Design and maintain enterprise semantic models aligned with approved business definitions, security standards and performance expectations. * Develop clear, accessible and performant Power BI reports, dashboards and analytical experiences. * Create and optimize DAX measures, relationships, calculation logic, row-level security and refresh processes. * Support governed self-service analytics through reusable data products and curated semantic models. **AI, Automation & Innovation** * Develop and support approved AI-enabled and agentic solutions using Microsoft Fabric, Copilot Studio, Power Platform and related Microsoft services. * Contribute to the evaluation and adoption of emerging Microsoft data, analytics and AI capabilities that support business objectives. **Legacy Platform Support** * Maintain and enhance business-critical SQL Server, SSIS, SSAS and related data warehouse solutions. * Support modernization efforts that transition legacy solutions to Microsoft Fabric while maintaining ope