Product Analytics Data Builder, Senior Associate

Join us as we work to create a thriving ecosystem that delivers accessible, high-quality, and sustainable healthcare for all. Position Summary: Build and enhance data models that power product, operations, strategy, and customer-facing analytics across athenahealth. In this role, you will translate business requirements into standardized, high-quality data assets within the Analytics Data Warehouse (ADW), with a focus on reliability, consistency, and usability. You will develop star schema models, fact and dimension tables, and supporting ETL processes that help teams access trusted data. This role is remote/hybrid/in-office based on team needs and reports to the Product Analytics Senior Manager. About the Team: The Product Analytics ADW Development team creates foundational data assets that enable analytics across athenahealth. The team partners closely with Product Management, Development, Operations, Strategy, and other internal stakeholders to support decision-making and product improvement. Team members use SQL, ETL tools, data modeling techniques, Python, and the ADW environment to build and maintain structured data assets. The team values clear communication, shared ownership, and continuous learning. Essential Job Responsibilities: Translate business requirements from Product Managers and data consumers into effective star schema data models. Develop fact and dimension tables in the Analytics Data Warehouse (ADW) using established design patterns and standards. Implement ETL processes that support data freshness, reliability, and performance. Document data models, lineage, and business definitions to support broader use of the data. Conduct data exploration and profiling to understand source data during discovery, testing, validation, and documentation. Build Python-based solutions, such as Jupyter Notebook workflows, to automate repetitive tasks and improve validation and analysis processes. Use AI-enabled tools that are available to streamline data exploration, validation, documentation, or coding tasks while applying sound judgment to confirm results and maintain data quality. Reinforce the use of standardized data assets and metrics, and help identify and address gaps as they are discovered. Support internal and external stakeholder needs by ensuring data models meet analytical requirements. Additional Job Responsibilities: Develop and maintain collaborative relationships with product teams and other business partners. Communicate technical concepts clearly to technical and non-technical audiences. Provide rationale for design decisions to support alignment and adoption. Contribute to improvements in data development practices, patterns, and reusable tooling. Assist with issue investigation and troubleshooting across data pipelines and data assets. Expected Education & Experience: Bachelor’s degree required; degree in Computer Science, Data Engineering, Data Science, Statistics, Analytics, Information Systems, or a related quantitative field preferred. 3+ years of overall professional experience, preferably including 2–3 years in data engineering or data warehouse development. Strong SQL skills, including experience building and optimizing data models in a cloud data warehouse environment; Snowflake experience preferred. Experience with ETL tools and processes; Airflow preferred. Experience with Python, including use of Jupyter Notebooks for data analysis, exploration, profiling, and reusable solutions. Familiarity with data visualization tools such as Sigma, Tableau, or Power BI, and understanding of how data models support effective visualization. Understanding of dimensional modeling concepts and star schema design patterns. Ability to translate complex business requirements into well-structured data models. Experience performing data validation checks to support data quality and integrity across pipeline stages. Strong written and verbal communication skills with the ability to work effectively across teams Expected Compensation $86,000 - $146,000 The base salary range shown reflects the full range for this role from minimum to maximum. At athenahealth, base pay depends on multiple factors, including job-related experience, relevant knowledge and skills, how your qualifications compare to others in similar roles, and geographical market rates. Base pay is only one part of our competitive Total Rewards package - depending on role eligibility, we offer both short and long-term incentives by way of an annual discretionary bonus plan, variable compensation plan, and equity plans. 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