Overview
Join athenahealth’s Marketing BI team as a Business Intelligence Associate, building and maintaining trusted marketing performance insights.
What you’ll do
- Build, publish, and maintain business-critical Power BI dashboards.
- Design star-schema data models and create advanced DAX calculations.
- Write, debug, and optimize complex SQL queries to extract and model marketing data.
- Clean, transform, and audit large datasets from Salesforce CRM and marketing platforms.
- Standardize marketing KPI definitions and reporting logic across dashboards.
- Rationalize legacy Power BI reports by simplifying and documenting them to improve performance.
- Translate marketing questions into exact technical reporting requirements and present insights.
What you’ll need
- Bachelor’s degree in computer science, engineering, business analytics, information systems, or a related quantitative field.
- 5 years of overall experience.
- 3+ years in data analytics, data visualization, and hands-on data manipulation using SQL and Excel.
- Advanced SQL expertise for gathering and processing large-scale datasets from Snowflake or similar cloud databases.
- Hands-on experience with data manipulation using lookup functions and data validation tools.
- Proven experience designing and building Power BI reports using DAX, data modeling, and performance optimization.
- Working experience transforming Salesforce CRM data objects such as Leads, Contacts, Accounts, and Opportunities.
Nice to have
- Basic proficiency in Python for data analysis and task automation.
- Core understanding of data engineering practices.
- Prior experience in US Healthcare or B2B commercial marketing/sales organizations.
- Familiarity with marketing funnel metrics and marketing automation tools.
Details
- Role is focused on marketing performance insights within the Marketing BI team.
Read the full description and apply on the company’s own careers page.
