Data Solutions Consultant

Klick; Toronto; On-site; CAD 75,000 - 90,000; Full time

Job summary

A leading healthcare analytics firm in Toronto is seeking an experienced analytics professional to join their team. You will design and maintain data architecture, develop data pipelines, and work collaboratively with diverse teams. The ideal candidate has 4-5 years of experience, strong skills in ETL, Python, and SQL. This full-time role supports innovation in a growing environment, appealing to candidates from diverse backgrounds.

Qualifications

• 4-5 years of hands-on practical experience in ETL processing for data analysis.
• 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.
• Experience with Business Intelligence platforms.

Responsibilities

• Collaborate with analytic team members to define project scope.
• Design, develop, optimize, and maintain data architecture and pipelines.
• Maintain enterprise data warehouse.
• Build analytic products in various forms.
• Foster a culture of sharing and efficiency in data engineering.

Skills

ETL processing

Python

SQL

Data analysis

Business Intelligence platforms

Education

Post-secondary education in computer science

Tools

Power BI

Microsoft Fabric

Tableau

Snowflake

Job description

About Klick Health

Meet a different kind of workplace. 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