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 and Python skills, preferably in a Databricks environment.
- 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 QA outputs.
- Basic BI skills with Tableau or Power BI, including data modeling, dashboard structure, calculated fields, usability, and data storytelling.
- Strong written and verbal communication with technical and non-technical stakeholders.
- Ability to translate complex business reporting requests into modeled data for current and future analysis.
- Preferred: Pharma, HCP, or healthcare media analytics experience, including media PLD (Physician Level Data).
- Preferred: Digital media measurement expertise, including media KPIs, attribution concepts, and 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.
- Monitor data freshness, completeness, and accuracy; perform quality assurance and reconciliation checks.
- Investigate missing, unexpected, or inconsistent data and coordinate remediation with the appropriate teams.
- 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, and document business rules, transformation logic, and metric definitions.
- Work with analysts and measurement leads to translate reporting requirements into technical requirements and modeled data.
- Support Power BI developers and business analysts with data questions, report validation, and troubleshooting.
- Verify that dashboard data aligns with source systems and business requirements, and support semantic models and reporting datasets.
View Full Description & ApplyYou'll be redirected to the employer's site
