Business Intelligence Solution Developer

The job

LIVE Employer public job feed (private-sector employer) Source: the employer's public careers feed · Data: listed 2026-11-02

Job description

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

This is the pay range the Company believes it will pay for this position at the time of this posting.  Consistent with applicable law, compensation will be determined based on job-related, non-discriminatory factors including but not limited to work experience, skills, certifications, and geographical location. The Company reserves the right to modify this pay range at any time. 

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

We believe we can do our best when feeling our best, which is why we’ve put together a benefits program designed to give you the support you and your family need at every stage of life. Real Chemistry offers a comprehensive benefit program and perks, tailored to your region. Globally, this includes offices in our key markets with free snacks to keep you running all day long, generous holiday and paid time off, options for private medical, dental, and vison plans, and support in saving for the future. Other perks include mental wellness coaching and support and access to more than 13,000 online classes with LinkedIn Learning.  Learn more about our great benefits and perks and search specific offerings in your region at: www.realchemistrybenefits.com.

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. Because our workforce spans multiple countries, regions, and client needs, work arrangements may vary by role and location. Some positions offer hybrid or remote flexibility, while others require regular in-office presence. For example, certain teams and regions, including some of our UK operations, have office-based requirements. Your 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.

Explore around this job

Field: Technology Sub-niche: Data, analytics and AI All jobs at Real Chemistry

View this job and apply on the employer's page →

You apply on the employer's page; AtiveSite does not receive or process applications and is not affiliated with the employer. The description above is shown as the source published it.

About the role

This is a — role in the Technology field (Data, analytics and AI) at Real Chemistry.

We could not match this job title to one occupation in the official wage statistics, so no pay estimate is shown. Pay is not in the source listing; ask the employer for the range and compare in the 240 job niches.

How to prepare and behave

This is editorial guidance, not information from the employer.

• Read the whole description and match your examples to its requirements; use the same words the posting uses where they are true for you.
• Research the employer before the interview: what it does, who its customers are and recent news; prepare two or three questions about the work.
• Arrive early (or log in early for a video call), dress one step above the daily dress code, and test your camera and audio beforehand.
• Answer with short stories: the situation, what you did and the result. Give numbers when you have them and never invent them.
• Be honest about gaps; say what you did to learn and how fast you can close them.
• Ask about the team, the first 90 days, how success is measured and the schedule; do not open with salary and time off.
• When pay comes up, know the market range for the occupation and your lowest acceptable offer before you answer; ask for the full package in writing.
• Send a short thank-you message within a day, mentioning one thing you discussed.
• The listing mentions a remote or flexible location. Confirm with the employer whether remote work applies to your state: taxes, licensing and benefits can depend on where you live.
• Have code, data work or projects you can show, and be ready to think aloud: many technical interviews test how you reason, not only the answer.

Know your rights as a candidate and an employee:

• U.S. Equal Employment Opportunity Commission: prohibited employment practices
• U.S. Department of Labor: Wage and Hour Division
• CareerOneStop (U.S. Department of Labor): job search help, interview tips and resumes
• USA.gov: avoiding job scams

The city

The listing is remote or has no US state we could identify. Read the country guide for pay, taxes, law and cost of living by state.

Where to live

The job city has no coordinates we can place on the map, so no housing comparison is shown. Use the 250 largest cities table to compare rent and income.

Career paths

We could not match this title to one occupation, so here are the other sub-niches in Technology, where your skills may carry over:

Cybersecurity (512) Software engineering (2678) Cloud, IT and infrastructure (743) Product management (570)

Distances

This job has no single city we can place on the map (remote, flexible or unmatched location), so no distance table is shown. Browse all Technology jobs with distances from any of the 20 largest cities.

The employer

Real Chemistry is the employer in this listing. See all its open jobs here →

We do not hold headcount or revenue for this employer. Check its careers site and, if it is listed on a stock exchange, its public filings (SEC EDGAR search).

What it is like to work at a company (culture, schedules, benefits) is not in the source data, so we do not describe it. Read the description and ask the questions under "How to prepare".

Other open jobs at Real Chemistry

Similar jobs

Same sub-niche: Data, analytics and AI

All Data, analytics and AI jobs → · All Technology sub-niches →

FAQ

What is the Business Intelligence Solution Developer job at Real Chemistry?

A private-sector role in technology (data, analytics and ai) listed 7 days ago. The full description is on this page and on the employer's page.

Where is this job?

Remote / flexible (United States). A remote or flexible location is listed; confirm with the employer which states are accepted.

How do I apply?

Use the "View this job and apply on the employer's page" button. AtiveSite does not receive applications.

How much does it pay?

The listing does not publish pay, and we could not match the title to one official occupation.

What is the cost of living there?

See the state or country guide for rent, income and taxes.

How old is this listing?

It was posted on 2026-11-02 (7 days ago). Jobs older than 90 days are not shown.

Are there similar jobs?

Yes: browse data, analytics and ai jobs in the United States.

Sources and terms

• Job data: Real Chemistry careers page public feed (listing dated 2026-11-02). The job disappears from this site when it disappears from the source.
• Wages and projections: BLS OEWS (May 2025) and Employment Projections 2025–35.
• City and county figures: Census Bureau ACS 2020–2024, BEA, BLS QCEW and LAUS, NASA POWER climatology; distances from Census Gazetteer coordinates.

AtiveSite is not affiliated with or endorsed by the employer or any government agency, and does not process applications. Verify every detail with the employer before acting.

Sources

• BLS OEWS (wages and employment by occupation, May 2025)
• BLS Employment Projections 2025–35
• BLS Local Area Unemployment Statistics
• BLS JOLTS
• BLS State and Metro Area Employment
• Census Bureau American Community Survey (via Census Reporter)
• BEA GDP by state and Regional Price Parities
• IRS 2026 tax adjustments
• U.S. Department of Labor, minimum wage by state
• Tax Foundation state income tax rates 2026
• USAJOBS
• USCIS
• U.S. Department of State, visas
• NASA POWER climatology
• GeoNames / Census Gazetteer (coordinates)