The Organization
The PopHealth Learning Center (“PHLC”) is a California Social Purpose Corporation (SPC) committed to transforming how health care is delivered and experienced across California’s safety net. Established to prioritize social impact over profit, the organization is grounded in a mission to advance health equity and support community-centered approaches to care for those historically underserved.
PHLC is focused on strengthening the infrastructure required to advance equity-focused transformation in primary care and population health. This includes designing and managing large-scale practice transformation initiatives, delivering technical assistance through virtual learning environments and peer-based engagement, and supporting alignment across systems, funders, and care delivery partners. We serve as a strategic partner to organizations and institutions committed to advancing health equity, with all efforts grounded in a shared goal: building a more just, coordinated, and person-centered healthcare system that better serves communities historically marginalized by existing models of care.
The Position
The Data Engineer, reporting to the Director of Analytics and Impact, will be responsible for designing, building, and maintaining the data infrastructure that powers the Learning Center’s analytics, reporting, and program evaluation. This role ensures that high-quality, timely data flows seamlessly across systems to enable performance measurement, surface actionable insights, and demonstrate program outcomes.
Responsibilities
- Design, develop, and maintain robust and scalable data warehouse solutions on the Amazon Web Services (AWS) platform.
- Build, optimize, and manage ETL/ELT pipelines using AWS tools to ingest data.
- Maintain and deploy ETL jobs that handle data integration and transformation, including native solutions such as Glue or PySpark.
- Design and implement schemas, tables, views, queries, and stored procedures optimized for performance, ensuring data integrity, governance, and security.
- Design and implement data models (star, snowflake) optimized for analytics and reporting.
- Ensure data quality and compliance by implementing validation, auditing, and access-control frameworks across all stages of data processing.
- Monitor, troubleshoot, and tune ETL jobs and query performance using best practices.
- Develop and manage CI/CD pipelines using AWS CodePipeline, CodeBuild, and GitHub/GitLab for continuous integration and automated deployments.
- Document data warehouse architecture, ETL/ELT workflows, and data models to maintain transparency and operational continuity.
- Implement and monitor logging, alerting, and incident response mechanisms using CloudWatch, CloudTrail, and SNS.
- Stay current with emerging AWS data services and analytics trends to continuously improve data architecture and engineering practices.
- Follow and contribute to established database and data governance standards.
- Ensure compliance with HIPAA and industry security frameworks.
Required Qualifications
- Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field.
- 5+ years of hands-on experience in data modeling and data warehouse design.
- 3+ years of experience with AWS Cloud, including deployment, administration, and migration.
- Strong experience with AWS and ETL/ELT and data warehousing.
- Advanced proficiency in SQL and Python for data transformation, stored procedures, and performance optimization.
- Expertise in dimensional modeling and schema design (star/snowflake).
- Deep understanding of AWS data ecosystem — S3, Glue, Lambda, Redshift, Athena, RDS, and Step Functions.
- Strong analytical and problem-solving skills with the ability to troubleshoot complex data workflows.
Preferred Qualifications
- AWS Certified Data Analytics – Specialty or AWS Certified Solutions Architect – Professional.
- Experience with Apache Spark or PySpark on AWS Glue or EMR.
- Experience with BI tools.
- Familiarity with data security best practices in cloud environments (IAM roles, KMS encryption, VPC endpoints).
Team & Culture Building
- Foster a collaborative and inclusive environment that supports professional growth and development.
- Promote a culture of continuous improvement by identifying opportunities to enhance processes, systems, and team capacity.
- Provide training and guidance to teams to build organizational capacity and ensure alignment with organizational goals.
- Act as a cultural steward, ensuring the Learning Center’s values of equity, inclusion, and collaboration are reflected in the team’s work and interactions.
Applications will be evaluated on a rolling basis. California residents are strongly preferred, but non-California residents will be considered.
Compensation & Benefits:
The salary range for this position is $150,000 - $180,000. PHLC offers a generous benefits package that reflects our commitment to team member health and wellness. Our benefits package includes comprehensive medical, dental, and vision insurance, paid time off, life and disability insurances, a retirement plan, annual wellness days, and other resources designed to support the passion, commitment, and energy that is vital to our team members.
All new hires begin with a six-month evaluation period, which includes structured support and regular check-ins.
The PopHealth Learning Center is an equal opportunity employer that does not discriminate on the basis of race, color, religion or belief, disability, gender, nationality, ethnicity, sex (including pregnancy, childbirth, or related medical conditions), gender identity or expression, sexual orientation, or any other status protected by law. Black, Indigenous, Latinx and other people of color, and LGBTQIA+ people are strongly encouraged to apply. Reasonable accommodation will be made so that qualified disabled applicants may participate in the application process. Please advise in writing of special needs at the time of application.
