Apply now

Posted 1 hour ago

Specialist- Data & Analytics

@ Chartwell

Mississauga, Ontario

Full-time3+ years experience
Apply now
SIGNALS

Overview

Chartwell is hiring a hands-on Data and Analytics Specialist to design, troubleshoot and support enterprise data solutions on Snowflake, Azure Data Factory, Azure Data Lake, SQL, Python and Power BI. The work centres on investigating production pipeline failures, tracing data lineage and delivering reliable fixes with limited supervision. The role is full-time, hybrid with a primarily corporate office environment, and may require extended hours during incidents and deployments.

Responsibilities:

  • Design and support ETL/ELT pipelines using Azure Data Factory, Azure Data Lake and Snowflake
  • Investigate and troubleshoot production data issues across pipelines, Snowflake objects and reports
  • Write and debug advanced SQL, Snowflake objects and Python automation
  • Develop and maintain Power BI reports and semantic models

Requirements summary:

  • 3 to 5 years of hands-on enterprise data solution experience
  • Strong practical Snowflake experience
  • Proficiency with Azure Data Factory, Azure Data Lake and Azure Functions
  • Strong Python and advanced SQL skills
  • Power BI experience including DAX and Power Query
  • Snowflake certification is an asset

Tools & skills

Source and dates

Employer career site / ATS feed · oraclecloud

Employer posting date
2026-11-16
First seen by our source
2026-11-16
Source record updated
2026-11-16

These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.

Job details

SeniorityMid level
DepartmentData & analytics
Experience3+ years
Hours per week40 (estimated)
Scheduleovertime
Travelair: none · ground: none
Work settingOffice
PositionMostly sitting
Physical demandsphysical low · computer high
LanguagesEnglish
Encouraged to applyPeople with disabilities
EducationBachelor’s degree (required), Master’s degree (preferred)
Fields of studyComputer Science, Engineering, Mathematics

Summary and details written by AI from the posting; the employer’s posting is the authority.

Chartwell

Saved company profile

Historical company information from a saved The Jobs API profile (LinkedIn/Crunchbase fields). It is not live-verified; figures may have changed. Missing values remain unknown.

Making People's Lives Better

Full company description

At Chartwell Retirement Residences, we’re all about Making People’s Lives BETTER: the lives of our residents and their families, and the lives of our employees. Join an exceptional group of diverse, inspiring, and caring people who are empowered to provide personalized, human experiences for our residents and staff through the connections they make every day within our communities. Chez Chartwell résidences pour retraités, nous sommes dédiés au MIEUX-ÊTRE de nos résidents, de leurs proches et de nos employés. Rejoignez une équipe exceptionnelle et diversifiée de gens inspirants, qui ont à cœur d’offrir des expériences personnalisées, fondées sur des relations chaleureuses et humaines, à tous ceux et celles qui vivent et travaillent dans nos résidences.

LinkedIn followers
46,907
People associated on LinkedIn
4,395
Reported office locations
  • 7070 Derrycrest Dr, Mississauga, Ontario L5W 0G5, CA
Business categories
  • Health Care
  • Elder Care
  • Nursing and Residential Care
Other recorded names
  • Chartwell
  • Chartwell Career Site English
  • Chartwell Retirement Residences
Profile identifies a recruitment agency
No
Reported total investment
568,322,903

Currency and observation date were not supplied; this is not a current valuation or a funding round.

At Chartwell Retirement Residences, we’re all about Making People’s Lives BETTER: the lives of our residents and their families, and the lives of our employees. Join an exceptional group of diverse, inspiring, and caring people who are empowered to provide personalized, human experiences for our residents and staff through the connections they make every day within our communities. Chez Chartwell résidences pour…

FieldValue
IndustryHospitals and Health Care
Company size10,001+ employees
HeadquartersMississauga, Ontario
Organization typePublic Company
Open jobs on Jobsy740
LinkedInView page
Job description

The Opportunity

We are seeking a highly skilled and hands-on Data and Analytics Specialist to join our growing Data and Analytics team. This role requires strong practical experience designing, developing, troubleshooting, and supporting enterprise data solutions using Snowflake, Azure Data Factory, Azure Data Lake, SQL, Python, and Power BI.

The successful candidate will be expected to become productive quickly within an established enterprise data environment. While business and domain knowledge will be provided through onboarding, the candidate should already possess the technical depth, troubleshooting capability, and independence required to work effectively with complex production data solutions.

