Job Posting: Data Engineer Specialist I

Franchise Tax Board

JC-534640
-
Data Engineer Specialist I
INFORMATION TECHNOLOGY SPECIALIST I

$6,513.00 - $10,537.00 per Month
New to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable.

Final Filing Date: 10/28/2026

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

FTB's Data Lake Development Unit is seeking an enthusiastic, proactive, and motivated Data Engineer Specialist I  (Information Technology Specialist I) who is interested in contributing to meaningful, high impact work while continuing to develop their technical skills. Our team transforms a wide range of operational, digital submission, financial transaction, and external data sources into detailed, structured data elements by processing and normalizing large volumes of raw, complex datasets into reliable datasets that support FTB's enterprise analytics, business intelligence, predictive modeling, and enterprise applications. This processed data forms the foundation of many of the department's most critical functions, and the work you perform will help ensure the accuracy, integrity, and availability of data used across the enterprise. By supporting these essential data flows, you will play an important role in advancing FTB's mission to assist taxpayers and fund vital state programs.

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. This role provides an excellent opportunity to contribute to a collaborative and supportive team, grow your technical abilities, and develop foundational skills that will serve you throughout your IT career at FTB.

Teamwork is a cornerstone of our success. We value collaboration, shared problem solving, and working together to ensure strong outcomes. We offer opportunities for professional development and growth, and we are committed to helping staff build long term careers in technology. If you believe you would be a great fit for the Data Lake Development team, we look forward to having the opportunity to meet you!

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

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.

Working Conditions

About the Technology Services Division (TSD) The mission of TSD is to securely deliver and support information technology solutions and services essential to the success of the FTB’s mission. By acting on our TSD mission, we will realize our vision of a collaborative and diverse team of IT experts who further innovation and empower our business partners to accomplish their goals. Read more about FTB.  Learn more about other FTB technical roles at this FTB microsite. Need help understanding the hiring process or have questions about FTB? We'd love to talk to you! Before applying, read through these step by step instructions to apply, or contact us at IT.Recruit@ftb.ca.gov. Please include the job control (JC) number and the position title in the subject line.

  • This position requires 4 or more days in the office per week. It is designated office-centeredand may be eligible for some remote work based on departmental guidelines and operational need

  • Interviews will be conducted in person.
  • This position is not eligible for visa sponsorship. Applicants must be authorized to work in the US without the need for a visa sponsorship, now or in the future.

Minimum Requirements

You will find the Minimum Requirements in the Class Specification.

Additional Documents

Position Details

Job Code #:
JC-534640
Position #(s):
564-261-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

Department Information

Our mission is to help taxpayers file timely and accurate tax returns, and pay the correct amount to fund services important to Californians.

FTB fosters an environment of equity and inclusion for all and we welcome everyone to be part of our diverse workforce.

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

Special Requirements

  • The position(s) require(s) a Background Investigation be cleared prior to being hired.

This business uses E-Verify in its hiring practices to achieve a lawful workforce. E-Verify is a web-based system that allows enrolled employers to confirm the eligibility of their employees to work in the United States. For more information about E-Verify, please go to www.dhs.gov/e-verify.

CALIFORNIA CODE OF REGULATIONS, TITLE 2, SECTION 172: All candidates for, appointees to, and employees in the state civil service shall possess the general qualifications of integrity, honesty, sobriety, dependability, industry, thoroughness, accuracy, good judgment, initiative, resourcefulness, courtesy, ability to work cooperatively with others, willingness and ability to assume the responsibilities and to conform to the conditions of work characteristic of the employment, and a state of health, consistent with the ability to perform the assigned duties of the class. Where the position requires the driving of an automobile, the employee must have a valid state driver's license, a good driving record and is expected to drive the car safely. The foregoing general qualifications shall be deemed to be a part of the personal characteristics of the minimum qualifications of each class specification and need not be specifically set forth therein.

**IMPORTANT NOTICE** As required by the department's rules of conduct, all employees of the Franchise Tax Board (FTB) must be in compliance with the California Revenue and Taxation Code. During the background investigation portion of the hiring process, FTB will review return information to verify California state income tax compliance.  Any failure to comply with the California Revenue and Taxation Code may prevent you from being hired at FTB. You must verify your filing status by calling 1-800-852-5711 to resolve any potential tax compliance issues, prior to submitting your application and seeking employment with FTB. All applicants not currently employed with the Franchise Tax Board will be subject to a pre-employment background investigation. The investigation will consist of completion of a pre-employment questionnaire, fingerprinting, and an inquiry to the Department of Justice to disclose criminal records. We comply with the Americans with Disabilities Act. Persons with hearing or speech impairments, call TTY/TDD (800) 735-2929.

Application Instructions

Completed applications and all required documents must be received or postmarked by the Final Filing Date in order to be considered. Dates printed on Mobile Bar Codes, such as the Quick Response (QR) Codes available at the USPS, are not considered Postmark dates for the purpose of determining timely filing of an application.

Final Filing Date: 10/28/2026

Who May Apply

Individuals who are currently in the classification, eligible for lateral transfer, eligible for reinstatement, have list or LEAP eligibility, are in the process of obtaining list eligibility, or have SROA and/or Surplus eligibility (please attach your letter, if available). SROA and Surplus candidates are given priority; therefore, individuals with other eligibility may be considered in the event no SROA or Surplus candidates apply. Individuals who are eligible for a Training and Development assignment may also be considered for this position(s).

