Data Solutions Consultant

About Klick HealthMeet 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. We’re one of the country’s Top 10 Great Workplaces, 10 Most Inspiring Cultures, Best Workplace for Innovators, Best Managed, and Fastest Growing. We know that career paths are seldom simple and straightforward. And that's an asset. If you feel like you'd be a good fit for this role, we encourage you to apply and take the first steps to starting 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, we invite you to embark on your career journey with us at Klick.
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)
• 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 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-Hybrid #LI-SA1
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 careers@klick.com and we will work with you to meet your accessibility needs and ensure you have a positive experience.