Data Engineer Specialist I

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 Are you looking for an exciting yet challenging Software Engineering position? If so the Franchise Tax Board has what you're looking for.

The Data Engineer Specialist I performs complex technical work related to the design, development, implementation, maintenance, and support of enterprise data integration solutions for FTB's enterprise data stores within the Software Engineering domain. The successful candidate works independently and collaboratively, applying advanced knowledge of Extract, Transform, and Load (ETL) processes, data integration tools, and data movement methodologies. The successful candidate provides technical support for enterprise data access, reporting, and ad hoc queries; analyzes business and technical requirements; develops and maintains data integration workflows; and ensures data quality, integrity, security, and compliance with enterprise architecture and data governance standards. As a technical subject matter expert (SME), the candidate maintains expert knowledge of FTB enterprise systems, data architecture, data models, and source systems; serves as a technical lead on assigned initiatives; and collaborates with Bureau and Technology Services Division (TSD) staff on system planning, development, testing, and implementation activities. The candidate promotes a professional, collaborative work environment and maintains effective working relationships with representatives across the department.

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

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-534641

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

Working Title: Data Engineer Specialist I 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 In addition to evaluating each candidate's relative ability, as demonstrated by quality and breadth of experience, the following factors will provide the basis for competitively evaluating each candidate:

We encourage applications regardless of whether you think you meet 100% of these skills below. Please highlight your knowledge, skills, and experience related to the below desirable qualifications in your application package.

All Experience and Education relating to the Minimum Qualifications listed on the Classification Specification should be included to clearly demonstrate how you meet the Minimum Qualifications and Alternate Range Placement for the position on your State Application (STD Form 678). The application should also clearly demonstrate the candidate’s ability to meet the Desirable Qualifications identified in this job advertisement. The Classification Specification is located on this Job Announcement Posting under "Minimum Requirements”.

• Experience with the system development life cycle (SDLC) and project management principles and methodologies
• Experience writing and working with complex SQL queries in DB2 or Microsoft SQL and other scripting languages
• Experience using PySpark and Data Framework
• Experience with relational databases such as IBM DB2, Microsoft SQL Server
• Experience with relational, warehouse, and hive data architectures
• Experience with Extract, Transform, and Load (ETL) processes and techniques
• Experience in troubleshooting and resolving complex data issues
• Experience with ETL tools such as IBM DataStage, Informatica or Microsoft SSIS
• Experience with Microsoft Office applications (Outlook, Word, Excel, Visio, Team Foundation Server (TFS) and SharePoint)
• Knowledge of Franchise Tax Board's Legacy tax systems and functions

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

(916) 845-3608

Hiring Unit Contact:

Franco Accettura / IT Workforce

(916) 845-7620

[email protected]

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

(916) 845-2860

[email protected]

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: 10/27/2026