Remote BI Solutions Engineer Databricks & Data Quality

Real Chemistry; United States; Remote; USD 90,000 - 110,000; Full time

Benefits offered by this job

Free snacks

Holiday & PTO

Private medical/dental/vision

LinkedIn Learning access

Mental wellness coaching

Job summary

Real Chemistry is hiring a Business Intelligence Solution Developer to join the Measurement Enablement team. This role focuses on ensuring healthcare marketing data is accurate, ready for reporting, and supports data ingestion, quality, and modeling across Databricks and BI tools.

The position is remote within the United States or based in US offices, with collaboration across Data Engineering, Analytics, and client stakeholders to drive reliable data-powered decisions.

Qualifications

• Strong SQL and Python skills in a Databricks environment.
• Experience using ETL tools and data manipulation concepts (Funnel.io, DBT, or similar).
• Comfort partnering with Data Engineering on data sources, schemas, and refresh logic.
• Analytical and problem-solving skills for data storage and reporting structures.
• Experience reviewing data logic, KPI definitions, and QA outputs.
• BI skills including Tableau/Power BI with data modeling and dashboards.
• Strong written and verbal communication with technical and non-technical stakeholders.
• Ability to translate complex business reporting requests into modeled data.

Responsibilities

• Data ingestion and source management across client data feeds.
• Ensure ingestion into Databricks with Data Engineering collaboration.
• Monitor data delivery schedules and ingestion processes.
• Maintain source documentation, field mappings, and data inventories.
• Resolve source-related issues with internal teams and partners.
• Monitor data freshness, completeness, and accuracy across datasets.
• Perform QA checks and reconcile data discrepancies.
• Escalate and coordinate remediation with appropriate teams.
• Document data quality findings and resolutions.
• Develop automated data quality checks and monitoring processes.
• Develop and maintain standard and custom data models and reporting views in Databricks.
• Transform and standardize data from multiple sources for reporting-ready structures.
• Document business rules, transformation logic, and metric definitions.
• Support reusable reporting datasets and standardized data models.
• Act as primary contact for routine data questions.
• Collaborate with Client Services, Media, Strategy, and Data teams to align on outputs.
• Translate reporting requirements into technical specifications for data.
• Communicate data issues, impacts, and resolutions to stakeholders.
• Assist with troubleshooting data discrepancies impacting reports.
• Support Power BI developers with data-related questions.
• Validate data in dashboards against source systems and business requirements.
• Provide support for semantic models and reporting datasets when needed.

Skills

SQL

Python

ETL tools

Data modeling

KPI definitions

QA outputs

BI tools

Communication

Data storytelling

Translating requirements

Tools

Databricks

DBT

Funnel.io

Job description

Real Chemistry is hiring a Business Intelligence Solution Developer to join the Measurement Enablement team. This role focuses on ensuring healthcare marketing data is accurate, ready for reporting, and supports data ingestion, quality, and modeling across Databricks and BI tools.

The position is remote within the United States or based in US offices, with collaboration across Data Engineering, Analytics, and client stakeholders to drive reliable data-powered decisions.