Business Intelligence (Bi) Data Engineer

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, CAAbout UsAt 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 RoleWe 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: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 SupportMaintain 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, Azure AI Fundamentals or related Microsoft certifications are considered assets.Why Join Semex/ Boviteq :Company paid comprehensive benefits program: Including extended health and dental care for employees and eligible dependentsShort and long-term disability coverageEmployee & Family Assistance ProgramDefined Contribution Pension Plan with employer matchingCompetitive salary, merit pay and annual performance bonusWork-Life BalancePaid time off: Vacation, Personal and Sick timeEmployee Recognition ProgramGrowth & CultureLearning and development opportunitiesSocial committee eventsAnnual allowance for Semex Shop to purchase Semex / Boviteq branded clothing and merchandiseThis 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.At Semex / Boviteq we strive to have team members feel empowered and valued, contributing to our success. We take pride in the diverse community that makes up the fabric of our company. From the salesperson at the farm gate to the lab technician, everyone works purposefully and meaningfully. We’re not afraid of hard work, hold each other accountable, and act guided by our core values. If this sounds like you, let’s talk!***Semex/ Boviteq encourages people with disabilities to apply. Accommodations are available throughout the recruitment process upon request by contacting Voir email sur ca.hrm.tc .At Semex/ Boviteq we are committed to protecting your personal information. By applying you consent to the collection and use of your personal data for recruitment purposes, in accordance with applicable privacy laws. Artificial intelligence (AI) may be used during the recruitment process. Please note the terms used in this posting are used generically and refer to people of all genders. We are dedicated to fair and transparent hiring practices and will notify applicants of the outcome within 45 days of their final interview.We thank all applicants for applying for this position, but only those considered for an interview will be contacted.
#J-18808-Ljbffr