Data Engineer

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 interested in joining an energetic and highly skilled team of developers? Are you looking for your next career move to grow your developer skills? Want to apply your technical skills with an energetic team of skilled developers? Are you motivated, a team player, enjoy learning and working in a collaborative environment? FTB's data team is looking for you! We are proud of our mission to help our California Taxpayers file accurate tax returns and to fund important state services by maximizing the use of data collected from all sources, ensuring data integrity, and protecting taxpayer privacy with extract transform and load to respective data stores. As a Data Engineer, you will collaboratively with teams to design, maintain, and implement the complex data integration services for FTB's enterprise data stores. Apply your comprehensive understanding of the tools and techniques involved in data analysis and data integration such as data warehousing, data consolidation. You will be responsible to provide complex data and ad-hoc query support to business and technical partners throughout the department and build relationships with stakeholders, diverse groups, and team. As a Data Engineer you will be your responsibility to develop expert knowledge of FTB's enterprise systems, data architecture, data sources and data integration best practices. You are expected to work cooperatively with the multiple levels of management and Technology Services Division (TSD) technical staff in support of planning and software implementation activities.We value an environment of teamwork and cooperation and your ability to foster and promote collaboration is vital to success in this role. We provide opportunities for personal and professional growth in fields like accounting, administration, collections, legal, and technology. Your opportunities are endless here at FTB. 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. Additional positions may become available (eRPA 2526-00833)., 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, 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 and evaluations 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).

• Other - A cover letter is required and must be included.

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.

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., 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, * Experience reading and understanding relational database Physical Data Model (PDMM)

• Experience in Azure DevOps and Azure Cloud skill sets
• Experience writing and working with SQL queries or Unix/Linux scripts
• Experience with the System Development Life Cycle (SDLC) tools, methodologies, and processes
• Knowledge and experience of ETL process and tools such as IBM DataStage, Informatica or Microsoft SSIS
• Knowledge of Apache Hive or Hadoop Distributed File System (HDFS)
• Knowledge of Big Data or Data streaming tools such as JSON, Python, HQL
• Experience in PySpark Data Framework
• Knowledge and experience delivering and supporting data solutions
• Ability to troubleshoot and resolve the complex data issues
• Strong interpersonal, problem solving, analytical, planning, collaboration, motivation, and negotiation skills
• Excellent communication skills and the ability to communicate effectively, in both written and verbal formats with technical staff and management
• Ability to work both independently and in a team environment while demonstrating initiative, integrity, ownership, and accountability
• Ability to work effectively by organizing multiple workloads, and determining strategies to complete work on time
• 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

• This position is eligible for limited remote working within California based on departmental guidelines and operational need. FTB has a minimum in-office requirement of two days per week for all positions including those that are eligible for telework. This is subject to change., 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., * 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.