Data Solutions Consultant

Klick • Toronto, ON

2d • CA$85,000 - CA$105,000 • Hybrid

About The Position

The Data Engineer supports analytics and omnichannel initiatives by designing, building, and maintaining data infrastructure and pipelines that enable scalable, data-driven outcomes. This role works closely with Analytics, Data Science, and Enablement partners to translate requirements into reliable, high-quality data solutions. The focus is on engineering rigor, platform performance, and delivering the data foundation that powers insights across teams and clients.

Requirements

• Strong SQL proficiency — query writing, optimization, and database investigation are core to this role
• Hands-on experience building and maintaining ETL pipelines and data ingestion workflows
• Working knowledge of PySpark for large-scale data processing
• Experience with Microsoft Fabric or similar modern data platforms
• Solid understanding of end-to-end system architecture and how data moves through it
• Experience translating technical concepts for non-technical stakeholders, including gathering requirements from clients or business partners

Nice To Haves

• Comfort and enthusiasm for using AI as a regular part of how work gets done
• Experience in healthcare, life sciences, media, or agency environments, including marketing or payer analytics datasets
• Experience working with advertising APIs (e.g. Google Ads, Meta, or similar platforms)
• Advanced degree (Master’s or Ph.D.) in Computer Science, Data Engineering, Data Science, or a related quantitative field
• Knowledge of database design and data modeling principles within modern analytics platforms
• Experience with data visualization tools such as Power BI
• Familiarity with CI/CD pipelines or Git-based version control

Responsibilities

• Collaborate with Analytics, Data Science, and Enablement partners to gather requirements and translate business needs into data engineering solutions using Python and SQL
• Design, build, and maintain ETL pipelines and ingestion notebooks to move and transform data across systems
• Work extensively in Microsoft Fabric to develop and manage data workflows and infrastructure
• Write and optimize SQL queries for performance, troubleshooting, and data investigation
• Investigate and resolve data issues in databases using SQL, identifying root causes and implementing fixes
• Build scalable PySpark-based solutions for large-scale data processing and transformation
• Develop a strong understanding of system architecture and data flows to support reliable pipeline operations

Benefits

• Consistently named a Best Managed Company, Most Admired Corporate Culture, and Great Place to Work
• committed to fostering a high-performance, people-first culture with creativity, collaboration, innovation, and impact across everything we do.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level