Business Intelligence Associate
Core
Build, scale, and maintain trusted marketing performance insights by transforming complex commercial and campaign data into actionable dashboards for the Marketing department.
Role type
Business Intelligence Associate (Marketing Analytics)
Builds
Production Power BI dashboards and standardized marketing KPI reporting frameworks
Domain
Healthcare technology / B2B Marketing Analytics
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Advanced SQL, Power BI development, DAX, Data modeling, Data cleaning, Excel (Power Query), Stakeholder communication
Preferred skills
Python, Salesforce CRM data manipulation, Healthcare industry experience, Marketing funnel metrics knowledge
Technologies
Power BI, Snowflake, Salesforce, Excel
Responsibilities
Build and maintain business-critical Power BI dashboards with efficient data models and DAX calculations; Write and optimize complex SQL queries to extract and aggregate data from Snowflake; Clean and validate large-scale datasets from Salesforce and marketing platforms; Implement standardized marketing KPI definitions across reports; Reverse-engineer and simplify legacy spreadsheets and reports; Translate business questions into technical reporting requirements and present insights to stakeholders
Seniority
Mid-level, hands-on IC