If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Business Intelligence (BI) Data Engineer

Administration Permanent Full Time Employee Guelph, ON, CA

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 current 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:

- 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.
- 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.
- 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 operational continuity.
- Work with the Data Platform Lead, business analysts, application teams, project resources and business stakeholders to clarify requirements and acceptance criteria.
- Follow data architecture, governance, security, privacy, development, testing and release standards.
- Document pipelines, transformations, data models, business rules, operational procedures and architectural decisions.

What You Need to Succeed:

- Bachelor's degree or college diploma in Computer Science, Information Systems, Computer Programming, Data Analytics or a related discipline, or an equivalent combination of education and experience.
- 2-3 years of experience in business intelligence, data engineering, analytics engineering or a related technical role.
- Hands-on experience developing production data pipelines, data models and reporting solutions.
- Experience with Microsoft Fabric or Azure-based data and analytics services.
- Experience with Power BI, semantic modelling and DAX.
- Strong SQL skills, including data transformation, querying and performance tuning.
- Microsoft Fabric knowledge including OneLake , lakehouse , warehouse, pipelines, notebooks, Dataflows Gen2 and semantic models.
- Knowledge of T-SQL, relational and dimensional modelling, ETL/ELT and data warehousing concepts.
- Experience with SQL Server, SSIS and SSAS in production environments.
- Strong analytical thinking, quality and attention to detail, problem-solving, collaboration and communication skills.
- Microsoft Certified: Fabric Analytics Engineer Associate, Microsoft Certified: Power BI Data Analyst Associate, Azure Data Fundamentals, Azur

📌 Business Intelligence (Guelph)
🏢 Semex
📍 Guelph