Data Management Analyst

• Position: Data Management Analyst (ETL and Microsoft BI)
• Reports to: Lead, Data Management
• Contract Type: Fixed-Term Three-Year Contract (with possibility of extension based on business needs and performance)
• Salary Range: $72,000-$90,000 per year
• Benefits: Comprehensive group benefits and private pension plan
• Location: Hybrid (remote and on-site)
• Work Environment: Inclusive, innovative, and growth-oriented culture at the forefront of laboratory referral testing.
• Primary Focus: Enterprise data operations and system integrations; SQL Server ETL pipelines and automation; Reporting and analytics; Data quality, security, and healthcare privacy.

The Opportunity

We are looking for an experienced Data Management Analyst to support and strengthen enterprise data operations, integrations, ETL (Extract, Transform, Load) workflows, and reporting. The role supports critical data pipelines and reporting processes used by business, clinical, and laboratory teams, ensuring data is accurate, secure, and available when needed. This position works hands-on with Microsoft SQL Server technologies, business intelligence tools, and secure data transfers in a healthcare environment where data quality, reliability, and privacy are essential. If you like working with data that matters and troubleshooting complex issues, this role supports meaningful operational impact in healthcare.

Key Areas of Responsibility·

• Support daily data operations to ensure timely and accurate data delivery.
• Monitor, troubleshoot, and maintain secure file-based data transfers using File Transfer Protocol (FTP).
• Develop and support ETL pipelines using SQL Server Integration Services (SSIS).
• Write, optimize, and support SQL and Transact-SQL (T-SQL) queries, procedures, and views.
• Build and maintain reports using Power BI and SQL Server Reporting Services.
• Investigate and resolve data quality, integration, and reporting issues.
• Maintain clear documentation for data processes, integrations, and reporting logic. Support Key Performance Indicator (KPI), operational, and management reporting.
• Work with stakeholders to translate reporting needs into reliable outputs.
• Ensure compliant handling of Personal Health Information (PHI).

Hands-on Experience Needed to Excel in This Role

• Microsoft SQL Server Management Studio (SSMS) for data analysis and troubleshooting. SQL SSIS for ETL workflows (Visual Studio).
• Secure file-based and FTP data integrations.
• Power BI report and dashboard development (datasets, refresh, publishing, access control).
• Automation, monitoring, and recovery of scheduled data jobs.
• Scripting or programming (PowerShell, Python, C#/.NET, or similar).

Qualifications

Education:

• Bachelor's degree in computer science, Information Systems, Data Analytics, Software Engineering, or Health Informatics or an equivalent combination of education and hands-on experience.

Experience:

• Proven hands-on experience with Microsoft SQL Server integration, reporting, and management tools.
• Strong SQL / T-SQL skills, including performance tuning and validation.
• Demonstrated experience building and supporting automated ETL pipelines.
• Experience developing and maintaining Power BI reports and datasets.
• Experience supporting file-based integrations and FTP transfers.
• Familiarity with PHIPA (Personal Health Information Protection Act) and PHI handling.
• Ability to manage multiple priorities in a time-sensitive operational environment.

Key Competencies

• Exceptional attention to detail and commitment to data quality
• Strong communicator with both technical and non-technical stakeholders.
• Proactive approach to operational data support and issue resolution.
• Disciplined documentation practices (runbooks, mappings, logic, change tracking). Comfort working across data engineering, reporting, and enterprise systems.
• Professional and confidential handling of sensitive healthcare data.

Why Join Us?

At In-Common Laboratories (ICL), we are dedicated to transforming lives through innovative healthcare and community support services.

• Meaningful mission with real health sector impact.
• Collaborative, supportive executive leadership.
• Opportunities to make an immediate impact, optimize operations, and expand your expertise.

Selection Process Transparency

• Artificial intelligence is not used to screen, assess, or select applicants.
• This posting is for an existing vacancy.

Equal Opportunity & Accessibility·

• ICL is an equal opportunity employer. Accommodation for applicants with disabilities is available upon request.

Job Types: Full-time, Fixed term contract

Pay: $72,000.00-$90,000.00 per year

Work Location: Hybrid remote in North York, ON