Data Solutions Consultant
Summary
Design and maintain data pipelines and warehouses (Snowflake, Python, SQL) to power marketing analytics for life-sciences clients, and deliver BI/AI outputs in Power BI, Tableau, or Fabric.
About Klick Health
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. As Klick experiences exponential growth year-over-year, so do the people who help make it happen. We invest in talent early and often to develop future leaders at all levels. We’re recognized as a Top 10 Great Workplace, 10 Most Inspiring Cultures, Best Workplace for Innovators, Best Managed, and Fastest Growing. If you feel like you’d be a good fit for this role, apply to start your career journey at Klick.
As part of our Analytics team, you’ll be at the forefront of the big data revolution, guiding marketing strategies for our diverse range of clients. If you’re ready to unleash your creativity and expertise in a fast-paced environment, join Klick.
Responsibilities
- Work in a collaborative manner with 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)
- Maintain enterprise data warehouse (Snowflake preferred but not required)
- Build analytic products in the form of presentations, data outputs, system integrations, BI 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, SOPs, Requirements maintenance)
Qualifications
- 4-5 years of hands-on practical experience with a minimum of 2 years in ETL processing for data analysis and modeling
- Minimum 2 years of working knowledge in Python and SQL
- Experience working with clickstream data sets and data lakes
- 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
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 colour, 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.
Details
- Seniority level: Mid-Senior level
- Employment type: Full-time
- Job function: Consulting, Information Technology, and Sales
- Industries: Advertising Services