Company:
AHI agilon health, inc.
Job Posting Location:
Remote - USA
Job Title:
Senior Data Engineer
Job Description:
At agilon health, become a part of a brand new and growing data engineering team. As a senior data engineer, you will work with other engineers that build quality data pipelines, transform and transport key business data elements from multiple sources into robust models for use in data analytics applications. Work with key stakeholders both internal and external as well as with executive leadership teams in delivering quality data infrastructure that contributes to an enterprise-wide data platform strategy as the company grows and adds new Medicare Advantage markets every year. Leverage key Big Data technologies in Amazon Web Services (AWS) such as S3, AWS Glue, AWS Athena, web services, managed RDS, and other third-party tools that interact with AWS cloud infrastructure.
Leverage Snowflake cloud data warehouse to enhance data models and build new models that provide value to business users. Participate and support key areas of business decision making, including but not limited to operational, clinical, and financial functions. Work closely with data analyst and data science teams to provide critical access to data that has been prepped, cleansed, and ready for analysis in a variety of tools including Power BI, SQL Server, Python, SAS, and others. The ideal candidate will have outstanding communication skills, proven data infrastructure design and implementation capabilities, strong business acumen, and an innate drive to deliver results. He/she will be a self-starter, comfortable with ambiguity and will enjoy working in a fast-paced dynamic environment.
Essential Job Functions
- Design, build, and implement quality data pipelines that deliver high quality data models to agilon systems and analytics applications.
- Play a key part in building and maintaining foundational data infrastructure to support data architecture and product development.
- Act as a liaison and leader between business & technical resources as needed.
- Partner with Data Engineers, Data architects, domain experts, data analysts, data scientists, and other teams to build foundational data sets that are trusted, well understood, and aligned with business strategy and to enable self-service analytics.
- Set up and participate in source code version control with Git and Azure DevOps.
- Partner with data governance bodies & product management teams to maintain a high degree of documentation and ETL transparency.
Required Qualifications
- Minimum of 5 years’ experience with data warehousing methodology & data engineering tools within a health care payer or provider environment, preferably within a managed care organization.
- Very strong experience with SQL, dimensional modeling, common data model (CDM) concepts, and optimizing/scaling data pipelines that support a data warehouse environment.
- Excellent understanding and knowledge of relational data sources and the difference between dimensional modeling and third normal form (3NF).
- Passion to work with large data sets and to solve complex & unique business problems with data engineering methods.
- Experience working and mentoring junior-mid level data engineers in large scale projects.
- A desire to work in a collaborative, team-based environment with both business & technical resources.
- Bachelor’s in Computer Science, Information Systems, Engineering, Mathematics, or a related field.
- Deep knowledge of data transformation technologies using SQL Server Integration Services (SSIS), Python, Azure Databricks, or other Big Data solutions.
- Proficiency in at least one object-oriented programming language, preferably Python, Java, or Scala.
- Experience working in version control environments using Azure DevOps or equivalent and Git repos to manage large scale coding projects.
- Experience working with information security teams to ensure HIPAA protocols and all security standards are adhered to all times.
Preferred Qualifications
- 6+ years’ experience with Medicare Advantage data in a global risk environment (claims, eligibility, MMR, RAPS, MOR, Capitation files) is highly desired.
- Exposure to working with resources such as actuarial, healthcare/medical economics, finance and/or clinical analytics requirements is a major plus.
- Experience building different data model types, including Star Schema, Common Data Model (CDM) or equivalent methodologies/techniques.
Location:
Remote - California
Pay Range:
$115,100.00 - $140,900.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.
