Data Engineer

California Franchise Tax Board; Sacramento (CA); Hybrid; USD 6,500 - 11,000; Full time

Job summary

California Franchise Tax Board seeks a Data Engineer IT Specialist I to help modernize the data environment and contribute to SDLC activities. You will design, maintain, and implement data services for enterprise data stores, providing complex data support to business and technical partners across the department.

The role emphasizes collaboration, problem-solving, and adapting to changing priorities within a hybrid-work setting in Sacramento County.

Qualifications

• Experience with the system development life cycle (SDLC) and project management principles.
• Knowledge of Enterprise Data to Revenue (EDR) and legacy tax systems.
• Experience reading and understanding a Physical Data Model (PDM).
• Experience with Python coding and data visualization/reporting tools.
• Knowledge of relational databases (DB2, SQL Server) and ETL processes.

Responsibilities

• Design, maintain, and implement data services for enterprise data stores.
• Provide complex data support and ad-hoc query services to partners.
• Collaborate with bureau and TSD staff on planning and implementation.

Skills

SDLC experience

Python knowledge

Data modeling

Analytical skills

Team collaboration

Tools

IBM DataStage

Informatica

SSIS

Tableau

SQL Server/DB2

Jupyter Notebook

IBM SPSS

Job description

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

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

Are you looking for a challenging and exciting role in enterprise data services? The Data Analytics & Visualization Section is seeking an energetic Information Technology (IT) Specialist I to support the modernization of FTB's data environment and contribute to activities across the system development life cycle (SDLC). We are looking for a self - motivated individual who enjoys learning, innovative problem - solving, and collaborating with others to help deliver high - quality data solutions that support critical statewide services.

The Data Engineer works independently and as part of a team to design, maintain, and implement data services supporting FTB's enterprise data stores. The Data Engineer applies comprehensive knowledge of data ingestion, integration, consumption, and data visualization techniques, along with expert and analytical modeling methods, to deliver high - quality data solutions. The Data Engineer also provides complex data support and ad - hoc query services to business and technical partners across the department.

As a technical Subject Matter Expert, the Data Engineer develops expert-level knowledge of FTB's enterprise systems, data architecture, data sources, modeling approaches, and best practices for data services. The Data Engineer participates in planning and implementation efforts with bureau and Technology Services Division (TSD) staff, and promotes an atmosphere of teamwork, collaboration, and alignment with departmental values. The role requires developing and maintaining effective working relationships with multiple divisions and delivering solutions within the Software Engineering domain.

Additional positions may become available (RPA 2627-00216).

Please complete this optional survey letting us know how you heard about this position by clicking here .

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

Position Details

Job Code #: JC-529050

Position #(s): 564-267-1402-XXX

Working Title: Data Engineer

Classification: INFORMATION TECHNOLOGY SPECIALIST I

$6,513.00 - $8,729.00 A

$7,163.00 - $9,599.00 B

$7,864.00 - $10,537.00 C

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

• Excellent customer service and communication skills for interacting with business and technical staff
• Experience with the system development life cycle (SDLC) and project management principles and methodologies
• Knowledge of Enterprise Data to Revenue (EDR) and Franchise Tax Board's Legacy tax systems and functions
• Experience with Microsoft software tools (Outlook, Word, Excel, Visio, and Project)
• Experience reading and understanding a Physical Data Model (PDM)
• Experience understanding and writing Python code
• Experience developing reports using tools like Business Objects, Tableau, Microsoft SQL Server Reporting Services and Analysis Services
• Knowledge of relational databases such as IBM DB2, Microsoft SQL Server
• Knowledge of analytical modeling tools such as Jupyter Notebook and IBM SPSS
• Experience with regression techniques, decision trees, simulation, forecasting, statistical mathematics, and clustering is required.
• Knowledge of Extract, Transform, and Load (ETL) processes and techniques
• Knowledge of ETL tools such as IBM DataStage, Informatica and Microsoft SSIS
• Ability to work in a team environment and handle multiple project priorities and workloads
• Ability to shift priorities and/or workloads in order to achieve project goals
• Strong interpersonal, problem solving, analytical, planning, collaboration, and negotiation skills
• Self-starter with excellent time management and organizational skills
• Adapts well to frequent change
• Attention to detail, conscientious about work products, ability to multi-task while maintaining accuracy.

Contact Information

The Human Resources Contact is available to answer questions regarding the application process. The Hiring Unit Contact is available to answer questions regarding the position.

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

Human Resources Contact:

Classification & Hiring Unit

[phone]

Hiring Unit Contact:

Spandana Chalamalla / 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: 9/9/2026