Measurement Data & Analytics

The role

The Senior Manager, Integrated Intelligence Measurement ensures client healthcare marketing data is accurate and ready for reporting. This role manages data ingestion, validates data quality, and maintains reporting-ready data structures within Databricks.

What you will do

• Coordinate onboarding of new client data sources and feeds
• Partner with Data Engineering to ensure data ingestion into Databricks
• Monitor data delivery schedules and ingestion processes
• Maintain source documentation, field mappings, and data inventories
• Monitor data freshness, completeness, and accuracy
• Perform quality assurance and reconciliation checks
• Investigate missing, unexpected, or inconsistent data
• Develop and maintain client-specific tables and reporting views in Databricks
• Translate reporting requirements into technical requirements
• Support Power BI developers and business analysts with data-related questions

Required qualifications

• Strong SQL and Python skills
• Experience using ETL tools and data manipulation concepts
• Comfort partnering with Data Engineering on data sources, schemas, and refresh logic
• Deep analytical and problem-solving skills related to data storage and structure for reporting
• Experience reviewing data logic, KPI definitions, and QA outputs
• Basic BI (Tableau, Power BI) skills including data modeling, dashboard structure, calculated fields, usability, and data storytelling
• Strong written and verbal communication with technical and non-technical stakeholders
• Ability to translate complex business reporting requests into modeled data

Nice to have

• Strong SQL and Python skills in a Databricks environment
• Experience with Funnel.io, DBT, or similar applications
• Pharma, HCP, or healthcare media analytics experience, including experience with media PLD (Physician Level Data)
• Digital media measurement expertise (media KPIs, attribution concepts, omnichannel analysis)
• Experience inheriting or stabilizing existing data warehouse schemas

Benefits

• Free snacks
• Generous holiday and paid time off
• Options for private medical, dental, and vision plans
• Support in saving for the future
• Mental wellness coaching and support
• Access to more than 13,000 online classes with LinkedIn Learning

About the company

Real Chemistry is a global agency providing a full suite of services across healthcare communications and marketing to pharmaceutical and biotech clients.