Business Intelligence Associate

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.