Business Intelligence (BI) Data Engineer

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 operational continuity. Collaboration & Governance • 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, Azure AI Fundamentals or related Microsoft certifications are considered assets. Why Join Semex/Boviteq: Health & Wellness • Company paid comprehensive benefits program: Including extended health and dental care for employees and eligible dependents • Short and long-term disability coverage • Employee & Family Assistance Program Financial Security • Defined Contribution Pension Plan with employer matching • Competitive salary, merit pay and annual performance bonus Work-Life Balance • Paid time off: Vacation, Personal and Sick time • Employee Recognition Program Growth & Culture • Learning and development opportunities • Social committee events • Annual allowance for Semex Shop to purchase Semex / Boviteq branded clothing and merchandise Work Location & Minimum Pay Rate This is an in-person role requiring 3 days per week in our Guelph location. This position offers a minimum starting salary of $85,000.00, with potential compensation enhancements based on applicable experience and qualifications.