Data Engineer

California Franchise Tax Board; Sacramento (CA); Hybride; USD 55 000 - 98 000; Plein temps

Résumé du poste

California Franchise Tax Board seeks a Data Engineer (Information Technology Associate) to help build, maintain, and troubleshoot data parsing and transformation processes that load and structure data into the Enterprise Data Lake. You will contribute to ensuring data accuracy, integrity, and availability for analytics and enterprise applications.

Working in a collaborative team in Sacramento with hybrid telework, you will gain hands-on experience with ingestion workflows, schema updates, data

Qualifications

• Experience writing SQL queries and working with databases such as DB2, SQL Server, or similar platforms.
• Ability to interpret relational database structures, including physical data models and table relationships
• Knowledge of distributed data environments such as Hive, HDFS, or comparable big‑data systems; experience with relational, warehouse, and Hive data architectures; and familiarity with Apache Hive/HiveQL in Hadoop environments for querying and processing large‑scale datasets
• Familiarity with structured project methodologies or experience participating in the SDLC lifecycle of system or data‑related projects
• Experience with data processing tools or ETL/ELT technologies such as DataStage
• Comfortable working with structured data formats (XML, JSON) and scripting languages such as Unix, Python etc
• Experience working with data processing frameworks such as PySpark
• Ability to support and troubleshoot data workflows, identify data anomalies, and help ensure high‑quality data outputs
• Strong analytical and problem‑solving abilities with a ttention to detail, accuracy, and logical thinking
• Effective verbal and written communication skills, with the ability to collaborate across technical and non‑technical teams
• Ability to work both independently and collaboratively, demonstrating initiative, reliability, ownership of tasks, accountability, and a proactive approach to learning
• Strong organizational skills, including the ability to manage multiple priorities and meet deadlines
• Proficiency with common productivity tools such as Outlook, Teams, Excel, Word, and SharePoint

Responsabilités

• Develop, maintain, and troubleshoot data parsing and transformation processes.
• Load and structure data within the Enterprise Data Lake.
• Monitor daily data workflows and ensure data quality and integrity.
• Collaborate with team members and stakeholders across IT and analytics.
• Support data ingestion pipelines and schema updates.

Connaissances

SQL queries

Relational DB concepts

Hive/Hadoop

SDLC lifecycle

ETL/DataStage

XML/JSON scripting

PySpark

Data workflow troubleshooting

Analytical thinking

Communication skills

Self-motivation

Organization skills

MS Office

Outils

Hive

Description du poste

Job Description And Duties

The salary ranges listed in this Job Control may not reflect reductions in pay in accordance with the 2025 Personal Leave Program. Please follow the link for more information regarding the 2025 Personal Leave program. http://hrmanual.calhr.ca.gov/Home/ManualItem/1/2113

FTB's Data Lake Development Unit is seeking an enthusiastic, proactive, and motivated Data Engineer (Information Technology Associate) who takes initiative and is interested in contributing to meaningful, high-impact work while developing foundational technical skills.

Our 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. This processed data forms the foundation of many of the department's most critical functions, and the work you perform will help ensure the accuracy, integrity, and availability of data used across the enterprise. By supporting these essential data flows, you will play an important role in advancing FTB's mission to assist taxpayers and fund vital state programs.

As an Data Engineer, you will work alongside experienced team members to assist in 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, basic parsing logic, schema updates, data validation activities, and daily operational monitoring. This role provides an excellent opportunity to contribute to a collaborative and supportive team, grow your technical abilities, and develop foundational skills that will serve you throughout your IT career at FTB.

Teamwork is a cornerstone of our success. We value collaboration, shared problem solving, and working together to ensure strong outcomes. We offer opportunities for professional development and growth, and we are committed to helping staff build long‑term careers in technology. If you believe you would be a great fit for the Data Lake Development team, we look forward to having the opportunity to meet you!

Additional positions may become available (eRPA 2627-00109).

You will find additional information about the job in the Duty Statement.

Position Details

Job Code #: JC-536768

Position #(s): 564-261-1401-XXX

Working Title: Data Engineer

Classification: INFORMATION TECHNOLOGY ASSOCIATE

$4,935.00 - $6,614.00 A

$5,424.00 - $7,270.00 B

$5,930.00 - $7,947.00 C

$6,521.00 - $8,740.00 D

New to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable.

# of Positions: Multiple

Work Location: Sacramento County

Telework: Hybrid

Job Type: Permanent, Full Time

Desirable Qualifications

• Experience writing SQL queries and working with databases such as DB2, SQL Server, or similar platforms.
• Ability to interpret and understand relational database structures, including physical data models and table relationships
• Knowledge of distributed data environments such as Hive, HDFS, or comparable big‑data systems; experience with relational, warehouse, and Hive data architectures; and familiarity with Apache Hive/HiveQL in Hadoop environments for querying and processing large‑scale datasets
• Familiarity with structured project methodologies or experience participating in the SDLC lifecycle of system or data‑related projects
• Experience with data processing tools or ETL/ELT technologies such as DataStage
• Comfortable working with structured data formats (XML, JSON) and scripting languages such as Unix, Python etc
• Experience working with data processing frameworks such as PySpark
• Ability to support and troubleshoot data workflows, identify data anomalies, and help ensure high‑quality data outputs
• Strong analytical and problem‑solving abilities with a ttention to detail, accuracy, and logical thinking
• Effective verbal and written communication skills, with the ability to collaborate across technical and non‑technical teams
• Ability to work both independently and collaboratively, demonstrating initiative, reliability, ownership of tasks, accountability, and a proactive approach to learning
• Strong organizational skills, including the ability to manage multiple priorities and meet deadlines
• Proficiency with common productivity tools such as Outlook, Teams, Excel, Word, and SharePoint

Contact Information

Department Website: http://www.ftb.ca.gov

Human Resources Contact:

Classification & Hiring Unit

[phone]

Hiring Unit Contact:

Stephanie Milton / IT Workforce

[phone]

[e-mail]

Please direct requests for Reasonable Accommodations to the interview scheduler at the time the interview is being scheduled. You may direct any additional questions regarding Reasonable Accommodations or Equal Employment Opportunity for this position(s) to the Department's EEO Office.

EEO Contact:

Reasonable Accommodation Unit

[phone]

[e-mail]

California Relay Service: 1-800-735-2929 (TTY), 1-800-735-2922 (Voice) TTY is a Telecommunications Device for the Deaf, and is reachable only from phones equipped with a TTY Device.

Final Filing Date: 11/16/2026