Data Engineer

The Foundation for California Community Colleges is hiring a Data Engineer for the California College Guidance Initiative (CCGI), an autonomous initiative housed at the Foundation. The role develops and maintains CCGI’s cloud data infrastructure, data pipelines, and analytics tools, supporting the initiative’s education and student-guidance work. Responsibilities Lead the development, maintenance, and optimization of batch and streaming ETL/ELT processes, including the development, refinement, and containerization of data loading and processing using event driven architecture and workflow orchestrationDevelop, containerize, test and maintain workflows within integrated development environments (IDEs) using AWS cloud services, Snowflake data warehouses, Python and SQL scripts, dbt, and shell scriptsReview, redesign, and expand data models supporting data warehousing and self-service business intelligence architecture to create fully automated data pipeline(s) from staged or streamed dat