This is a hands-on technical delivery role. The successful candidate must be comfortable investigating unfamiliar code and pipelines, tracing data and dependencies across multiple layers, identifying root causes, assessing downstream impacts, and implementing reliable production-ready solutions with limited technical hand-holding.

Key Accountabilities

  • Design, develop, optimize, and support robust ETL/ELT pipelines and enterprise data solutions using Azure Data Factory, Azure Data Lake, and Snowflake.
  • Independently investigate and troubleshoot complex production issues, tracing data across source systems, ADF pipelines, ADLS, Snowflake objects, transformations, business logic, and downstream reporting.
  • Write, read, modify, and debug advanced SQL, Snowflake views, stored procedures, streams, tasks, UDFs, and existing production code, including solutions developed by other team members.
  • Perform thorough root-cause analysis for pipeline failures, data discrepancies, performance issues, and unexpected system behaviour, including situations where the failure point is not immediately known.
  • Analyze existing data models, SQL logic, pipeline dependencies, transformations, and downstream consumers to determine end-to-end lineage and impact before implementing changes.
  • Develop and deploy scalable Python scripts and Azure Functions for automation, integrations, data processing, and advanced analytics use cases.
  • Develop and maintain Power BI reports, semantic models, datasets, measures, and transformations, including troubleshooting data and performance issues.
  • Translate business requirements into reliable and maintainable technical solutions while proactively identifying technical risks, dependencies, and data-quality concerns.
  • Support production data quality, reconciliation, governance, documentation, and metadata management practices.
  • Monitor and optimize production solutions for performance, reliability, scalability, automation, and maintainability.
  • Contribute to enterprise data models and technical standards while working effectively across both new development and established/legacy solutions.
  • Take ownership of assigned technical problems from initial investigation through resolution, validation, deployment, and post-production verification.

Qualifications

Education:

  • Undergraduate degree in Computer Science, Engineering, Mathematics, or related STEM field; a Master’s degree is an asset.

Experience:

  • Minimum 3–5 years of substantive hands-on experience designing, developing, debugging, and supporting enterprise data solutions using a modern cloud data stack.
  • Strong hands-on Snowflake experience, including practical use and troubleshooting of:
    • SQL and complex transformations
    • Views and stored procedures
    • Streams and Tasks
    • UDFs
    • Query execution and performance troubleshooting
    • Data lineage and dependency analysis
  • Strong practical experience with:
    • Azure Data Factory
    • Azure Data Lake Storage
    • Azure Functions
    • Advanced SQL development and debugging
    • Python for data processing and automation
  • Demonstrated experience supporting production data pipelines and business-critical analytics solutions, including independently diagnosing failures and data discrepancies across multiple technology layers.
  • Experience working with existing enterprise codebases and unfamiliar data solutions, where investigation and back-tracing are required before changes can be made.
  • Snowflake certification (e.g., SnowPro Core or Advanced) is an asset; however, certification does not replace demonstrated hands-on technical proficiency.

Skills & Abilities:

  • Strong practical experience with Power BI, including semantic models, Power Query, DAX/measures, troubleshooting, and performance considerations.
  • Demonstrated ability to receive an unfamiliar data problem and independently trace the technical flow, isolate the root cause, determine downstream impact, recommend a solution, and implement the fix.
  • Strong ability to understand and troubleshoot SQL, Python, ADF pipelines, Snowflake stored procedures, data models, and existing business logic developed by others.
  • Strong analytical and problem-solving ability, particularly in situations where requirements are incomplete or the source of an issue is ambiguous.
  • Ability to work independently with limited technical supervision after initial business and environment onboarding.
  • Experience with DevOps, Git/GitHub, deployment practices, and source control is a strong asset.
  • Strong communication skills with the ability to clearly articulate technical findings, solution options, dependencies, and risks to technical and business stakeholders.
  • Strong ownership mindset with the ability to manage work from problem identification through production resolution while collaborating effectively within a fast-paced team.

Effort

  • Requires sustained mental focus for complex troubleshooting, root-cause analysis, data lineage investigation, coding, pipeline optimization, and report development.
  • Requires frequent hands-on use of cloud data platforms, development tools, query interfaces, logs, and monitoring systems for extended periods.
  • Requires the ability to move between new development, production support, debugging, and multiple stakeholder priorities.
  • High attention to detail is required when modifying existing production solutions, validating data, assessing downstream dependencies, and implementing technical changes.

