Data Engineering Consultant

Klick Health; Toronto; Hybrid; CAD 60,000 - 100,000; Full time

Job summary

An established industry player is seeking a data-driven professional to join their innovative team. This role focuses on designing and maintaining cutting-edge data solutions that drive impactful client engagements. As part of a collaborative environment, you'll leverage your expertise in ETL processing, Python, and SQL to navigate complex datasets and contribute to analytics innovation. If you possess a passion for uncovering insights and thrive in a fast-paced setting, this opportunity is perfect for you. Join a forward-thinking company where your love for data will be celebrated and your potential truly unleashed.

Qualifications

• 4-5 years of experience with ETL processing for data analysis.
• Minimum 2 years of working knowledge in Python and SQL.
• Experience with business intelligence platforms like Power BI and Tableau.

Responsibilities

• Collaborate with team members to define project data needs.
• Design and maintain data architecture and pipelines.
• Build analytic products and foster a culture of sharing and efficiency.

Skills

ETL Processing

Python

SQL

Data Analysis

Business Intelligence

Clickstream Data

Data Lakes

Stakeholder Management

Education

Post-secondary education in computer science

Tools

Google Ads - Campaign Manager

Power BI

Microsoft Fabric

Tableau

Snowflake

Git Management

Job description

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. And we’re still growing fast, even after two decades. What does that mean for you? As Klick experiences exponential growth year-over-year, so do the people who help make it happen. Because we’re constantly evolving and changing, we invest in talent early and often, to develop future leaders at all levels.

As an integral part of our forward-thinking team, you'll collaborate closely with top-tier professionals to design, develop, and maintain cutting-edge data solutions. Embrace the challenge of handling growing datasets and navigating the ever-evolving media landscape, all while pushing the boundaries of digital transformation.

This role isn't just about crunching numbers – it's about driving real impact by merging data solutions into client engagements and marketing sciences products. You'll work hand-in-hand with stakeholders to craft tailored solutions that meet our clients' unique needs, all while showcasing your expertise in both individual and team settings. Your code will serve as the bedrock of our service offering, ensuring optimal performance and maintenance of our systems.

But it's not just about technical prowess – we're seeking individuals with insatiable curiosity, a drive to challenge the status quo, and a passion for uncovering insights that drive real change. If you're ready to dive deep, tackle complex challenges, and share your discoveries with peers and clients alike, then come join us on the forefront of analytics innovation. At Klick, your love for data will be celebrated and your potential truly unleashed.

Responsibilities

• Work in a collaborative manner and Interact with other 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).
• Deep understanding of Google Ads - Campaign Manager, TikTok, Facebook, LinkedIn, expected Nuance to each of those different
• Maintain enterprise data warehouse (Snowflake preferred but not required).
• Build analytic products in the form of presentations, data outputs, system integrations, business intelligence 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 Management, SOP creation, Requirement Maintenance).

Qualifications

• 4-5 years’ of hands-on practical experience with a minimum of 2 years’ of experience in ETL processing to be used for data analysis and modeling.
• Minimum 2 years of working knowledge in Python and SQL is a must.
• Experience in Microsoft Fabric is a HUGE plus, alongside Stitch.
• Experience working with clickstream data sets and data lakes is a must.
• 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.

#LI-TH1 #LI-Hybrid