Data Solutions Consultant

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
• Required:
• 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
• This 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
• Our Commitment to Inclusion

Benefits

Additional Information

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.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at Klick1? Share your experience