Business Intelligence Solution Developer

Real Chemistry

6d • $90,000 - $110,000 • Remote

About The Position

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

The successful candidate will investigate data questions, identify causes of discrepancies, improve data quality, and work across teams to ensure reliable data supports business decisions. The position may be remote within the United States or based in a U.S. office location. Employees within a one-hour commute of a Real Chemistry office are expected to attend in person two days per week, at a company office or client site. Specific arrangements may vary by role and location and will be discussed during hiring.

Requirements

• Strong SQL and Python skills; Databricks experience is preferred.
• Experience with ETL tools and data manipulation concepts, such as Funnel.io, DBT, or similar applications.
• Comfort partnering with Data Engineering on data sources, schemas, and refresh logic.
• Strong analytical and problem-solving skills related to data storage and structure for reporting.
• Experience reviewing data logic, KPI definitions, and QA outputs.
• Basic BI skills in Tableau or Power BI, including data modeling, dashboard structure, calculated fields, usability, and data storytelling.
• Strong written and verbal communication skills with technical and non-technical stakeholders.
• Ability to translate complex business reporting requests into modeled data that supports current and future analysis.

Nice To Haves

• Pharmaceutical, HCP, or healthcare media analytics experience, including experience with media PLD (Physician Level Data).
• Digital media measurement expertise, including media KPIs, attribution concepts, and omnichannel analysis.
• Experience inheriting or stabilizing existing data warehouse schemas.

Responsibilities

• Coordinate onboarding of new client data sources and data feeds.
• Partner with Data Engineering to ensure successful data ingestion into Databricks.
• Monitor data delivery schedules and ingestion processes.
• Maintain source documentation, field mappings, and data inventories.
• Work with internal teams and external partners to resolve source-related issues.
• 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 appropriate teams.
• Document data quality findings and resolutions.
• Support development of automated data quality checks and monitoring processes.
• Develop and maintain client-specific standard, custom, and master tables and reporting views in Databricks using a medallion architecture.
• Transform and standardize data from multiple sources into reporting-ready structures.
• Help develop data model solutions for evolving reporting and analysis needs.
• Document business rules, transformation logic, and metric definitions.
• Support maintenance of reusable reporting datasets and standardized data models.
• Serve 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 them into technical requirements, and provide database-modeled data for reporting.
• Communicate data issues, impacts, and resolutions to stakeholders.
• Troubleshoot data discrepancies affecting reporting deliverables.
• Support Power BI developers and business analysts with data-related questions.
• Assist with report validation and troubleshooting.
• Verify that dashboard data aligns with source systems and business requirements.
• Provide support for semantic models and reporting datasets as needed.

Benefits

• 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 through LinkedIn Learning.
• Office locations in key markets with free snacks.

What This Job Offers

• Job Type: Full-time
• Education Level: No Education Listed