Link to Dept Website

Salary: $5,065.00 - $6,660.00
Posted: 10/30/2013

Job Description:
**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.

Under the general direction of the BI Requirement & Testing Unit supervisor within the Business Intelligence and Data Services Section, the incumbent supports the EDR Project by performing data validation on data sources for the MDM Master Data Management and the Foundation Enterprise Data Warehouse. Collaborates with enterprise customers to document requirements, research data needs and deliver quality data from existing data mart/warehouses. Provides overall project management for complex and critical Business Intelligence (BI) applications and ad-hoc requests for data. Works with developers to develop, maintain and enhance BI deliverables.


  • Experience working with DB2 databases and writing simple SQL queries
  • Experience validating data and information
  • Experience analyzing issues, reasoning logically, defining problems, and recommending effective solutions
  • Knowledge of working with a data warehouse
  • Experience working with mainframe files, TSO and FileAid
  • Experience working with major FTB systems (PASS, TI, BETS, INC, ARCS, etc)
  • Experience delivering excellent customer support in an Information Technology (IT) environment
  • Experience using BI tools like Business Objects, Reporting Services, Analysis Services, and Pivot Tables
  • Experience taking initiative, handling changing priorities and meeting critical deadlines, while using tact and good judgment
  • Knowledge of the Systems Development Lifecycle (SDLC)
  • Ability to work independently and in a team environment
  • Self-motivated with a strong work ethic

Current state employees with status in the above classification or lateral transfers from an equivalent class, former state employees who can reinstate into this class or persons who are reachable on a current employment list for this classification. A training and development assignment (T & D) may also be considered. All appointments are subject to SROA/Surplus hiring provisions. Surplus candidates must submit an application packet as outlined in this bulletin with a copy of their surplus status letter in order to be considered.

Interested applicants must submit ALL of the following documents:

*A completed application includes the position title, position number and contact person’s name in the job title line, and must be signed. Candidates who do not submit all of the required documents (incomplete application packages) will be eliminated from the selection process. All submitted information will be screened and the most qualified candidates will be invited to an interview. FTB EMPLOYEES MUST HAND DELIVER OR ROUTE TO: Stacy Tandy at M/S F-183. Candidates not currently employed by the Franchise Tax Board must send their application package to the address shown below. Multiple positions may exist for this vacancy.

RPA #1314-1665

Additional Information:

Working Title Position Number
IT Testing / Requirements Analyst 564 - 785 - 1312 - 001
Location County
BIDS/BI Requirements and Testing Unit SACRAMENTO
Timebase Tenure
Full Time Permanent   month(s)
Final Filing Date: Department Link:
Contact Unit/Address Contact Name/Phone
Exam Unit
P. O. Box 550
Sacramento, CA 95812-0550
Stacy Tandy
(916) 845-4801

Special Requirements:
Background Check Required

Use your browsers "BACK" button to return to your results/listing page.

Start A New Search

Enter your email address to be notified when new STAFF INFORMATION SYSTEMS ANALYST (SPECIALIST) vacancies are posted.

Start A New Search

View in Printer
Friendly Format

Notice: If you are not a current or former State employee, you must first take an examination to obtain list eligibility. This does not apply to Student Assistant vacancies. Learn all about it.

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.