Data Systems Analyst 4

UC Davis Health; Sacramento (CA); Hybrid; USD 2,158,344 - 2,258,784; Full time

Benefits offered by this job

Medical, Dental, and Vision Insurance

Paid Time Off and Vacation

Continuing Education Allowance

Retirement Savings Plans

Job summary

UC Davis Health in Sacramento is seeking a Data System Analyst to provide data management expertise and develop custom reports. The role requires a bachelor's degree in Information Technology or a related field, along with five years of related experience. This hybrid position offers competitive salary and comprehensive benefits.

The analyst will coordinate cross-departmental needs, mentor staff, and ensure high-quality documentation while working with IT partners. Ideal candidates will possess strong communication skills to engage technical and non-technical audiences effectively.

Qualifications

• Five years of experience as a Data System Analyst, Business Analyst, or related occupation.
• Experience in SQL, data warehousing, and technical communication.

Responsibilities

• Perform system analysis, design, and development.
• Provide technical leadership and application maintenance.
• Communicate effectively with technical and non-technical audiences.

Skills

SQL Server Integration Services (SSIS)

Data management practices

Communication skills

Data modeling

Python

Education

Bachelor degree in Information Technology or related field

Job description

Job Summary

Data System Analyst (University of California, Davis; Rancho Cordova, CA). Provide data management expertise in planning, designing, developing, implementing & administering data‑based systems that acquire, prepare, store, and provide access to data/metadata. Develop & manage custom reports using application‑specific reporting tools. Understand database design related to report writing & data extracts. Gather & document business requirements from customers related to report design & technical solutions. Assess reporting tools, design reports, and choose the best delivery method. Provide training & support for staff in business areas related to report development & data files. Design, test, implement, and evaluate information systems for the organization to ensure successful implementation of the products. Design, develop, and implement system functionality to meet strategic needs of the organization, and complex cross‑departmental needs. Assess workflow needs across departments. Utilize appropriate product development models, principles & techniques in system development & implementation. Analyze current documentation & data flows in departments and design system to reflect appropriate workflow. Align information system standards & operations with administrative & operational strategies. Participate in application deployment go‑live support & application on‑call support rotation, including adhering to policy availability & response times. Assess new features for possible inclusion in app updates. Develop data/information documentation for projects. Plan & conduct data analysis for projects, including managing multi‑institutional partnerships. Establish & uphold documentation standards, including data naming & value domain descriptions. Develop conceptual & detailed data models. Develop dimensional models for data subject areas. Design diverse data systems, create interfaces between computer systems, and manage metadata for digital collections. Provide technical support & guidance to the team to ensure timely application implementation. Create technical documentation, including system design, architecture maps & flows. Mentor project & operation team analysts in technical design, support & build of applications. Independently request & coordinate technical work from other departments to meet project goals. Track progress toward meeting project deadlines & fulfilling stated requirements. Participate in project management by setting & adjusting timelines for technical design & build activities, accommodating changes & unforeseen issues. Offer technical support to staff & project teams for complex issues. Apply standards to system requirements, design & project evaluation. Estimate project completion effort & assess how requested changes affect tasks & milestones. Recommend improvements to methods, processes & hardware/software for enhanced end‑user products. Participate in IT change management processes. Schedule & conduct technical analysis sessions. Coordinate review of data models & data definitions. Communicate with the Program Team, IT staff & stakeholders to develop & implement features that address UCDH's needs. Develop documentation for system design, modification, maintenance & enhancement. Work with IT partners & relevant departments to create system fallback procedures. Provide ongoing application management & serve as the technical point of contact for inquiries, updates, planning & post‑implementation support. Coordinate with appropriate teams to include application upgrades/replacements. Collaborate with IT partners to address application needs for future technology. Coordinate with other teams to ensure applications are managed & updated efficiently. Act as liaison for production issues, coordinating with customers, IT & vendors on required fixes or enhancements. Document ownership, custody & access requirements for data subject areas. Create & manage workflows. Telecommuting permitted from within the U.S.

Minimum Qualifications

• Bachelor degree or foreign equivalent in Information Technology, Computer Science, or related field.
• Five (5) years of experience as a Data System Analyst, Business Analyst or related occupation.
• SQL Server Integration Services (SSIS) for performing Extract, Transform, and Load (ETL), data warehousing, and data modeling; visualizations, SQL, and Python; system analysis and design to understand functional requirements and translate functions to technical design and development; report writing and data extracts and files; system administration and maintenance; large‑scale databases; representing information in abstract models; abstracting information requirements from real‑world processes to understand information flows; data management systems, practices and standards; data quality and governance issues and requirements; logical data design and data mapping or data conversion; data modeling and information design; data integration and the specification of data services.
• Communicating technical information to technical and non‑technical audiences at various levels in the organization.

