Healthcare Analytics Engineer II

agilon health is seeking a Healthcare Analytics Engineer II to support enterprise healthcare reporting, analytics, and operational decision-making. The role focuses on developing scalable data models, ETL/ELT pipelines, curated datasets, data quality practices, and SQL- and Python-based automation while partnering with business and technical stakeholders.

Responsibilities:

• Design, develop, and maintain scalable data models that support enterprise reporting, analytics, and operational decision-making
• Build, optimize, and maintain robust ETL/ELT pipelines using modern data transformation frameworks
• Develop and maintain curated datasets that improve data accessibility, consistency, and usability across business domains
• Partner with business stakeholders to gather requirements and translate business needs into scalable analytical solutions
• Lead efforts to improve data quality through validation, testing, monitoring, and implementation of data governance best practices
• Monitor and troubleshoot production data pipelines, proactively identifying and resolving performance or reliability issues
• Develop reusable SQL and Python-based solutions to automate data transformations and reporting processes
• Understand, adhere to, and implement the Company's policies and procedures
• Build collaborative relationships with business and technical stakeholders across the organization
• Drive continuous improvement by identifying opportunities to automate, standardize, and optimize analytics workflows
• Communicate technical concepts effectively to both technical and non-technical audiences
• Demonstrate accountability, initiative, and ownership of project deliverables
• Stay current with emerging technologies and industry best practices in analytics engineering and healthcare analytics
• Support cross-functional projects and contribute to strategic enterprise analytics initiatives

Requirements:

• 4–7 years of experience developing analytics solutions, data transformation pipelines, or enterprise reporting platforms
• Advanced proficiency in SQL, including performance optimization and complex query development
• Strong proficiency in Python or similar programming language for data transformation and automation
• Experience designing and maintaining dimensional data models and curated analytical datasets supporting Medicare Advantage, value-based care, population health, or healthcare operations
• Experience working with modern ETL/ELT methodologies and production data pipelines
• Bachelor's degree in Mathematics, Computer Science, Statistics, Engineering, Information Systems, or a related field required
• Strong ability to translate complex business requirements into scalable and maintainable data models
• Advanced SQL development and query optimization skills
• Strong understanding of dimensional modeling, data warehousing principles, and modern analytics engineering practices
• Experience designing reliable, scalable, and well-documented data pipelines
• Strong analytical and problem-solving abilities with excellent attention to detail
• Ability to independently prioritize multiple projects in a fast-paced environment
• Excellent written and verbal communication skills with the ability to communicate effectively across technical and business audiences
• Ability to mentor junior engineers and contribute to team technical growth
• Passion for continuous learning and improving healthcare through data and analytics
• Experience with cloud data platforms such as Snowflake, SQL Server, or similar modern data warehouses
• Strong experience with DBT or comparable data transformation frameworks
• Experience using VS Code, Git/Bitbucket, and CI/CD development practices
• Experience implementing automated data quality testing and monitoring
• Experience mentoring junior team members and participating in technical design discussions
• Master's degree preferred