Specialist Data & Analytics

Chartwell • Mississauga, ON

17h • Hybrid

About The Position

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.

Requirements

• Undergraduate degree in Computer Science, Engineering, Mathematics, or related STEM field; a Master’s degree is an asset.
• 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).
• Functional experience with data visualization tools (e.g., Power BI) is required.
• Strong analytical, communication, and problem-solving skills.
• Demonstrated ability to work independently and collaboratively in a fast-paced environment.

Nice To Haves

• DevOps practices is a strong asset.

Responsibilities

• 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.

Benefits

• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level