Data Systems Analyst 4

About the role

Provide data management expertise in planning, designing, developing, implementing & administering data-based systems that acquire, prepare, store, & 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, & choose the best delivery method. Provide training & support for staff in business areas related to report development & data files. Design, test, implement, & evaluate information systems for the organization to ensure successful implementation of the products. Design, develop, & implement system functionality to meet strategic needs of the organization, & 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 & designs system to reflect appropriate workflow. Align information system standards & operations with administrative & operational strategies.

Responsibilities

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

Requirements

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

Qualifications

• For full consideration, applicants are encouraged to upload license and/or certification if required of the position.

Skills

• System Analysis, Design and Development
• Technical Leadership
• Communication – oral & written
• Application Maintenance & Support

Benefits

High quality and low-cost medical plans to choose from to fit your family's needs
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
Retailment benefit options for eligible roles including Pension and other Retirement Saving Plans.

Pay

$193,440.00 - $202,400.00

Schedule

M-F