Hybrid Data Engineer — ETL | Big Data & SQL Expert

California Franchise Tax Board; Sacramento (CA); Hybrid; USD 55,000 - 98,000; Full time

Benefits offered by this job

Hybrid work arrangement

Job summary

California Franchise Tax Board is seeking a Data Engineer to design, maintain, and implement complex data integration services for the agency's enterprise data stores. You will collaborate with multiple teams to deliver robust data solutions while ensuring data integrity and privacy.

The role emphasizes building expertise in FTB's data architecture, leveraging Azure Cloud, SQL, and ETL tools, and supporting stakeholders across the organization. Hybrid telework is available.

Qualifications

• Experience reading relational database Physical Data Models (PDM).
• Experience in Azure DevOps and Azure Cloud skill sets.
• Experience writing and working with SQL queries or Unix/Linux scripts.
• Experience with SDLC tools, methodologies, and processes.
• Knowledge of ETL tools such as IBM DataStage, Informatica, or Microsoft SSIS.
• Knowledge of Apache Hive or Hadoop Distributed File System (HDFS).
• Knowledge of Big Data and data streaming tools like JSON, Python, and HQL.
• Experience with the PySpark Data Framework.

Responsibilities

• Design, maintain, and implement complex data integration services for enterprise data stores.
• Provide complex data and ad-hoc query support to business and technical partners.
• Develop knowledge of enterprise data systems, data architecture, and data integration best practices.

Skills

SQL queries

Unix/Linux

ETL tools

Azure DevOps

Azure Cloud

PySpark

Python

HDFS

Big Data

SDLC tools

Tools

IBM DataStage

Informatica

Microsoft SSIS

Apache Hive

Job description

California Franchise Tax Board is seeking a Data Engineer to design, maintain, and implement complex data integration services for the agency's enterprise data stores. You will collaborate with multiple teams to deliver robust data solutions while ensuring data integrity and privacy.

The role emphasizes building expertise in FTB's data architecture, leveraging Azure Cloud, SQL, and ETL tools, and supporting stakeholders across the organization. Hybrid telework is available.