Intermediate System Analyst

Thornhill Medical

. Analyze business needs and translate them into functional, system, and data requirements for analytics and reporting solutions .

Posted 11/4/2026full-timeGuelph • CanadaMid-LevelSenior💰 CA$70,000 - CA$90,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in analyzing business needs and translating them into functional and data requirements for analytics solutions, with strong capabilities in SQL, Power BI, and Microsoft Fabric. Proficient in system analysis, data governance, and machine learning methodologies to support data-driven decision-making.

Highest-signal resume keywords

SQL DevelopmentPower BI ReportingMicrosoft FabricData GovernanceMachine Learning

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

System AnalysisData FlowsData IntegrationETL ConceptsData ModelingStatistical AnalysisApplied Data ScienceMachine Learning ModelsDAXData Validation

Soft Skills

Analytical SkillsProblem-SolvingAttention to DetailCommunication SkillsDocumentation Skills

Tools & Technologies

Power PlatformData PipelinesReporting PlatformsData Warehouse ConceptsData Quality Standards

Industry Keywords

Data AnalyticsBusiness AnalysisData Governance Best PracticesAI-related DomainsData Accuracy

Tech Stack

Tools & technologies

ETLSQL

About the role

Key responsibilities & impact

Analyze business needs and translate them into functional, system, and data requirements for analytics and reporting solutions
Evaluate existing systems, data flows, and integrations to identify gaps, risks, and optimization opportunities
Collaborate with business stakeholders and IT teams to align solutions with business objectives and technical standards
Support the design and delivery of data and analytics solutions, including system integrations, data pipelines, and reporting platforms
Maintain system and data documentation, including requirements, data mappings, process flows, and technical specifications
Support system testing and user acceptance testing
Troubleshoot system and data-related issues, perform root cause analysis, and coordinate resolution with technical teams
Support data ingestion, transformation, and validation activities in Microsoft Fabric
Develop and maintain SQL queries for reporting and analytics
Assist in maintaining data models used for analytics and Power BI
Support Power BI datasets and reports, ensuring data accuracy and consistency
Work with data engineers to ensure data governance and quality standards

Requirements

What you’ll need

Bachelor’s degree or equivalent practical experience
Minimum of 4+ years prior experience as a System or Business Analyst
Strong understanding of system analysis concepts and data flows
Experience building, training, testing, and deploying machine learning models
Strong mathematical foundation in statistics, linear algebra, calculus, and computer science
Experience with data analysis, tooling, and applied data science methodologies
Experience with Power Platform and/or a professional development stack
Experience with Power BI & Fabric
Working knowledge of SQL and data warehouse concepts
Experience leading initiatives in AI-related domains such as machine learning and deep learning within applications
Experience supporting analytics or reporting solutions
Strong analytical, problem-solving, documentation, communication, and attention-to-detail skills
Knowledge of Microsoft Fabric, including Lakehouse, pipelines, and data models
Familiarity with Power BI datasets, reports, and basic DAX
Understanding of ETL/data integration concepts
Knowledge of data governance and data quality best practices
Ability to work in-office a minimum of 3 days per week and up to 5 days per week in Guelph, ON

Benefits

Comp & perks

Competitive Compensation
Employee Benefits package includes but not limited to, Drug, Dental & Vision etc.
Opportunities for career advancement.
Sustainability Counsel
Community based outreach supporting both local and global initiatives and charities.
Discounts for local vendors and events, including auto supplier discounts.
Accessibility accommodations throughout all stages of the recruitment process upon request.