Data Engineer Specialist I

California Franchise Tax Board; Sacramento (CA); Hybrid; USD 6.500 - 11.000; Vollzeit

Zusammenfassung

California Franchise Tax Board is seeking a Data Engineer Specialist I to design, develop, implement, and support enterprise data integration solutions within the Software Engineering domain. The role requires strong ETL expertise, SQL proficiency, and collaboration across teams to ensure data quality and security.

The position is hybrid in Sacramento County, with full-time permanent status and competitive state salary ranges.

Qualifikationen

• Experience with SDLC and project management principles.
• Strong SQL skills in DB2 or Microsoft SQL and scripting languages.
• Proficiency with PySpark and Data Framework.
• Experience with relational databases such as IBM DB2 and SQL Server.
• Knowledge of ETL processes and data architectures.
• Ability to troubleshoot and resolve complex data issues.
• Experience with ETL tools such as DataStage, Informatica or SSIS.
• Familiarity with Microsoft Office applications (Outlook, Word, Excel, Visio, TFS, SharePoint).

Aufgaben

• Design, develop, implement, maintain, and support enterprise data integration solutions.
• Provide technical support for data access, reporting and ad hoc queries.
• Analyze requirements, develop data integration workflows, ensure data quality and security.
• Serve as SME on data architecture and collaborate with IT staff on planning and delivery.

Kenntnisse

SDLC experience

SQL querying

PySpark

Data framework

Data architectures

ETL processes

Troubleshooting

Cross-team collaboration

Tools

IBM DataStage

Informatica

Microsoft SSIS

IBM DB2

Microsoft SQL Server

Hive

MS Visio

SharePoint

TFS

Jobbeschreibung

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.

Are you looking for an exciting yet challenging Software Engineering position? If so the Franchise Tax Board has what you're looking for.

Data Engineer Specialist I

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).

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.
• Number 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

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

Human Resources Contact: Classification & Hiring Unit
[phone]

Hiring Unit Contact: Franco Accettura / 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: 10/27/2026