Data Solutions Consultant

Klick; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading health services company in Toronto is seeking a Mid-Senior level Data Analyst. The ideal candidate will have hands-on experience in ETL processing, Python, and SQL, working collaboratively to build data architecture and analytic products. You will leverage your expertise in Business Intelligence platforms to guide marketing strategies. The company values a diverse and inclusive workplace and encourages applications from underrepresented communities.

Qualifications

• 4-5 years of hands-on practical experience with a minimum of 2 years in ETL processing for data analysis and modeling.
• Experience working with clickstream data sets and data lakes.
• Ability to gather requirements from non-technical stakeholders and clients.

Responsibilities

• Work collaboratively with analytic team members to define project scope.
• Design, develop, optimize, and maintain data architecture and pipelines.
• Build analytic products in various formats.

Skills

ETL processing

Python

SQL

Business Intelligence platforms

Education

Post-secondary education in computer science

Tools

Power BI

Tableau

Snowflake

Job description

Overview

About Klick Health

Klick Health is an ecosystem of brilliant minds working to realize the full potential of their people and clients in life sciences since 1997. As Klick experiences exponential growth year-over-year, so do the people who help make it happen. We invest in talent early and often to develop future leaders at all levels. We’re recognized as a Top 10 Great Workplace, 10 Most Inspiring Cultures, Best Workplace for Innovators, Best Managed, and Fastest Growing. If you feel like you’d be a good fit for this role, apply to start your career journey at Klick.

As part of our Analytics team, you’ll be at the forefront of the big data revolution, guiding marketing strategies for our diverse range of clients. If you’re ready to unleash your creativity and expertise in a fast-paced environment, join Klick.

Responsibilities

• Work in a collaborative manner with analytic team members, Data Analysts, Project Managers, and Business Analysts to learn project data needs and define project scope
• Design, develop, optimize, and maintain data architecture and pipelines that adhere to ETL principles and business goals (Python and SQL)
• Maintain enterprise data warehouse (Snowflake preferred but not required)
• Build analytic products in the form of presentations, data outputs, system integrations, BI platforms, and AI outputs
• Foster a culture of sharing, re-use, design for scale stability, and operational efficiency of code, queries, and data engineering processes (Git, SOPs, Requirements maintenance)

Qualifications

• 4-5 years of hands-on practical experience with a minimum of 2 years in ETL processing for data analysis and modeling
• Minimum 2 years of working knowledge in Python and SQL
• Experience working with clickstream data sets and data lakes
• Ability to gather requirements from non-technical stakeholders and clients
• Experience with Business Intelligence platforms such as Power BI, Microsoft Fabric, and Tableau

Bonus Points

• Healthcare experience
• Post-secondary education in computer science
• Demonstrate working knowledge in database design and management

Klick is consciously creating a culture where everyone can thrive and grow in their careers. We believe that our best work comes from our diverse backgrounds, perspectives, and skills. We strongly encourage members of historically underrepresented communities to apply, including Black people, Indigenous peoples, and other people of colour, people with disabilities, people from gender and sexually diverse communities and people with intersectional identities.

We’re also committed to developing an inclusive, barrier-free recruitment process and work environment. Should you require any accommodation, please contact us at [e-mail] and we will work with you to meet your accessibility needs and ensure you have a positive experience.

Details

• Seniority level : Mid-Senior level
• Employment type : Full-time
• Job function : Consulting, Information Technology, and Sales
• Industries : Advertising Services

J-18808-Ljbffr