Job Description And Duties

Are you looking for a challenging and exciting developer role in Data Development? The Enterprise Reports and Modeling Development Section is looking for an energetic Information Technology (IT) Specialist I to assist in development of the modernization of its information technology environment and alignment of activities across the system development life cycle (SDLC) in order to provide critical statewide services. We are looking for a self-motivated individual who enjoys learning and collaborating with others to join our team.

In your role, you will:

• Work independently and as a team to design, maintain, and implement complex data integration services for FTB’s enterprise data.
• Need a comprehensive understanding of the tools and techniques involved in data analysis and data integration.
• Provide complex data and ad-hoc query support to business and technical partners throughout the department.develop expert knowledge of FTB enterprise systems, data architecture, data sources, and data integration best practices.
• Work cooperatively with bureau and Technology Services Division (TSD) technical staff in support of planning and software implementation activities.
• Promote an environment and atmosphere of team work and cooperation consistent with the department’s values.
  
  

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 [email protected] . Please include the job control (JC) number and the position title in the subject line.

Additional positions may become available (eRPA 2425-00207).

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 .

Position Details

Job Code #:

JC-473074

Position #(s):

564-242-1402-XXX

Working Title:

Business Intelligence and Analytics (BIA) Developer

Classification:

INFORMATION TECHNOLOGY SPECIALIST I

$6,323.00 - $8,475.00 A

$6,954.00 - $9,319.00 B

$7,635.00 - $10,230.00 C

# of Positions:

Multiple

Work Location:

Sacramento County

Telework:

Hybrid

Job Type:

Permanent, Full Time

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

• Major in Computer Sciences/ Computer Engineering program, or other Information Technology discipline Excellent customer service and communication skills for interacting with business and technical staff
• Experience with the system development life cycle (SDLC) and project management principles and methodologies Experience with Microsoft software tools (Outlook, Word, Excel, Visio, and Project)
• Experience reading and understanding a Physical Data Model (PDM)
• Experience understanding and writing Python code
• Experience using statistical mathematics Experience developing reports using tools like Business Objects, Tableau, Microsoft SQL Server Reporting Services and Analysis Services
• Knowledge of relational databases such as IBM DB2, Microsoft SQL Server
• Knowledge of analytical modeling tools such as Jupyter Notebook, IBM SPSS and SAS Viya Knowledge of Extract, Transform, and Load (ETL) processes and techniques Knowledge of eXtensible Markup Language (XML), Extensible Stylesheet Language (XSL), XML Schema Definition (XSD),Extensible Stylesheet Language Transformations (XSLT), XPATH, and XQUERY
• Knowledge of ETL tools such as IBM DataStage, Informatica and Microsoft SSIS
• Knowledge of Enterprise Data to Revenue (EDR) and Franchise Tax Board's Legacy tax systems and functions
• Ability to work in a team environment and handle multiple project priorities and workloads
• Ability to shift priorities and/or workloads in order to achieve project goals
• Strong interpersonal, problem solving, analytical, planning, collaborati
• on, and negotiation skills
• Self-starter with excellent time management and organizational skills
• Adapts well to frequent change
• Attention to detail, conscientious about work products, ability to multi-task while maintaining accuracy
  
  

Contact Information

The 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.gov

Human Resources Contact:

Classification & Hiring Unit

(916) 845-3608

Hiring Unit Contact:

Steven Le

(916) 845-5767

[email protected]

Please 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-2860

California 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: 4/30/2025