Data Engineering Consultant

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

Job summary

A leading company in advertising services is seeking a Mid-Senior level Data Engineer to design and maintain data solutions. The role involves collaborating with stakeholders, optimizing data architecture, and utilizing tools like Python and SQL. If you have a passion for data and a drive to innovate, this is the opportunity for you.

Qualifications

• 4-5 years of hands-on practical experience in data analysis and modeling.
• Minimum 2 years of working knowledge in Python and SQL.
• Experience with clickstream data sets and data lakes.

Responsibilities

• Collaborate with team members to define project data needs.
• Design, develop, and maintain data architecture and pipelines.
• Build analytic products and maintain enterprise data warehouse.

Skills

ETL Processing

Python

SQL

Data Analysis

Business Intelligence

Education

Post-secondary education in computer science

Tools

Power BI

Microsoft Fabric

Tableau

Snowflake

Git

Job description

Get AI-powered advice on this job and more exclusive features.

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

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Engineering and Information Technology

Industries

• Advertising Services