Data Engineer
Job Description And DutiesThe 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/2113Are 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).Please complete this optional survey letting us know how you heard about this position by clicking hereYou will find additional information about the job in the Duty Statement .Position DetailsJob Code #:JC-516741Position #(s):564-242-1401-XXXWorking Title: Data Engineer Classification:INFORMATION TECHNOLOGY ASSOCIATE$4,935.00 - $6,614.00 A$5,424.00 - $7,270.00 B$5,930.00 - $7,947.00 C$6,521.00 - $8,740.00 DNew to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable.# of Positions:MultipleWork Location:Sacramento CountyTelework:HybridJob Type:Permanent, Full TimeDesirable QualificationsIn 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 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 functi ons Contact InformationThe 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.govHuman Resources Contact:Classification & Hiring Unit(916) 845-3608Hiring Unit Contact:Franco Accettura / IT Workforce(916) 845-7620Franco.Accettura@ftb.ca.govPlease 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:EEO Office(916) 845-2860California 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: 5/25/2026