Posted last month
Senior Data Solutions Consultant
@ Klick
Toronto, Ontario
Overview
Klick is hiring a Senior Data Solutions Consultant to design, build and optimize scalable data solutions for omnichannel marketing, analytics and AI-enabled products in life sciences. The role centres on Python and SQL ETL pipelines, enterprise data warehousing (preferably Snowflake) and business intelligence dashboards in Power BI, Microsoft Fabric or Tableau. The posting states a hybrid arrangement and a base salary of CAD $90,000 to $105,000.
Responsibilities:
- Build BI dashboards and AI-enabled data products in Power BI, Microsoft Fabric and Tableau
- Develop and optimize enterprise data warehouse solutions, preferably Snowflake
- Design and optimize scalable ETL pipelines using Python and SQL
- Gather technical requirements and define solution architecture with stakeholders
- Standardize engineering practices through reusable code, Git and documentation
Requirements summary:
- 4 to 5 years building scalable data solutions and ETL pipelines
- Experience with Python and SQL in production pipelines and data models
- Experience with clickstream datasets, data lakes and cloud data warehouses
- Experience delivering BI dashboards in Power BI, Fabric or Tableau
- Experience translating business needs into technical deliverables
Tools & skills
Source and dates
Employer career site / ATS feed · smartrecruiters
- Employer posting date
- 2026-09-28
- First seen by our source
- 2026-10-08
- Source record updated
- 2026-10-23
These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.
Job details
| Seniority | Senior |
| Department | Data & analytics |
| Experience | 4+ years |
| Hours per week | 40 (estimated) |
| Work setting | Office |
| Position | Mostly sitting |
| Physical demands | physical low · computer high |
| Languages | English |
| Encouraged to apply | Indigenous peoples, Racialized people, People with disabilities |
| Education | Bachelor’s degree (preferred) |
| Fields of study | Computer Science, Software Engineering, Data Engineering |
Summary and details written by AI from the posting; the employer’s posting is the authority.
Klick
Saved company profile
Historical company information from a saved The Jobs API profile (LinkedIn/Crunchbase fields). It is not live-verified; figures may have changed. Missing values remain unknown.
There's something different here.
Full company description
Klick Health is the world’s largest independent commercialization partner for life sciences. For over 25 years, Klick has been laser-focused on developing, launching, and supporting life sciences brands to maximize their full market potential as a core commercialization partner. Klick is opening offices in regional hubs and key markets to provide local support for our clients in countries outside of North America. These seven new offices are purpose-built to replicate the core components of our culture and values and be 100% dedicated to the pharma and life sciences business. We believe that when your people are the center of gravity, clients are the ultimate beneficiaries. Success, in its highest form, is always mutual. Our culture of kindness and high performance attracts innovators and leaders who care about doing the best work possible in an environment that supports their rapid growth. Together, we can turn any problem into a potentially life-changing opportunity.
- LinkedIn followers
- 158,559
- People associated on LinkedIn
- 1,892
- Reported office locations
- 175 Bloor Street East, Toronto, Ontario M4W 3R8, CA
- 240 W 40th St, 12th Floor, New York, NY 10018, US
- 510 Walnut St, 13th Floor, Philadelphia, Pennsylvania 19106, US
- 30 Stamford Street, London, SE1 9LQ, GB
- 109 North Bridge Road, #05-21, Singapore, 179097, SG
- Avenida Nacoes Unidas 14261, São Paulo, Cidade Monções 77500-000, BR
- Business categories
- Health Care
- Internet
- Life Science
- Other recorded names
- Klick
- Specialties
- Brand Strategy
- Clinical Review and Analysis
- Copywriting
- Creative Technology
- CRM Strategy
- Digital Media
- Disease Awareness
- Experience Design
- Film and Video
- Launch Tactical Readiness
- Machine Learning
- Media Planning
- Medical Editing
- Medical
- Legal
- and Regulatory
- Out-of-Home
- Platforms
- Programmatic
- SEO
- Social Media
- and Tech Advisory
- Profile identifies a recruitment agency
- No
- Reported total investment
- 0
Currency and observation date were not supplied; this is not a current valuation or a funding round.
Klick Health is the world’s largest independent commercialization partner for life sciences. For over 25 years, Klick has been laser-focused on developing, launching, and supporting life sciences brands to maximize their full market potential as a core commercialization partner. Klick is opening offices in regional hubs and key markets to provide local support for our clients in countries outside of North America…
| Field | Value |
|---|---|
| Industry | Advertising Services |
| Company size | 1,001-5,000 employees |
| Headquarters | Toronto, Ontario |
| Organization type | Privately Held |
| Year founded | 1997 |
| Specialties | Brand StrategyClinical Review and AnalysisCopywritingCreative TechnologyCRM StrategyDigital MediaDisease AwarenessExperience DesignFilm and VideoLaunch Tactical Readiness |
| Open jobs on Jobsy | 37 |
| View page |
Company Description
The Klick Group—comprising Klick Health (including Klick Katalyst and btwelve), Klick Media Group, Klick Applied Sciences (including Klick Labs), Klick Consulting, and Klick Ventures—is an ecosystem dedicated to realizing the full potential of our people and clients in life sciences. Founded in 1997, we have offices in New York, Philadelphia, Saratoga Springs, Toronto, London, São Paulo, and Singapore. Consistently named a Best Managed Company, Most Admired Corporate Culture, and Great Place to Work, Klick is committed to fostering a high-performance, people-first culture with creativity, collaboration, innovation, and impact across everything we do.
About Our Omnichannel Enablement Craft
Our Omnichannel Enablement Craft connects channels, data, and technology into unified experiences. The team ensures audiences encounter consistent, coordinated messaging across touchpoints. By aligning media and platforms, they support seamless journeys. Their work enhances effectiveness and measurement across the ecosystem.
Job Description
The Senior Data Solutions Consultant partners with cross-functional teams to design, build, and optimize scalable data solutions that support omnichannel marketing, analytics, and AI-enabled products for life sciences clients. This role collaborates closely with analytics, engineering, project management, and client stakeholders to transform complex datasets into reliable, production-ready data assets that drive measurable business outcomes. Success in this role requires expertise in Python, SQL, ETL development, enterprise data platforms, and modern business intelligence technologies.
What You'll Do
- Build analytics products including business intelligence dashboards, system integrations, data outputs, presentations, and AI-enabled solutions using platforms such as Power BI, Microsoft Fabric, and Tableau.
- Develop, maintain, and optimize enterprise data warehouse solutions, preferably in Snowflake, while ensuring data quality, reliability, scalability, and performance.
- Design, develop, and optimize scalable ETL pipelines using Python and SQL to support analytics, reporting, AI solutions, and client deliverables.
- Collaborate with data analysts, project managers, business analysts, and client stakeholders to gather technical requirements, define solution architecture, and deliver measurable business outcomes.
- Standardize and improve engineering practices through reusable code, Git version control, documentation, SOP development, and scalable data engineering processes that support operational excellence.
Qualifications
Required:
- Experience using Python and SQL to build, optimize, and maintain production-ready data pipelines and data models.
- 4–5 years of hands-on experience developing scalable data solutions, designing and supporting ETL pipelines for analytics and reporting.
- Experience working with clickstream datasets, enterprise data lakes, and modern cloud data warehouse platforms, preferably Snowflake, supporting analytics or marketing use cases.
- Experience gathering technical requirements from business stakeholders and clients, translating business needs into production-ready data solutions and measurable deliverables.
- Experience developing business intelligence solutions using Power BI, Microsoft Fabric, Tableau, or comparable visualization platforms, with examples of dashboards or reporting solutions delivered.
Desired:
- Comfort and enthusiasm for using AI as a regular part of how work gets done.
- Experience supporting healthcare, pharmaceutical, or life sciences data, analytics, or omnichannel marketing initiatives.
- Experience designing relational database structures, dimensional models, and enterprise data architecture supporting scalable analytics platforms.
- Bachelor's degree in Computer Science, Software Engineering, Data Engineering, or a related technical discipline.
- Experience implementing Git-based development workflows, documentation standards, and reusable engineering practices across collaborative technical teams.
Additional Information
This posting is for an existing vacancy at Klick. The base salary range for this position is between CAD $90,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
Klick is consciously creating a culture where everyone can thrive and grow in their careers. We believe that our best work comes from our diverse backgrounds, perspectives, and skills. We strongly encourage members of historically underrepresented communities to apply, including Black people, Indigenous peoples, and other people of color, people with disabilities, people from gender and sexually diverse communities and people with intersectional identities. We're also committed to developing an inclusive, barrier-free recruitment process and work environment. Should you require any accommodation, please contact us at [email protected] and we will work with you to meet your accessibility needs and ensure you have a positive experience.
Journal
Only you can see this. Kept on this device, and in your account when you sign in.