Job description

JOB TITLE: Data Engineer (Senior Technology Analyst)

LOCATION: San Francisco or Sacramento

JOB OPENING #: 5883

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 Data Engineer (Senior Technology Analyst) position is assigned to the Information Technology Data Systems Unit. The Data Services Unit provides technical integration and support for the JCC Data system platform and Data Warehouse.

This position will be responsible for highly advanced technical tasks related to data translation, data transformation, data warehousing, data prepping and cleaning, data mapping, data analysis, data management, data integration, and data quality.

This position receives general direction and supervision.

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; Remote work options for employees who live in areas surrounding these locations may be considered.

RESPONSIBILITIES

Analyze, design, construct, maintain, and enhance data integration processes and procedures.

• Collects data integration requirements and creates data technical solutions
• Understands and maintains a working knowledge of the data warehouse architecture, design, schemas and security
• Supports, monitor and ensure data integration processes are performing correctly

Develops and performs quality assurance

• Defines and create quality assurance plans and tests
• Performs testing and validation
• Conduct data validation, data mapping, and data cleaning on datasets, queries, and scripts

Provides technical support and troubleshooting

• Provides data integration technical support to stakeholders (Courts, JBEs, JCC, project team members, etc)
• Performs troubleshooting support to data integration processes impacting the stakeholders
• Collaborate with testing leads to establish sufficient coverage of the testing framework

Performs Research and Analysis to support data engineering efforts

• Preform data/data integration related research and present analysis to stakeholders and support team
• Present reports and analytical findings to technical and non-technical audiences in a manner that promotes common understanding
• Develop, present, and administer alternatives analysis for data processing issues

Other Duties and Responsibilities:

• Attend staff meetings (weekly, bi-weekly, monthly, or as scheduled)
• Prepare/attend for one-on-ones (weekly or bi-weekly)
• Attends Vendor management meetings (as needed)
• Attend relevant committee and stakeholder meetings (as needed)
• Attend training to complete training requirements (on-going)
• Maintain knowledge in current and emerging technologies (on-going)

MINIMUM QUALIFICATIONS

Education and Experience

Bachelor’s degree, preferably in computer science, information systems, or a related field, and five (5) years of experience maintaining complex infrastructure with extensive knowledge in assigned area of expertise such as servers, hardware, operating systems and/or network operating systems, network hardware, telecommunications, and security.

Possession of a bachelor’s degree in computer science, information systems, or directly related field may be substituted for one of the years of required experience. 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.

OR

One year as a Technology Analyst with the Judicial Council of California or one year of experience performing the duties of a class comparable in the level of responsibility to that of a Technology Analyst in a California Superior Court or California state-level government entity.

Desirable Qualifications:

• Experience with data warehouse and data integration Architectural framework technology skills:
• Snowflake -- database management
• Talend -- extract-transform-load and extract load-transform (ETL/ELT) solution
• Power BI -- business intelligence (BI) and data visualization and reporting appliance
• Azure Data Lake Storage -- primary data ingestion and storage component and cloud services platform

• Experience in industry-standard methods, tools, techniques and processes
• Strong problem-solving skills
• Proficient in complex SQL writing
• Proficient in MS Office, specifically Word and Excel,.
• Ability to work independently and as part of a team
• Strong written and verbal communication skills

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 Thursday, June 15, 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# 5883.

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

$7,267 - $10,901 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.

Job Type: Full-time

Pay: $7,267.00 - $10,901.00 per month

Benefits:

• Health insurance

Experience level:

• 5 years

Schedule:

• Monday to Friday

Experience:

• Informatica: 1 year (Preferred)
• SQL: 1 year (Preferred)
• Data warehouse: 1 year (Preferred)

Work Location: Hybrid remote in San Francisco, CA 94102

jjbodyshop.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, jjbodyshop.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, jjbodyshop.com is the ideal place to find your next job.