Business Intelligence (BI) Data Engineer

Cmsa Ascv

Guelph

Vor Ort

CAD 77.000 - 94.000

Vollzeit

Vor 8 Tagen

Eine vollständige Bewerbung in einer Minute

Maßgeschneiderter Lebenslauf und Anschreiben – versandbereit.

Schaffe es an den ATS-Filtern vorbei

Benefits dieser Stelle

Extended health and dental coverage
Disability coverage
Employee & Family Assistance Program
Defined Contribution Pension Plan
Competitive salary

Zusammenfassung

Semex / Boviteq in Guelph, Ontario is seeking a Business Intelligence Data Engineer to design, develop and support scalable data products using Microsoft Fabric, Power BI and related Microsoft technologies. This in-person role requires three days per week in our Guelph location, with a minimum starting salary of $85,000 per year and opportunities for compensation enhancements based on experience.

You will collaborate with IT and business stakeholders to deliver trusted reports, self-service

Qualifikationen

  • Bachelor's degree or college diploma in Computer Science, Information Systems, Computer Programming, Data Analytics or related discipline.
  • 2-3 years of experience in business intelligence, data engineering, analytics engineering or 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 assets (Fabric Analytics Engineer Associate, Power BI Data Analyst Associate, Azure Fundamentals) considered assets.

Aufgaben

  • 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 and external services.
  • Create reusable ingestion and transformation processes using SQL, notebooks, Dataflows Gen2 and pipelines.
  • Ensure solutions meet performance, reliability, security and supportability requirements.
  • Design and maintain enterprise semantic models aligned with business definitions and security standards.
  • Develop clear, accessible 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 AI-enabled and agentic solutions using Microsoft Fabric, Copilot Studio, Power Platform and related services.
  • Contribute to evaluating and adopting emerging Microsoft data, analytics and AI capabilities.

Kenntnisse

Power BI
SQL
Data Modeling
ETL/ELT
DAX
Microsoft Fabric

Ausbildung

Bachelor's degree or college diploma in Computer Science, Information Systems, Computer Programming, Data Analytics

Tools

SQL Server
SSIS
SSAS
Azure

Jobbeschreibung

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 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 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, 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 dependents
  • Short and long-term disability coverage
  • Employee & Family Assistance Program
  • 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

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.

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 talentmanagement@semex.com .

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.

Hol dir deinen kostenlosen, vertraulichen Lebenslauf-Check.

oder ziehe deine Datei hierhin.

Similar jobs

Ähnliche Jobs, die dir auch gefallen könnten

Business Intelligence (BI) Data Engineer
Business Intelligence (BI) Data Engineer

Semex • Guelph

Vor Ort
CAD 77.000 - 94.000
Extended health & dental
Disability coverage
Employee & Family Assistance Program
+3
D365 Business Process Specialist Lead
D365 Business Process Specialist Lead

Cmsa Ascv • Guelph

Hybrid
CAD 75.000 - 92.000
Benefits program including extended/he
Disability coverage
Employee Assistance Program
+2
D365 Business Process Specialist Lead
D365 Business Process Specialist Lead

Semex • Guelph

Hybrid
CAD 75.000 - 92.000
Extended health & dental
Disability coverage
Employee Assistance Program
+1
D365 Project Manager
D365 Project Manager

Semex • Guelph

Hybrid
CAD 77.000 - 94.000
Extended health & dental care
Disability coverage
Employee Assistance Program
+2
D365 Project Manager
D365 Project Manager

Cmsa Ascv • Guelph

Hybrid
CAD 77.000 - 94.000
Benefits program
Disability coverage
Pension plan
+2
un(e) ingénieur(e) de données BI
un(e) ingénieur(e) de données BI

SEMEX • Guelph

Vor Ort
CAD 77.000 - 94.000
Santé et mieux-être
Régime de retraite de l’employeur
Congés payés et équilibre travail-vie
Global Product Manager - HerdStrong 360
Global Product Manager - HerdStrong 360

SEMEX • Guelph

Hybrid
CAD 81.000 - 99.000
Comprehensive benefits program
Disability coverage
Pension plan with employer matching
+2
Global Product Manager - HerdStrong 360
Global Product Manager - HerdStrong 360

Cmsa Ascv • Guelph

Hybrid
CAD 81.000 - 99.000
Health & dental
Disability coverage
Employee Assistance Program
+2
Laboratory Assistant
Laboratory Assistant

Semex • Saint-Hyacinthe

Vor Ort
CAD 23.000 - 32.000
Comprehensive health benefits
Disability coverage
Employee & Family Assistance Program
Donor Care Specialist
Donor Care Specialist

SEMEX • Saint-Hyacinthe

Vor Ort
CAD 24.000 - 34.000
Comprehensive benefits
Disability coverage
Employee & Family Assistance Program
+2