Applications will be screened and only the most qualified applicants will be selected to move forward in the selection process. Applicants must meet the Minimum Qualifications stated in the Classification Specification(s).

How To Apply

Complete Application Packages (including your Examination/Employment Application (STD 678) and applicable or required documents) must be submitted to apply for this Job Posting. Application Packages may be submitted electronically through your CalCareer Account at www.CalCareers.ca.gov. When submitting your application in hard copy, a completed copy of the Application Package listing must be included. If you choose to not apply electronically, a hard copy application package may be submitted through an alternative method listed below:

Address for Mailing Application Packages

You may submit your application and any applicable or required documents to:

Franchise Tax Board
Classification and Hiring Unit
Attn: Stephanie Milton /IT Workforce
P.O. Box 550
Sacramento, CA 95812-0550

Address for Drop-Off Application Packages

You may drop off your application and any applicable or required documents at:

Franchise Tax Board
Classification and Hiring Unit
Stephanie Milton / IT Workforce
9646 Butterfield Way
Sacramento, CA 95827
Drop off at Welcome Center in Main Lobby (may be non-operational on weekends and holidays)
07:00 AM - 06:00 PM

Required Application Package Documents

The following items are required to be submitted with your application. Applicants who do not submit the required items timely may not be considered for this job:

  • Current version of the State Examination/Employment Application STD Form 678 (when not applying electronically), or the Electronic State Employment Application through your Applicant Account at www.CalCareers.ca.gov. All Experience and Education relating to the Minimum Qualifications listed on the Classification Specification should be included to demonstrate how you meet the Minimum Qualifications for the position.
  • Resume is required and must be included.
  • Other -

    REQUIRED: If you are basing your eligibility on educational requirements, you MUST provide a legible copy of your transcripts as proof of meeting the education requirement as listed in the Classification Specification (please see the Class Specification located under “Minimum Requirements” on the left-hand side of this job posting). Applicants with foreign transcripts must provide a foreign transcript evaluation that indicates the number of units to which the foreign course work is equivalent. Transcripts may be official or unofficial; please redact birthdates and social security numbers. If you are not basing your eligibility on an educational requirement, you may instead use the bypass option (when applying, select Choose/Upload for the required document and then select Bypass File).

  • Supplemental Application -
    In order to be considered for this position, interested candidates must submit a supplemental application. Your response must be no more than 1 type-written page(s) in length, using 12-point font, 1-inch standard margins and include your first and last name in the upper right-hand corner of each page. Respond to the following supplemental statement(s):

    Include specific information about your technical skills, education, training, work history, and professional accomplishments, and explain how they have prepared you for the responsibilities described in the Duty Statement.

    • Please provide an example of a time when you encountered a new or unfamiliar task or issue that required you to take initiative. Describe how you worked collaboratively with colleagues to identify and resolve the issue, supported positive team dynamics, and contributed to achieving the team’s goals.
Applicants requiring reasonable accommodations for the hiring interview process must request the necessary accommodations if scheduled for a hiring interview. The request should be made at the time of contact to schedule the interview. Questions regarding reasonable accommodations may be directed to the EEO contact listed on this job posting.

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:

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

Benefits

Benefit information can be found on the CalHR website and the CalPERS website.

In addition, Franchise Tax Board offers the following:

  • Convenient transportation and commuting options include: Light Rail stop, bicycle lockers, free parking, and carpool/vanpool opportunities

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:
Stephanie Milton /IT Workforce
(916) 845-4505
Stephanie.Milton@ftb.ca.gov

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
FTBReasonableAccommodationUnit@ftb.ca.gov
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.

Additional Application Instructions

A complete application package must be received in the Classification & Hiring Unit or postmarked by the final filing date and must include:

  • Completed employment information on the STD. 678, including  the “From” and “To” dates, “Hours Per Week,” and “Duties Performed" fields for all jobs listed in the “Employment History” fields (resumes do not take the place of these fields on the STD. 678)
  • All of the required documents listed in the “Required Application Package Documents” section 
  • The position number and job control number in the job title line of the STD. 678, if submitting a paper application package (these numbers will auto-populate in the job title line of the STD. 678 if submitting an electronic application through your CalCareer Account)
  • A signature, if submitting a paper application package

Candidates who do not follow all of the listed application instructions may be eliminated from the selection process. All submitted information will be screened and the most qualified candidates will be invited to an interview.

Electronic applications submitted through your CalCareer Account are highly recommended. If you are unable to apply electronically through your CalCareer account, please mail a completed and signed STD. 678 and application package to the mailing address provided above in the “Application Instructions” section.

Do not include full Social Security Number, method of eligibility, and LEAP information in your application package.

Examination Information

To apply for the Information Technology Specialist I position(s) as a list candidate, you must first take the online Information Technology Specialist I exam.


Equal Opportunity Employer

The State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation.

It is an objective of the State of California to achieve a drug-free work place. Any applicant for state employment will be expected to behave in accordance with this objective because the use of illegal drugs is inconsistent with the law of the State, the rules governing Civil Service, and the special trust placed in public servants.

Application Methods:
Electronic (Using your CalCareer Account)
By Mail
Drop-off
Print Job