F

Foundation for California Community Colleges

Nonprofit funding partner for California colleges

Data Engineer

Data EngineeringConfirmed live in the last 24 hours
Full-timeCalifornia, USA$142k - $145k /yr

About the Job

Requirements

  • A relevant Bachelor of Arts or Bachelor of Science in Computer Science, Statistics, Informatics, Information Systems, or another quantitative field.
  • At least three years of experience as a Data Engineer or in a related role.
  • Ability to build processes supporting data transformation, data structures, metadata, dependency, and workload management.
  • Advanced proficiency with cloud data warehousing analytical tools such as Snowflake, Redshift, Spark, or Kafka.
  • Expert SQL knowledge, including SQL Server, PostgreSQL, or MySQL, and understanding of relational databases, query authoring, and optimization, as well as working familiarity with a variety of databases.
  • Advanced proficiency using ETL tools such as Jupyter Notebooks, dbt, or Talend.
  • Advanced proficiency with scripting languages such as Python, Scala, or R.
  • Advanced proficiency building and optimizing data pipelines and data sets.
  • A successful history of manipulating, processing, and extracting value from large structured and unstructured datasets.
  • Demonstrated ability to consistently develop strong technical documentation.
  • Strong data analysis and decision-making skills, including the ability to turn abstract brainstorming into concrete proposals for action.
  • Ability to advance projects without detailed supervision, prioritize tasks, and effectively manage multiple projects simultaneously.
  • Experience supporting and collaborating with cross-functional teams in a dynamic environment.
  • Ability to write accurately, appropriately for the audience, and concisely within task tickets in project management tools such as Jira.
  • Excellent verbal communication skills and ability to communicate complex information simply to technical and non-technical audiences.

Responsibilities

  • Lead the development, maintenance, and optimization of batch and streaming ETL/ELT processes, including developing, refining, and containerizing data loading and processing using event-driven architecture and workflow orchestration.
  • Develop, containerize, test, and maintain workflows within integrated development environments using AWS cloud services, Snowflake data warehouses, Python and SQL scripts, dbt, and shell scripts.
  • Review, redesign, and expand data models supporting data warehousing and self-service business intelligence architecture to create fully automated data pipelines from staged or streamed data through organization of data warehouse objects, producing access via reporting, alerts, or API access.
  • Design and implement data pipeline automation requiring Python scripting and SQL statements, integrating with systems such as Salesforce, Slack, and AWS services using serverless, cloud servers, and containerized systems.
  • Participate in meetings, research processes, requirement collection, and data analysis, and collaborate with project stakeholders.
  • Develop and maintain expert knowledge of CaliforniaColleges.edu data, systems, and business processes.
  • Continuously improve data pipelines and architecture by staying current with industry trends and best practices.
  • Perform other duties as assigned by the supervisor.

Desired Qualifications

  • Advanced certifications such as SnowPro Core, AWS Cloud Practitioner Certification, or AWS Certified Solutions Architect – Associate are a plus.
  • Experience working with K-12 data and/or education data is encouraged.
  • Experience working with K-12 or education data and/or interest in large educational systems and the equity challenges students face when navigating such systems.

About the Company

Foundation for California Community Colleges

Nonprofit funding partner for California colleges

FoundationCCC is the official nonprofit partner to California’s Community Colleges, working to expand student success and equitable access by securing grants, donations, and partnerships. It collaborates with stakeholders such as the California Department of Rehabilitation to fund and support educational programs and career pathways across the state. The organization’s funds come from grants and philanthropy and are allocated to programs that strengthen education and workforce opportunities for diverse students. Its distinct role as the backbone nonprofit for the nation’s largest and most diverse higher-ed network, plus its government and rehabilitation partnerships, sets it apart from other nonprofits. The goal is to increase access to education and improve career opportunities by providing sustained financial support and institutional development for California’s community colleges.

Company size
501-1,000
Company stage
Grant
Total funding
$4.7M
Headquarters
Sacramento, CA
Founded
1998

Recently Posted Jobs

Explore more opportunities at Foundation for California Community Colleges

See more jobs