System Analyst, Intermediate

Role overview

Work arrangement

• Candidates must work in-office at least three days and up to five days per week in Guelph, Ontario.

Responsibilities

• Translate business needs into functional, system, and data requirements for analytics and reporting.
• Evaluate systems, data flows, and integrations for gaps, risks, and optimization opportunities.
• Collaborate with stakeholders and IT teams to align solutions with business objectives and technical standards.
• Support data and analytics solution design and delivery, including integrations, pipelines, and reporting platforms.
• Maintain requirements, data mappings, process flows, and technical specifications.
• Support system testing and user acceptance testing.
• Troubleshoot system and data issues, conduct root cause analysis, and coordinate resolution.
• Support data ingestion, transformation, and validation in Microsoft Fabric.
• Develop and maintain SQL queries for reporting and analytics.
• Maintain analytics data models and support accurate, consistent Power BI datasets and reports.
• Work with data engineers on data governance and quality standards.

Education and experience

• Bachelor’s degree or equivalent practical experience.
• At least four years of system or business analyst experience and a strong understanding of system analysis concepts and data flows.
• Proven experience building, training, testing, and deploying machine learning models.
• Strong foundation in statistics, linear algebra, calculus, and computer science.
• Experience in data science analysis, tooling, and applied methodologies.
• Experience with Power Platform and/or a professional development stack.
• Experience with Power BI and Microsoft Fabric.
• Working knowledge of SQL and data warehouse concepts.
• Experience leading AI-related initiatives such as machine learning and deep learning within applications.

Additional qualifications

• Experience supporting analytics or reporting solutions; Power BI is preferred in this qualification.
• Strong analytical, problem-solving, documentation, stakeholder communication, and attention-to-detail skills.
• Knowledge of Microsoft Fabric Lakehouse, pipelines, and data models.
• Familiarity with Power BI datasets, reports, and basic DAX.
• Understanding of ETL and data integration concepts, data governance, and data quality practices.

Benefits and employer

• Benefits include drug, dental, and vision coverage, along with career advancement opportunities.
• The employer also mentions sustainability, community outreach, and local vendor and event discounts.
• Linamar is a Canadian-founded global manufacturer focused on engineering and product development.