[Hiring] Business Intelligence Solution Developer @Real Chemistry

Role Description

The Business Intelligence (BI) Solution Developer serves as a key member of the Measurement Enablement team, responsible for ensuring client healthcare marketing data is accurate, current, and ready for reporting and analysis. This role bridges the gap between Data Engineering, analytics teams, and client stakeholders by managing data ingestion processes, validating data quality, maintaining reporting-ready data structures, and resolving issues throughout the data lifecycle.

The ideal candidate enjoys investigating data questions, identifying root causes of data discrepancies, improving data quality, and working across multiple teams to ensure reliable data powers business decisions.

This role can be remote within the United States or based in any of our U.S. office locations, including New York City, Boston, Chicago, Lambertville, NJ, San Francisco, or Carmel, IN.

Primary Responsibilities

• Data Ingestion & Source Management
  • Coordinate the onboarding of new client data sources and data feeds.
  • Partner with Data Engineering to ensure successful ingestion of data into Databricks.
  • Monitor data delivery schedules and ingestion processes.
  • Maintain source documentation, field mappings, and data inventories.
  • Work directly with internal teams and external partners to resolve source-related issues.
• Data Quality & Stewardship
  • Monitor data freshness, completeness, and accuracy across client datasets.
  • Perform ongoing quality assurance and reconciliation checks.
  • Investigate missing, unexpected, or inconsistent data.
  • Escalate, coordinate and resolve remediation efforts with the appropriate teams.
  • Maintain documentation of data quality findings and resolutions.
  • Support the development of automated data quality checks and monitoring processes.
• Data Modeling
  • Develop and maintain client-specific standard, custom, and master tables and reporting views within Databricks based on a medallion architecture.
  • Assist with transforming and standardizing data from multiple sources into reporting-ready structures.
  • Solve problems and help build solutions related to the data model to meet evolving reporting and analysis needs.
  • Document business rules, transformation logic, and metric definitions.
  • Support maintenance of reusable reporting datasets and standardized data models.
• Stakeholder Support
  • Act as the primary point of contact for routine data-related questions.
  • Partner with Client Services, Media, Strategy, and Data teams to align on data outputs and expectations.
  • Work with analysts and measurement leads to understand reporting requirements, translate into technical requirements, and provide database-modeled data for reporting.
  • Communicate data issues, impacts, and resolutions to stakeholders.
  • Assist with troubleshooting data discrepancies impacting reporting deliverables.
• Reporting Support
  • Support Power BI developers and business analysts with data-related questions.
  • Assist with report validation and troubleshooting.
  • Help verify data displayed in dashboards aligns with source systems and business requirements.
  • Provide support for semantic models and reporting datasets when needed.

Qualifications

• Strong SQL and Python skills, in a Databricks environment preferable.
• Experience using ETL tools and data manipulation concepts (Funnel.io, DBT, or similar applications).
• 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, data storytelling.
• Strong written and verbal communication with technical and non-technical stakeholders.
• Ability to translate complex business reporting requests into modeled data to support current and future analysis.

Preferred / Bonus

• 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.

Pay Range

$90,000-$110,000

Benefits

Real Chemistry offers a comprehensive benefit program and perks, tailored to your region. Globally, this includes:

• Free snacks to keep you running all day long.
• 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.

Company Description

Real Chemistry is proud to be Great Place to Work® certified; check out what our people shared about our culture and workplace on our Great Places to Work Profile.

At Real Chemistry, we believe we're at our best when we're connected. Our Real Hybrid and Regional Teams (Real HART) approach is designed to foster collaboration, learning, innovation, and meaningful relationships while providing flexibility where appropriate.

Real Chemistry is an Equal Opportunity employer. We continually strive to build and sustain an inclusive and equitable work environment where our employees feel empowered to leverage all they bring from their personal lived experience and professional expertise.