Specialist Data & Analytics

Chartwell Retirement Residences; Mississauga; Hybrid; CAD 85,000 - 125,000; Full time

Job summary

Chartwell Retirement Residences is seeking a Data and Analytics Specialist to join our growing Data and Analytics team. You will design, develop, and optimize data solutions across the organization using Snowflake, Azure, SQL, Python, and Power BI.

The role focuses on building robust data pipelines, collaborating with stakeholders, and contributing to governance and metadata practices while staying current with industry trends in cloud data engineering.

Qualifications

• Undergraduate degree in Computer Science, Engineering, Mathematics, or related STEM field.
• Master’s degree is an asset.
• Snowflake certification preferred.
• 3–5 years of experience with a modern data stack.
• Experience with Snowflake, Azure Data Factory/Data Lake/Azure Functions, SQL, Python.

Responsibilities

• Develop, optimize, and maintain data pipelines using Azure Data Factory, Data Lake, and Snowflake.
• Write and debug SQL queries and Snowflake stored procedures.
• Create Python scripts and Azure Functions for automation and analytics.
• Collaborate with stakeholders to translate data needs into technical specifications.
• Support data governance, quality assurance, and metadata management.
• Contribute to enterprise data models and pipelines design.
• Develop and maintain Power BI reports, dashboards, and semantic models.
• Monitor pipeline performance for reliability and scalability.
• Stay current with cloud data engineering trends.

Skills

Power BI

SQL

Python

Azure

Data modeling

Education

Bachelor's degree in Computer Science, Engineering, Mathematics, or related STEM field

Tools

Snowflake

Azure Data Factory

Azure Data Lake

Azure Functions

Job description

The Opportunity

We are seeking a highly skilled and motivated Data and Analytics Specialist to join our growing Data and Analytics team. The ideal candidate will bring deep technical expertise in Snowflake, Azure cloud services, SQL, Python and Power BI, to help design, develop, and optimize data solutions that support strategic initiatives across the organization.

Job Description

We are seeking a highly skilled and motivated Data and Analytics Specialist to join our growing Data and Analytics team. The ideal candidate will bring deep technical expertise in Snowflake, Azure cloud services, SQL, Python and Power BI, to help design, develop, and optimize data solutions that support strategic initiatives across the organization.

Key Accountabilities

• Develop, optimize, and maintain robust data pipelines and ETL processes using Azure Data Factory, Azure Data Lake, and Snowflake.
• Write, read, and debug complex SQL queries and Snowflake stored procedures to support data transformation and reporting needs.
• Create and deploy scalable Python scripts and Azure Functions for automation, data processing, and advanced analytics.
• Collaborate with business stakeholders to understand data requirements and translate them into technical specifications.
• Support data governance, quality assurance, and metadata management practices across the organization.
• Contribute to the design and documentation of enterprise data models and pipelines.
• Develop and maintain analytical reports, dashboards and semantic models using Power BI
• Monitor pipeline performance and implement improvements for reliability, scalability, and efficiency.
• Stay current with industry trends and best practices in cloud data engineering and analytics.

Qualifications

Education

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

Experience

• Snowflake certification (e.g., SnowPro Core or Advanced Architect) strongly preferred.
• At least 3-5 years of experience using a modern data stack with hands-on use of:
  • Snowflake (warehousing, streams, tasks, UDFs)
  • Azure Data Factory, Azure Data Lake, Azure Functions
  • SQL (advanced query development and debugging)
  • Python (data processing and automation)

Skills & Abilities

• Functional experience with data visualization tools (e.g., Power BI) is required.
• DevOps practices is a strong asset.
• Strong analytical, communication, and problem-solving skills.
• Demonstrated ability to work independently and collaboratively in a fast-paced environment.

Effort

• Requires sustained mental focus for data analysis, debugging, pipeline optimization, and report development
• Involves frequent use of computer systems and cloud-based tools for extended periods
• Requires multitasking and prioritizing requests from multiple stakeholders in a dynamic environment
• Attention to detail is critical when handling complex data queries, coding scripts, and quality checks

Working Conditions

• Work is primarily performed in a corporate office setting with the flexibility of a hybrid work model
• May involve occasional extended hours during system deployments, data migrations, or project deadlines
• Requires regular virtual collaboration with cross-functional teams and business stakeholders
• Must be comfortable working in a fast-paced, agile, and evolving technical environment

About Us

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 [e-mail] 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.