Business Intelligence Solution Developer

The posting, as Real Chemistry wrote it

At Real Chemistry, making the world a healthier place isn’t just an aspiration—it’s our everyday reality. Our drive to transform healthcare is informed by our blend of deep scientific expertise, human-centred creativity, and AI-driven insights, fostering a unique environment where innovation thrives and our people are impact-obsessed. As a global agency, we provide a full suite of services across healthcare communications and marketing to our clients, including top players in the pharmaceutical and biotech industries.

Our #LifeatRealChem culture is rooted in our people—we believe we are best together and are committed to excellence for both our clients and colleagues. Whether you're a seasoned professional or just starting your career, if you share our passion for healthcare and connection, we invite you to explore our opportunities.

Discover your purpose. Embrace innovation. Experience #LifeatRealChem.

Role Overview

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 is a hybrid role, based in any of our US offices—New York City, Boston, Chicago, San Francisco, Indianapolis, or Lambertville (NJ)—or remotely within the US, depending on team and business needs.

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 reportin

[…]
recruiter will discuss the specific expectations for the role you're pursuing during the interview process and keep you informed throughout the hiring journey. For employees located within a one-hour commute of a Real Chemistry office, we require in-person attendance two days per week, either from a Real Chemistry office or when working onsite with clients. Employees in regions without a nearby office may work remotely and come together throughout the year for collaboration, culture-building, learning, and team connection opportunities. While these guidelines reflect our current workplace model, we understand that everyone’s circumstances are unique. If you require additional flexibility, we welcome an open conversation with your recruiter and our HR team to discuss your needs and determine what may be possible.

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, to make our team the best in the industry. We encourage motivated and qualified applicants to apply without regard to race, color, religion, sex (including pregnancy), sexual orientation, gender identity/expression, ethnic or national origin, age, physical or mental disability, genetic information, marital information, or any other characteristic protected by federal, state, or local employment discrimination laws where Real Chemistry operates. Should you require accommodations throughout the interview process please let your recruiter know.

*Notice: Real Chemistry and its affiliates' names are being misused by scammers through messaging services, fake websites, and apps. Do not share personal or financial information or make payments to any unverified sources claiming to be connected to Real Chemistry. We are working to stop these unauthorized activities and protect our community. Read more here .