Job DescriptionThe 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.
What You'll Do- 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
QualificationsRequired:- 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
Desired:- 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
Additional InformationThis posting is for an existing vacancy at Klick. The base salary range for this position is between CAD $85,000 - $105,000. The final amount offered will be determined based on several factors such as a candidate's work location, their unique skill set, education, and prior work experience.
#LI-TH1 #LI-Hybrid