Key Responsibilities

• 50% - System Analysis, Design and Development
• 30% - Technical Leadership
• 10% - Communication – oral & written
• 10% - Application Maintenance & Support

Position Information

• Salary or Pay Range: $193,400.00 - $202,400.00
• Salary Frequency: Monthly
• Salary Grade: Grade 25
• UC Job Title: DATA SYS ANL 4
• UC Job Code: 000599
• Number of Positions: 1
• Appointment Type: Staff: Career
• Percentage of Time: 100
• Shift (Work Schedule): M-F
• Location: UCDHAS Building (HSP165)
• Union Representation: 99 - Non‑Represented (PPSM)
• Benefits Eligible: Yes
• This position is hybrid (mix of on‑site and remote work)

Benefits

• High quality and low‑cost medical plans to choose from to fit your family's needs
• UC pays for Dental and Vision insurance premiums for you and your family
• Extensive leave benefits including Pregnancy and Parental Leave, Family & Medical Leave
• Paid Holidays annually as stipulated in the UC Davis Health Policies or Collective Bargaining Agreement
• Paid Time Off/Vacation/Sick Time as stipulated in the UC Davis Health Policies or Collective Bargaining Agreement
• Continuing Education (CE) allowance and Education Reimbursement Program as stipulated in the UC Davis Health Policies or Collective Bargaining Agreement
• Access to free professional development courses and learning opportunities for personal and professional growth
• WorkLife and Wellness programs and resources
• On‑site Employee Assistance Program including access to free mental health services
• Supplemental insurance offered including additional life, short/long term disability, pet insurance and legal coverage
• Public Service Loan Forgiveness (PSFL) Qualified Employer & Student Loan Repayment Assistance Program for qualified roles
• Retirement benefit options for eligible roles including Pension and other Retirement Saving Plans

Physical Demands

• Standing – Frequent 3 to 6 Hours
• Walking – Frequent 3 to 6 Hours
• Sitting – Frequent 3 to 6 Hours
• Lifting/Carrying 0‑25 Lbs – Occasional Up to 3 Hours
• Pushing/Pulling 0‑25 Lbs – Occasional Up to 3 Hours
• Bending/Stooping – Occasional Up to 3 Hours
• Squatting/Kneeling – Occasional Up to 3 Hours
• Keyboard use/repetitive motion – Occasional Up to 3 Hours

Mental Demands

• Sustained attention and concentration – Frequent 3 to 6 Hours
• Complex problem solving/reasoning – Frequent 3 to 6 Hours
• Ability to organize & prioritize – Frequent 3 to 6 Hours
• Communication skills – Frequent 3 to 6 Hours
• Numerical skills – Occasional Up to 3 Hours
• Constant Interaction – Occasional Up to 3 Hours
• Customer/Patient Contact – Occasional Up to 3 Hours
• Multiple Concurrent Tasks – Frequent 3 to 6 Hours

Work Environment

UC Davis is a smoke and tobacco free campus. Smoking, the use of smokeless tobacco products, and the use of unregulated nicotine products (e‑cigarettes) will be strictly prohibited on any UC Davis owned or leased property, indoors and outdoors, including parking lots and residential space. Participate in 24 hour 7 days per week on‑call rotation.

Special Requirements

• This is a critical position, as defined by UC Policy and local procedures, and as such, employment is contingent upon clearing a criminal background check(s) and may include drug screening, medical evaluation clearance and functional capacity assessment.
• This position is designated as a mandated reporter under CANRA and UC policy, and employment is contingent on compliance with applicable policies, procedures and training requirements.

Misconduct Disclosure Requirement

As a condition of employment, the final candidate who accepts a conditional offer of employment will be required to disclose if they have been subject to any final administrative or judicial decisions within the last seven years determining that they committed any misconduct; received notice of any allegations or are currently the subject of any administrative or disciplinary proceedings involving misconduct; have left a position after receiving notice of allegations or while under investigation in an administrative or disciplinary proceeding involving misconduct; or have filed an appeal of a finding of misconduct with a previous employer.

Equal Employment Opportunity Statement

The University of California, Davis is an Equal Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age or protected veteran status.