Senior Data Solutions Consultant

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. 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 Design, develop, and optimize scalable ETL pipelines using Python and SQL to support analytics, reporting, AI solutions, and client deliverables. Develop, maintain, and optimize enterprise data warehouse solutions, preferably in Snowflake, while ensuring data quality, reliability, scalability, and performance. Collaborate with data analysts, project managers, busi