Data Analytics Virtual Intern Jobs in Hamilton, ON

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.

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

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                            

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 accessibility@chartwell.com 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.