Business Intelligence Solution Developer
New
R
Real ChemistryHealthcare marketing analytics
This role can be remote within the United States or based in any of our U.S. office locationsFull-Time
Salary90,000 - 110,000 USD per year
Apply NowOpens the employer's application page
Job Details
- Required Skills
- PythonSQLETLMicrosoft Power BITableauData modelingdbtDatabricks
Requirements
- Strong SQL skills.
- Strong Python skills.
- Databricks experience preferred.
- Experience using 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 quality assurance outputs.
- Basic Tableau or Power BI skills, including data modeling, dashboard structure, calculated fields, usability, and data storytelling.
- Ability to translate complex business reporting requests into modeled data for current and future analysis.
- Strong written and verbal communication with technical and non-technical stakeholders.
- Preferred: pharma, HCP, or healthcare media analytics experience, including media PLD (Physician Level Data).
- Preferred: digital media measurement expertise, including media KPIs, attribution concepts, or omnichannel analysis.
- Preferred: experience inheriting or stabilizing existing data warehouse schemas.
Responsibilities
- Coordinate onboarding of client data sources and feeds, and partner with Data Engineering on ingestion into Databricks.
- Monitor data delivery schedules and ingestion processes, and maintain source documentation, field mappings, and data inventories.
- Check data freshness, completeness, and accuracy; perform quality assurance and reconciliation; and investigate discrepancies.
- Coordinate remediation, document data quality findings and resolutions, and support automated quality checks and monitoring.
- Develop and maintain client-specific standard, custom, and master tables and reporting views in Databricks using a medallion architecture.
- Transform and standardize data into reporting-ready structures, and document business rules, transformation logic, and metric definitions.
- Partner with Client Services, Media, Strategy, Data teams, analysts, and measurement leads to translate reporting requirements into technical requirements and modeled data.
- Communicate data issues and resolutions, troubleshoot reporting discrepancies, and support Power BI developers and business analysts.
- Assist with report validation and verify dashboard data against source systems and business requirements.
View Full Description & ApplyYou'll be redirected to the employer's site
