Data Governance Analyst Specialist I

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 a fast-paced and challenging position that will provide you with extremely valuable Data Analysis and Testing experience? We are seeking a highly motivated individual able to demonstrate effective critical thinking and analytical skills to join our team. The Data Governance Analyst Specialist I will be responsible for providing multi-faceted analysis and testing for the Enterprise Data Systems here at the Franchise Tax Board (FTB).

Our team is driving creative IT solutions to modernize FTB's technical environment, and we are looking for a self-directed individual with the ability to effectively collaborate with others and work as a team. This position requires you to be resourceful with excellent time management skills, while handling multiple assignments concurrently. Your work directly impacts the success of FTB's mission and helps Californians meet their tax obligations, which in turn funds many programs that support all Californians.

About the Job:

• Functions as a team member in the analysis, testing and implementation of software applications to meet the organization's current and evolving business needs.
• Performs effectively in a fast-paced environment with constantly changing priorities and is responsible for analyzing business and technical requirements, considering current and future enterprise projects in order to translate the requirements into test case scenarios.
• Accurately performs test activities, and track issues/defects; providing quality assurance activities related to system test script development while working closely with other IT Partners throughout the department to troubleshoot defects and implement quality system changes.
• Works collaboratively with technical partners and business stakeholders in the implementation of technical solutions and maintains or improve the performance and availability of enterprise data using a variety of methods, scripting languages, and tools.
• Develops decision making documents to address complex and critical issues and conducts independent research and analysis to recommend cost-effective solutions and process improvements. May act in a technical or workload lead role.
• Fosters cooperative working relationships with management, IT partners and business counterparts. The Data Governance Analyst Specialist I provides services which encompass the IT domain of Software Engineering.

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

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 .

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 View email address on us.fitly.work . 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 .

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 .

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 View phone number on us.fitly.work 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 View phone number on us.fitly.work.

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 specifically in data analysis and testing database components
• Experience with gathering and analyzing business, functional, and technical requirements; designing, developing, and maintaining design documentation and requirements; and identifying gaps in design and business requirements
• Experience designing logical test plans, writing and executing test scripts and completing follow-up results documentation
• Experience facilitating design review sessions, test walkthroughs, Joint Application Development (JAD) sessions, and/or educational workshops/trainings with business and/or technical partners
• Knowledge of FTB's organizational structure, business program areas, technology architecture, tax systems, applications, processes, and functions
• Experience with testing FTB tax systems or similar integrated applications utilizing IBM Database 2 (DB2), SQL Server, Confluent, Apache Hive HDFS (Hadoop Distributed File System), Java/Pega, Webservice calls
• Experience using testing tools such as FileZilla, IBM DataStage, Test Hub, and Azure DevOps
• Experience analyzing and creating data formatted in Extensible Markup Language (XML) and JavaScript Object Notation (JSON)
• Proficiency in writing and executing Structured Query Language (SQL) queries
• Demonstrable knowledge of or experience with Extract Transform Load (ETL) processes, data integration tools and data movement methodologies
• Thorough working knowledge and understanding the Software Development Life Cycle (SDLC), IT systems and processes, and experience utilizing and applying industry best practices in testing methodologies
• Ability to reason logically, identify problems, draw valid conclusions, and develop effective solutions
• Strong drive for problem solving and detailed-oriented
• Excellent verbal and written communication skills for interacting with all levels of staff, business and technology partners, including the ability to present ideas and explain complex technology concepts in user-friendly, plain language
• Strong work ethic with effective time management and effectively prioritize and manage multiple projects and workloads to meet critical timelines in a fast-paced environment
• Demonstrated ability to work independently with minimal guidance and in a team environment
• Flexibility and willingness to learn and thrive in an environment of change

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

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.

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

• Other -

  A cover letter is required and must be included.

• Other -

  Three professional references, including name, title, and phone number.

• 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):
  • Please describe how your work-related knowledge and experience support the Desirable Qualifications. Include examples that demonstrate that you should be considered for this position.