Working Conditions

  • Work is primarily performed in a corporate office environment with the flexibility of a hybrid work model.
  • May involve occasional extended hours during production incidents, system deployments, data migrations, or critical project deadlines.
  • Requires regular collaboration with cross-functional business and technical teams.
  • Must be comfortable working in a fast-paced and evolving enterprise data environment where troubleshooting existing solutions is as important as developing new ones.

*Candidates should be prepared to demonstrate practical problem-solving and hands-on technical proficiency with Snowflake, SQL, and data pipeline troubleshooting as part of the interview process.

#INDCOR

At Chartwell, we’re all about Making People’s Lives BETTER: the lives of our residents and their families, and the lives of our employees. Join an exceptional group of diverse, inspiring, and caring people who are empowered to provide personalized, human experiences for our residents and staff through the connections they make every day within our communities.

Chartwell’s commitment to diversity and inclusivity is a commitment to hiring people whose skills and abilities contribute the most to the success of the organization and who reflect the communities in which we live and work. We are an equal opportunity employer and welcome applications from a wide range of qualified candidates, including people with disabilities. If you have questions or require assistance with the application process, please email [email protected] or call 1-888-663-6448.

Chartwell may use artificial intelligence to assist in screening and assessing applicants for this position.

We thank all applicants for their interest, however, only those selected for further consideration will be contacted.

Similar jobs

  • Loss Preventon Manager Central

    Mississauga, ON

    Purolator: is a leading integrated freight, package and logistics solutions provider.

    Conduct investigations/interviews as required; 3+ years of security related experience.3+ year of supervisory / leadership experience; Valid Driver’s license and clear abstract is required

  • Certified Dental Assistant - 13108

    Mississauga, ON
    Full Time

    Dentist

    Experience with dental practice management software such as Abeldent and Tracker is considered an asset; Demonstrated ability to communicate effectively with patients and families

  • Financial Service Representative

    Mississauga, ON
    $18–$20.50/hr

    Money Mart

    Team Members must deliver excellent customer service while following company policies, regulatory requirements, and responsible lending practices; Promote, recommend, and process loans, credit cards, cheque cashing,…

  • Change Manager (Project Controls)

    Mississauga, ON
    On-site

    PACT

    This multi-year program is designed to address immediate passenger growth demands while preparing Canada’s largest airport for the future of air travel—including critical upgrades to…; It requires 10+ years of relevant…

  • Human Resources Coordinator

    Mississauga, ON

    Willson International Ltd.

    2+ YOEWillson International needs 2-4 years of HR administration, recruitment or payroll support experience, plus a diploma or degree in HR or business. Candidates need HRIS and Excel skills, strong attention to detail and experience supporting Canadian and U.S. employees.

    Microsoft Excel, Microsoft Office, HRIS, Payroll systems, Applicant tracking system

  • Marketing Coordinator

    Mississauga, ON
    $50k–$65k/yrOn-site

    Ontario Impex of Canada

    2+ YOECandidates need a diploma or degree in marketing or a related field and 2 to 4 years of marketing or brand experience. Strong skills in Microsoft Office, Canva, Adobe Creative Suite and web-based marketing tools are required, along with a valid driver's licence and reliable transportation.

    Microsoft Office, Canva, Adobe Creative Suite

    Maintenance Technician - Millwright

    Mississauga, ON
    $38–$45/hrOn-site

    Ontario Impex of Canada

    5+ YOECandidates need a Red Seal millwright (433A) certification or a recognized community college program, five years of hands-on experience, and electrical experience as an asset. Strong troubleshooting, communication and multi-tasking skills are required.

    Welding equipment, Plasma cutter, Packaging equipment, Metal detector, Weighing equipment, Label printer

  • Customer Business Development Representative

    Mississauga, ON
    HybridFull Time

    Maple Leaf Foods Inc.

    2+ YOECandidates need post-secondary education (business preferred), 2-3 years of sales or marketing experience, and strong analytical, communication and interpersonal skills. Proficiency in Microsoft Office and systems such as Cognos and BPCS is required, and experience with key accounts is an asset.

    Microsoft Office, Cognos, BPCS

Locations & environments

Locations

All of CanadaRemote · Hybrid · On-site · Field

Pro tip: add remote jobs to widen your search.

Exclude locations

Workplace type

Company jobs in these results

These are this company’s jobs loaded in your current search. The company may have more openings.