Data Engineer (Information Technology Associate)

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 (Information Technology Associate) who takes initiative and is interested in contributing to meaningful, high-impact work while developing foundational 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, you will work alongside experienced team members to assist in 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, basic parsing logic, schema updates, data validation activities, 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-00109). 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. 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. 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 writing SQL queries and working with databases such as DB2, SQL Server, or similar platforms. • Ability to interpret and understand relational database structures, including physical data models and table relationships • Knowledge of distributed data environments such as Hive, HDFS, or comparable big-data systems; experience with relational, warehouse, and Hive data architectures; and familiarity with Apache Hive/HiveQL in Hadoop environments for querying and processing large-scale datasets • Familiarity with structured project methodologies or experience participating in the SDLC lifecycle of system or data-related projects • Experience with data processing tools or ETL/ELT technologies such as DataStage • Comfortable working with structured data formats (XML, JSON) and scripting languages such as Unix, Python etc • Experience working with data processing frameworks such as PySpark • 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 • Strong organizational skills, including the ability to manage multiple priorities and meet deadlines • Proficiency with common productivity tools such as Outlook, Teams, Excel, Word, and SharePoint