Data Engineer Specialist I

California Franchise Tax Board is hiring a Data Engineer Specialist I to support development, maintenance, and troubleshooting of data parsing and transformation processes in its Enterprise Data Lake. The role contributes to data ingestion, schema development, validation, and operational monitoring to support reliable enterprise data.

Responsibilities

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

We offer opportunities for professional development and growth

Telework: Hybrid

Company

California tax agency administering personal and corporate income taxes

Sacramento, California, USA

https://www.ftb.ca.gov/

Founded in 1929

5001-10000 employees

Qualifications

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, Microsoft SQL Server, Relational Database Design, Hive, HDFS, Apache HiveQL, Hadoop, Data Warehousing, Systems Development Life Cycle (SDLC), DataStage, XML, JSON, Unix, Python, PySpark

Preferred skills

Experience leading and mentoring others

Experience

Mid level