Data Engineering Consultant

Toronto, Ontario

Klick

Over 1000 people passionate about life sciences, dedicated to doing things differently by putting people first, honoring our hacker roots, living our entrepreneurial spirit, choosing outcomes over optics and playing the long game.

View all jobs at Klick

Apply now Apply later

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. And we’re still growing fast, even after two decades. What does that mean for you? As Klick experiences exponential growth year-over-year, so do the people who help make it happen. Because we’re constantly evolving and changing, we invest in talent early and often, to develop future leaders at all levels.
As an integral part of our forward-thinking team, you'll collaborate closely with top-tier professionals to design, develop, and maintain cutting-edge data solutions. Embrace the challenge of handling growing datasets and navigating the ever-evolving media landscape, all while pushing the boundaries of digital transformation.
This role isn't just about crunching numbers – it's about driving real impact by merging data solutions into client engagements and marketing sciences products. You'll work hand-in-hand with stakeholders to craft tailored solutions that meet our clients' unique needs, all while showcasing your expertise in both individual and team settings. Your code will serve as the bedrock of our service offering, ensuring optimal performance and maintenance of our systems.
But it's not just about technical prowess – we're seeking individuals with insatiable curiosity, a drive to challenge the status quo, and a passion for uncovering insights that drive real change. If you're ready to dive deep, tackle complex challenges, and share your discoveries with peers and clients alike, then come join us on the forefront of analytics innovation. At Klick, your love for data will be celebrated and your potential truly unleashed.

Responsibilities

  • Work in a collaborative manner and Interact with other 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).
  • Deep understanding of Google Ads - Campaign Manager, TikTok, Facebook, LinkedIn, expected Nuance to each of those different
  • Maintain enterprise data warehouse (Snowflake preferred but not required).
  • Build analytic products in the form of presentations, data outputs, system integrations, business intelligence 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 Management, SOP creation, Requirement Maintenance).

Qualifications

  • 4-5 years’ of hands-on practical experience with a minimum of 2 years’ of experience in ETL processing to be used for data analysis and modeling.
  • Minimum 2 years of working knowledge in Python and SQL is a must.
  • Experience in Microsoft Fabric is a HUGE plus, alongside Stitch.
  • Experience working with clickstream data sets and data lakes is a must.
  • 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.
#LI-TH1 #LI-Hybrid
Apply now Apply later

* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰

Job stats:  0  0  0

Tags: Architecture Business Intelligence Computer Science Data analysis Data warehouse Engineering ETL Git Pipelines Power BI Python Snowflake SQL Tableau

Region: North America
Country: Canada

More jobs like this