Join us as we work to create a thriving ecosystem that delivers accessible, high-quality, and sustainable healthcare for all.athenahealth is a progressive & innovative U.S. health-tech leader, delivering cloud-based solutions that improve clinical and financial performance across the care continuum. Our modern, open ecosystem connects care teams and delivers actionable insights that drive better outcomes. Acquired by Bain Capital in a $17B deal, we’re growing fast and investing in bold, strategic product innovations. We foster a values-driven culture focused on flexibility, collaboration, and work-life balance.Headquartered in Boston, we have offices in Atlanta, Austin, Belfast, Burlington, and in India: Chennai, Bangalore and Pune.Job Summary: We are looking for a Senior Product Analytics Associate - ADW Development to join our team to drive improvement and value in the athenahealth product in Chennai. Your job will be to build and enhance our data models that support Product Management, Development, Operations, Strategy teams, and athenahealth’s customers by providing standardized, high-quality data assets within our Analytics Data Warehouse (ADW). Some of the things you will do include developing star schema data models to make our data accessible to customers; implementing fact and dimension tables following strict data design standards; enhancing existing ADW assets to support new products/features; and ensuring data reliability and consistency across our analytics environment.You are passionate about data architecture and know how to translate complex business requirements into well-designed data models. You are skilled at building and optimizing data assets using SQL, ETL tools, and data modeling techniques. You have strong attention to detail and thrive when implementing solutions that follow established patterns while addressing evolving business needs.The Team: We are a diverse group of athenistas who believe that being smart about how we structure and deliver data can lead to better products and more value for our clients. We don't just build tables; we create foundational data assets that power compelling analytics across the organization. We believe we are strongest when we support each other, and that learning is always part of the job.Job ResponsibilitiesWork with Product Managers and data consumers to understand business requirements and translate them into effective star schema data models that serve as a source of truth for the organizationDevelop fact and dimension tables in our Analytics Data Warehouse (ADW) following established design patterns and standardsImplement ETL processes to maintain data freshness and reliability while optimizing performanceDocument data models, lineage, and business definitions to support broader consumptionConduct data exploration and profiling to deepen understanding of source data, whether during early discovery on ambiguous requests or post-development for testing, validation, and documentationDevelop Python-based solutions (e.g., in Jupyter Notebooks) to automate repetitive tasks, improve data validation workflows, and enable the broader team through reusable toolingReinforce the use of standardized data assets and metrics, and help surface and fill gaps as discoveredSupport internal and external stakeholder needs by ensuring our data models meet their analytical requirementsDevelop and manage strong, collaborative relationships with associated product teamsTypical QualificationsStrong understanding of dimensional modeling concepts and star schema design patternsAbility to translate complex business requirements into well-structured data modelsDemonstrated ability to use data modeling tools and ETL processes to build reliable data assetsProficient with SQL optimization techniques to ensure performance at scaleExperience with data validation techniques, including building and running systematic checks to ensure data quality and integrity across pipeline stagesExperience in Python programming, with the ability to build automated solutions that improve team efficiency and analytical capabilitiesAbility to effectively communicate technical concepts to various audiencesAbility to collaborate across a range of audiences, both internal and external, and across a range of cohortsAbility to provide sound rationale for design decisions to gain others' support and commitmentExcellent verbal and written communication skillsEducation and experienceBachelor's Degree required; Degree (Bachelor's or Masters) in quantitative disciplines like Computer Science, Data Engineering, Data Science, Statistics, Analytics, or Information Systems preferredMinimum 5+ years overall professional experience, preferably including 2-3 years of data engineering or data warehouse developmentStrong SQL skills with experience building and optimizing data models in a cloud data warehouse environment (Snowflake preferred)Experience with ETL tools and processes (Airflow preferred)Experience with Python (Jupyter Notebooks preferred) for data analysis, exploration, profiling, and building automated/reusable solutionsFamiliarity with data visualization tools (Sigma preferred, Tableau, Power BI, etc.) and understanding of how data models support effective visualizationAbout athenahealthOur 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
