Join us as we work to create a thriving ecosystem that delivers accessible, high-quality, and sustainable healthcare for all.
Position Summary:
Join athenahealth’s Marketing BI team as a Business Intelligence Associate - a highly technical and impactful role focused on building, scaling, and maintaining trusted marketing performance insights.
In this role, you will be responsible for hands-on data manipulation, advanced SQL querying, and high-performance Power BI dashboard development, turning complex commercial and campaign data into actionable insights for our Marketing department. The ideal candidate is a highly analytical professional who possesses strong data management and visualization capabilities to clean, transform, and analyse large-scale marketing campaign and performance data.
About the Team:
The Marketing Operations team enables data-driven decision making across athenahealth’s Marketing organization by developing scalable analytics, reporting, and performance frameworks. The team partners closely with Marketing, Sales, Finance, IT, and Data Engineering to align on go-to-market performance, pipeline measurement, and reporting standards. They manage a broad analytics ecosystem spanning CRM, marketing automation, and enterprise data platforms such as Snowflake and Power BI. The team’s mission is to improve the quality, consistency, and accessibility of insights that drive business growth.
Essential Job Responsibilities:
- Power BI Development & Visualization: Build, publish, and maintain business-critical Power BI dashboards. Design efficient star-schema data models, establish seamless relationship mappings, and write advanced DAX calculations (using filter context manipulation, time intelligence, and dynamic security rules).
- SQL Data Preparation & Processing: Write, debug, and optimize complex, performant SQL queries (using CTEs, analytical window functions, and multi-table joins) to extract, aggregate, and model raw marketing data from platforms like Snowflake.
- Advanced Data Handling & Auditing: Manipulate and clean massive, complex datasets from Salesforce CRM and marketing platforms. Act as a gatekeeper of data quality by utilizing advanced Excel techniques (Power Query, nested lookups, dynamic arrays) to validate, reconcile, and audit spreadsheet metrics against final dashboards.
- KPI Standardization: Implement and maintain standardized marketing KPI definitions and reporting logic across dashboards to ensure consistent "single source of truth" metrics.
- Legacy Dashboard Rationalization: Reverse-engineer, simplify, and document legacy spreadsheets and Power BI reports to eliminate redundant reporting and improve performance.
- Stakeholder Collaboration: Translate marketing business questions into exact technical reporting requirements, presenting data insights clearly to both technical and non-technical stakeholders.
Additional Job Responsibilities
- Support ad hoc marketing analysis and custom reporting requests across campaigns, segments, and channels.
- Collaborate with broader data and IT teams to validate data flows and ensure business reporting accuracy.
- Promote best practices in query performance, data modelling, and clean visual design within the immediate team.
- Perform thorough QA and data validation testing on all developed dashboards prior to executive rollouts.
Required Education & Experience:
- Bachelor’s degree in computer science, Engineering, Business Analytics, Information Systems, or a related quantitative field.
- 5 years of overall experience and 3+ years of Data analytics, Data Visualization and hands-on Data Manipulation using SQL and Excel.
- Advanced SQL expertise, including writing and optimizing queries to gather and process large-scale datasets from Snowflake or similar cloud databases.
- Hands-on experience with data manipulation, lookup functions (VLOOKUP/XLOOKUP), and data validation tools to handle large volumes of reporting data.
- Proven experience designing and building user-friendly Power BI reports, including DAX query creation, data modeling, and performance optimization.
Preferred:
- Basic proficiency in Python for data analysis and task automation, combined with a core understanding of data engineering practices to align with technical partners.
- Working experience interacting, engaging, and transforming Salesforce CRM data objects such as Leads, Contacts, Accounts, Opportunities.
- Prior experience in US Healthcare or B2B commercial marketing/sales organizations.
- Familiarity with marketing funnel metrics across prospect lifecycle journey
- Familiarity with marketing automation tools and standard campaign performance metrics.
About athenahealth
Our vision: In an industry that becomes more complex by the day, we stand for simplicity. We offer IT solutions and expert services that eliminate the daily hurdles preventing healthcare providers from focusing entirely on their patients — powered by our vision to create a thriving ecosystem that delivers accessible, high-quality, and sustainable healthcare for all.
Our company culture: Our talented employees — or athenistas, as we call ourselves — spark the innovation and passion needed to accomplish our vision. We are a diverse group of dreamers and do-ers with unique knowledge, expertise, backgrounds, and perspectives. We unite as mission-driven problem-solvers with a deep desire to achieve our vision and make our time here count. Our award-winning culture is built around shared values of inclusiveness, accountability, and support.
Our DEI commitment: Our vision of accessible, high-quality, and sustainable healthcare for all requires addressing the inequities that stand in the way. That's one reason we prioritize diversity, equity, and inclusion in every aspect of our business, from attracting and sustaining a diverse workforce to maintaining an inclusive environment for athenistas, our partners, customers and the communities where we work and serve.
What we can do for you:
Along with health and financial benefits, athenistas enjoy perks specific to each location, including commuter support, employee assistance programs, tuition assistance, employee resource groups, and collaborative workspaces — some offices even welcome dogs.
We also encourage a better work-life balance for athenistas with our flexibility. While we know in-office collaboration is critical to our vision, we recognize that not all work needs to be done within an office environment, full-time. With consistent communication and digital collaboration tools, athenahealth enables employees to find a balance that feels fulfilling and productive for each individual situation.
In addition to our traditional benefits and perks, we sponsor events throughout the year, including book clubs, external speakers, and hackathons. We provide athenistas with a company culture based on learning, the support of an engaged team, and an inclusive environment where all employees are valued.
Learn more about our culture and benefits here: athenahealth.com/careers
https://www.athenahealth.com/careers/equal-opportunity
Skills Required
- Bachelor's degree in computer science, engineering, business analytics, information systems, or a related quantitative field
- 5 years of overall professional experience
- 3 or more years of experience in data analytics, data visualization, and hands-on data manipulation using SQL and Excel
- Advanced SQL expertise, including writing and optimizing queries for large-scale datasets from Snowflake or similar cloud databases
- Hands-on experience with data manipulation, VLOOKUP/XLOOKUP, and data validation tools for large reporting datasets
- Experience designing and building Power BI reports, including DAX, data modeling, and performance optimization
- Basic proficiency in Python for data analysis and task automation
- Understanding of data engineering practices
- Experience transforming Salesforce CRM data objects, including Leads, Contacts, Accounts, and Opportunities
- Experience in US healthcare or B2B commercial marketing or sales organizations
- Familiarity with marketing funnel metrics across the prospect lifecycle
- Familiarity with marketing automation tools and campaign performance metrics
athenahealth Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about athenahealth and has not been reviewed or approved by athenahealth.
-
Healthcare Strength — Health coverage is described as comprehensive, including medical, dental, and vision options alongside additional protections like accident and critical illness coverage. Mental health support and EAP-style counseling resources are also part of the package.
-
Leave & Time Off Breadth — Time-away offerings include PTO that covers vacation and sick time, paid holidays, and options for leaves of absence and sabbaticals. Flexible time off is positioned as a meaningful part of the overall rewards package for some roles.
-
Retirement Support — Retirement benefits include a 401(k) plan with employer matching, supported by broader financial wellbeing resources. Equity and performance bonuses are also referenced as part of total rewards.
athenahealth Insights
What We Do
athenahealth strives to cure complexity and simplify the practice of healthcare. Our innovative technology includes electronic health records, revenue cycle management, and patient engagement solutions that help healthcare providers, administrators, and practices eliminate friction for patients while getting paid efficiently. athenahealth partners with practices with purpose-built software backed by expertise to produce the insights needed to drive better clinical and financial outcomes. We’re inspired by our vision to create a thriving ecosystem that delivers accessible, high-quality, and sustainable healthcare for all. For more information, please visit www.athenahealth.com
Why Work With Us
We are here to make an impact on the healthcare industry at scale. We enable our diverse teams to move fast, grapple with interesting technical challenges, and innovate at every level. We are on a modernization journey and build on the hybrid cloud. We deliver best-in-class solutions to help every patient receive the best possible care.
Gallery
.png)
