Application Development Analyst – Data Intelligence (JO#6098)

JOB TITLE: Application Development Analyst – Data Intelligence

LOCATION: San Francisco or Sacramento

JOB OPENING #: 6098 


OVERVIEW 
The Judicial Council of California supports California’s court system, the largest in the nation, serving a population of more than 39.5 million people— about 12 percent of the total U.S. population. Our mission includes a commitment to providing fair and equal access to justice for all Californians.

The Application Development Analyst (ADA) works closely with the business application team, end users, external service providers, and other technical teams to gather and understand complex business data and reporting requirements. From the defined requirements, the ADA will 
• create a technical design
• develop or modify existing database components necessary to support the requirements
• develop data extract, transformation and load (ETL) design specifications 
• develop or modify existing ETL processes
• develop the meta-data layer and report design specifications 
• develop or modify existing meta-data layers and reports 
• develop test plans, test cases, and test scripts 
• perform functional, integration and performance testing 

In addition, the Application Development Analyst (ADA) will work with judicial branch architects, judicial branch technical teams and external service providers to maintain and support the reporting platforms. The ADA will
• identify required upgrades to reporting business intelligence platforms to maintain technical viability and to align with branch strategy and vision
• develop detailed task plans to complete the upgrades
• coordinate and complete upgrade tasks collaborating with judicial branch technical teams, judicial branch architects and external service providers
• develop test plans, test cases, and test scripts 
• perform regression testing 

This position is part of the Administrative Systems Development team and works independently with minimal supervision. This Application Developer Analyst will work with and collaborate with a number of Judicial Branch subject matter experts and personnel (enterprise architects, other judicial branch developers, senior business systems analysts, technical infrastructure and support teams, external service providers and project managers) to help develop, enhance, upgrade, support and troubleshoot business intelligence platforms and reports. This Application Developer Analyst supports critical Judicial Council programs such as the Court Appointed Counsel (CAC) program, the Temporary Assigned Judges Program (TAJP), and the Judicial Officer Privacy program. This Application Developer Analyst also provides reporting support to critical business functions such as the advisory and curriculum committee nominations processes; judicial position, appointment, and vacancy tracking; CJER faculty tracking; court roster reporting; and CAC/Assigned Judges claims financial reporting.

The Judicial Council strives for work life balance and includes substantial vacation and holiday time. In addition, we offer an excellent benefits package including pension, medical, dental and vision coverage, flexible spending, up to $130 per month reimbursement for qualifying commuting costs, and retirement savings plans. In San Francisco, the office is only a 7-minute walk from the Civic Center BART station in downtown San Francisco. In Sacramento, the office is located minutes from downtown, just north of Discovery Park. 

The successful candidate will be expected to work in the Judicial Council’s San Francisco or Sacramento office; Hybrid work options for employees who live in areas surrounding these locations may be considered.

RESPONSIBILITIES
• Business Intelligence Solution Development
• Production System Support of Business Intelligence Platforms
• Provide Complete, Current and Accurate Documentation
• Provide Clear and Accurate Communications regarding Assigned Work
• Business Intelligence Platform Upgrades
• Participate in Quality Assurance activities
• Business Intelligence Requirements Analysis and Design

Other Duties and Responsibilities:
• Technical training for new and emerging technology

MINIMUM QUALIFICATIONS 
Education and Experience 

Bachelor’s degree, preferably in computer science, information systems, or directly related field, and three (3) years of design and development experience including solid knowledge of, and proficiency in the software used in the assignment. An additional four years of professional experience as noted above may substitute for the bachelor’s degree. Or, additional directly related experience and/or education may be substituted on a year-for-year basis.

Desirable Qualifications
Business Intelligence Platform Experiences
• PowerBI Desktop/PowerBI Pro
o Visualization/Dashboard/Report Development
o Platform Configuration
o User/Security Administration
o Promotion Management
o PowerBI Data Gateways

Extract/Transform/Load (ETL) Platform Experiences
• Talend Data Integration 
o Job Development and Scheduling
o User/Security Administration
o Promotion Management

Database Experience
• Snowflake
• MS SQL Server
• Azure SQL
• Oracle

Cloud Experience
Primary
• Azure (Commercial)
Pluses
• AWS
• Google Cloud Platform (GCP)

Business Intelligence Architecture and Design Experience
• Data Extraction
• Data Cleansing
• Data Warehouse
• Data Mining and Insights
• Data Visualization

Other Information 
Please note: If you are selected for hire, verification of employment eligibility or authorization to work in the United States will be required.

HOW TO APPLY
To ensure consideration of your application for the earliest round of interviews, please apply by 5:00 P.M. on Sunday, December 3, 2023. This position requires the submission of our official application, a resume and a response to the supplemental questions. 

To complete the online application, please go to https://www.courts.ca.gov/careers.htm and search for JO# 6098.

The Judicial Council provides reasonable accommodation to applicants with disabilities who request such accommodation. Reasonable accommodation needs should be requested through Human Resources at (415) 865-4260. Telecommunications Device for the Deaf (415) 865-4272.

PAYMENT & BENEFITS 
$8,144 - $12,217 per month

Some highlights of our benefits package include:
• Health/Dental/Vision benefits program
• 14 paid holidays per calendar year
• Choice of Annual Leave or Sick/Vacation Leave
• 1 personal holiday per year
• Up to $130 per month reimbursement for qualifying commuting costs 
• CalPERS Retirement Plan
• 401(k) and 457 deferred compensation plans
• Employee Assistance Program
• Basic Life and AD&D Insurance
• FlexElect Program
• Pretax Parking
• Long Term Disability Program (employee paid/optional)
• Group Legal Plan (employee paid/optional)



The Judicial Council of California Is an Equal Opportunity Employer.

About the Company:
Judicial Council of California

Industry:
Government and Military