Data Engineer

State of California - Franchise Tax Board; Sacramento (CA); Hybrid; USD 90,000 - 120,000; Full time

Job summary

State of California - Franchise Tax Board in Sacramento is seeking a Data Engineer Specialist I to contribute to building and maintaining data parsing and transformation processes within the Enterprise Data Lake. You will work on ingest pipelines, schema development, and data validation.

This role emphasizes collaboration, on-the-job learning, and daily operational monitoring, with a primary office requirement of four or more days per week; some remote work may be possible per guidelines.

Qualifications

• Experience with data ingestion workflows and ETL concepts.
• Familiarity with data parsing, schema development, and validation.
• Strong teamwork and communication skills.

Responsibilities

• Develop and maintain data ingestion pipelines for the Enterprise Data Lake.
• Support parsing logic, schema design, and data quality monitoring.
• Troubleshoot data transformation issues in production.

Skills

ETL processes

Data ingestion

Data transformation

Team collaboration

Education

Bachelor's degree in Computer Science or related field

Tools

SQL

ETL tools

Job description

Job Description and Duties

FTB’s Data Lake Development Unit is seeking an enthusiastic, proactive, and motivated Data Engineer Specialist I (Information Technology Specialist I) interested in contributing to meaningful, high impact work while continuing to develop their technical skills. The team transforms a wide range of operational, digital submission, financial transaction, and external data sources into detailed, structured data elements by processing and normalizing large volumes of raw, complex datasets into reliable datasets that support FTB’s enterprise analytics, business intelligence, predictive modeling, and enterprise applications…

As a Data Engineer Specialist I, you will work alongside experienced team members to support the development, maintenance, and troubleshooting of data parsing and transformation processes that load and structure data within the Enterprise Data Lake. You will gain hands on experience with data ingestion workflows, parsing logic, schema development, data validation, and daily operational monitoring…

Teamwork is a cornerstone of the unit’s success, with opportunities for professional development and growth and long term careers in technology…

This position is designated office-centered and requires 4 or more days in the office per week; it may be eligible for some remote work based on departmental guidelines and operational need.

For complete position details, review the official Duty Statement.

Final Filing Date: 10/28/2026

CLICK HERE FOR DETAILS