Company: AHI agilon health, inc. Job Posting Location: Remote - USA Job Title: ​ Healthcare Analytics Engineer I Job Description: ​ Candidates must be legally authorized to work in the United States without employer sponsorship, now or in the future. At agilon health, you’ll join the Enterprise Analytics team dedicated to building data models, dashboards, and analytics tools that support business functions across the enterprise. As an Analytics Engineer I, you will contribute to the development and maintenance of reporting infrastructure while building foundational expertise in healthcare analytics and data engineering. You will work under the guidance of senior team members to support data modeling, pipeline monitoring, and analytics delivery efforts. This role is ideal for someone early in their analytics engineering career who is eager to learn, grow technical skills, and make an impact in transforming healthcare. To be considered, candidate must be located EST OR CST Essential Job Functions: - Support the design, development, and maintenance of data models for analytics and reporting - Assist in documenting standard tables, data sources, and basic relationships - Contribute to data quality initiatives by identifying inconsistencies and helping standardize definitions - Monitor existing data pipelines and escalate issues related to stability or timeliness - Partner with business and technical stakeholders to understand reporting requirements - Utilize SQL, Python, and related technologies to support data transformation and automation tasks Other Job Functions: - Understand, adhere to, and implement the Company’s policies and procedures - Demonstrate responsiveness and professionalism with internal stakeholders - Take initiative in developing technical and business knowledge - Communicate clearly and professionally, both verbally and in writing - Demonstrate reliability, accountability, and attention to detail in deliverables - Actively seek feedback and apply learnings to improve performance Required Qualifications: Minimum Experience - 1–3 years of experience working with data transformation, analytics, or ETL pipelines - Foundational proficiency in SQL - Working knowledge of Python or similar programming language Preferred Experience - Familiarity with cloud data platforms such as Snowflake or SQL Server - Exposure to dbt or modern data transformation frameworks - Foundational proficiency in VS code and Bitbucket - Interest in or exposure to healthcare data, particularly Medicare Advantage or value-based care models Education: - Bachelor’s Degree in mathematics, computer science, statistics, engineering, or related field required - Master’s degree preferred but not required Knowledge, Skills and Abilities: - Ability to understand business requirements and translate them into structured datasets with guidance - Strong analytical thinking and problem-solving skills - Clear written and verbal communication skills - Detail-oriented with strong organizational skills - Eagerness to learn new technologies and healthcare analytics concepts - Ability to document processes and maintain technical documentation Location: ​ Remote - PA Pay Range: ​ $87,000.00 - $106,600.00 Salary range shown is a guideline. Individual compensation packages can vary based on factors unique to each candidate, such as skill set, experience, and qualifications.

• Obsess over user success through technical problem-solving • Be the Lightdash expert • Teach and share complex concepts with users • Build and grow community around analytics engineering

• Obsess over user success through technical problem-solving • Be the Lightdash expert • Teach and share • Build and grow community

JOB DESCRIPTION Job Summary Performs research and analysis of complex healthcare claims data, pharmacy data, and lab data regarding network utilization and cost containment information. Evaluates, writes, and presents healthcare utilization and cost containment reports and makes recommendations based on relevant findings. KNOWLEDGE/SKILLS/ABILITIES - Develops, implements, and uses software and systems to support the department's goals. - Develops and generates ad-hoc and standard reports using SQL programming, SQL Server Reporting Services (SSRS), Medinsight, RxNavigator, Crystal Reports, Executive Dashboard, and other analytic / programming tools. - Coordinates and oversees report generation by team members and distribution schedule to ensure timely delivery to customers, ensuring the highest quality on every project/request. Responsible for error resolution, follow up and performance metrics monitoring. - Provides peer review of critical reports and guidance on programming / logic improvements; provides guidance to team members in their analysis of data sets and trends using statistical tools and techniques to determine significance and relevance. - Participate in and guide the design of large scale predictive and statistical models to predict future trends in cost, utilization, and performance. Guide team members on appropriate writing skills for executive summaries tailored to the audience. - Applies process improvements for the team's methods of collecting and documenting report / programming requirements from requestors to ensure appropriate creation of reports and analyses while reducing rework. - Manage the creation of comprehensive workflows for the production and distribution of assigned reports, document reporting processes and procedures. - Create new databases and reporting tools for monitoring, tracking, and trending based on project specifications. - Create comprehensive workflows for the production and distribution of assigned reports, document reporting processes and procedures. - Assist with research, development and completion of special projects as requested by various internal departments, or in support of requests from regulatory agencies, contracting agencies, or other external organizations. - Maintains SharePoint Sites as needed, including training materials and documentation archives. - Demonstrate Healthcare experience in Quantifying, Measuring and Analyzing Financial and Utilization Metrics of Healthcare. JOB QUALIFICATIONS Required Education Bachelor's Degree in Finance, Economics, Computer Science Required Experience - 6+ years of progressive responsibilities in Data, Finance or Systems Analysis - Expert knowledge on SQL, SSRS and SSIS or similar tools Preferred Education Bachelor's Degree in Finance, Economics, Math, or Computer Science Preferred Experience Preferred experience in Medical Economics and Strong Knowledge of Performance Indicators: - Proactively identify and investigate complex suspect areas regarding medical cost issues - Initiate in-depth analysis of the suspect/problem areas and suggest a corrective action plan - Apply investigative skill and analytical methods to look behind the numbers, assess business impacts, and make recommendations through use of healthcare analytics, predictive modeling, etc. - Analysis and forecasting of trends in medical costs to provide analytic support for finance, pricing, and actuarial functions - Multiple data systems and models - BI tools (ProClarity, MEd Insight, etc.,) Preferred License, Certification, Association QNXT or similar healthcare payer applications To all current Molina employees: If you are interested in applying for this position, please apply through the intranet job listing. Molina Healthcare offers a competitive benefits and compensation package. Molina Healthcare is an Equal Opportunity Employer (EOE) M/F/D/V.