Data Engineer Specialist I

The Franchise Tax Board (FTB) is hiring a Data Engineer Specialist I for its Data Lake Development Unit. The role supports the development, maintenance, and troubleshooting of data ingestion, parsing, and transformation processes that prepare reliable data for enterprise analytics, business intelligence, predictive modeling, and applications.

Responsibilities

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

As an 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

Preferred

Experience writing complex SQL queries and working with databases such as DB2, SQL Server, or similar platforms

Experience with relational database structures, including physical data models and table relationships; distributed data environments such as Hive, HDFS, or comparable big-data systems, relational, warehouse, and Hive data architectures; experience with Apache Hive/HiveQL in Hadoop environments for querying and processing large-scale datasets

Experience with structured project methodologies or experience participating in the SDLC life cycle of system or data related projects

Experience with data processing tools or ETL/ELT technologies such as DataStage

Experience working with structured data formats XML, JSON, and scripting languages such as Unix, Python etc

Experience working with data processing frameworks such as PySpark and understand how large datasets are transformed at scale

Ability to support and troubleshoot data workflows, identify data anomalies, and help ensure high quality data outputs

Strong analytical and problem solving abilities with attention 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

Experience leading and mentoring others

Strong organizational skills, including the ability to manage multiple priorities and meet deadlines

Proficiency with common productivity tools such as Outlook, Excel, Word, and SharePoint

Complex SQL

DB2

SQL Server

Relational Databases

Physical Data Modeling

Table Relationships

Distributed Data Environments

Hive

HDFS

Big Data Systems

Data Architectures

Data Warehousing

Apache Hive

HiveQL

Hadoop

Large-Scale Data Processing

Project Methodologies

SDLC

Data Project Experience

DataStage

ETL/ELT

XML

JSON

Unix Scripting

Python

PySpark

Data Transformation

Data Workflow Support

Data Troubleshooting

Data Anomaly Detection

Data Quality

Outlook

Excel

Word

SharePoint

Analytical Thinking

Problem-Solving

Attention to Detail

Accuracy

Logical Thinking

Verbal Communication

Written Communication

Cross-Functional Collaboration

Independent Work

Initiative

Reliability

Ownership

Accountability

Proactive Learning

Leadership

Mentoring

Organization

Priority Management

Deadline Management

Benefits

Convenient transportation and commuting options include: Light Rail stop, bicycle lockers, free parking, and carpool/vanpool opportunities

Company

Medical, dental, and mental health care for California prisoners

Elk Grove, California, USA

https://cchcs.ca.gov/

Founded in 2006

10001+ employees

Qualifications

Applicants must be authorized to work in the US without the need for a visa sponsorship, now or in the future

Experience writing complex SQL queries and working with databases such as DB2, SQL Server, or similar platforms

Experience with relational database structures, including physical data models and table relationships; distributed data environments such as Hive, HDFS, or comparable big-data systems, relational, warehouse, and Hive data architectures; experience with Apache Hive/HiveQL in Hadoop environments for querying and processing large-scale datasets

Experience with structured project methodologies or experience participating in the SDLC life cycle of system or data related projects

Experience with data processing tools or ETL/ELT technologies such as DataStage

Experience working with structured data formats XML, JSON, and scripting languages such as Unix, Python etc

Experience working with data processing frameworks such as PySpark and understand how large datasets are transformed at scale

Ability to support and troubleshoot data workflows, identify data anomalies, and help ensure high quality data outputs

Strong analytical and problem solving abilities with attention 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

Experience leading and mentoring others

Strong organizational skills, including the ability to manage multiple priorities and meet deadlines

Proficiency with common productivity tools such as Outlook, Excel, Word, and SharePoint

Required skills

SQL, DB2, SQL Server, Relational Database Modeling, Apache Hive/HiveQL, Hadoop, HDFS, DataStage, XML, JSON, Python, PySpark

Preferred skills

Experience leading and mentoring others

Experience

Entry level