Data Systems Analyst 4

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, & 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. 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, & 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., * 50% - System Analysis, Design and Development

• 30% - Technical Leadership
• 10% - Communication - oral & written
• 10% - Application Maintenance & Support

• 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, * 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

Outstanding benefits and perks are among the many rewards of working for the University of California. UC Davis offers a full range of benefits, resources and programs to help you bring your best self to work, as well as to help you and your family achieve your health, wellness, financial and career goals. Learn more about the benefits below and eligibility rules by visiting either our handy Benefits Summary for UC Davis Health Employees or Benefits Summary for UC Davis Employees and our Benefits Page .

If you are represented by a union, benefits are negotiated between the University of California (UC) and your union and finalized in a contract. Read your bargaining unit's employment contract, stay abreast of current negotiations and learn about collective bargaining at UC: ;br>

• 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. More information on our retirement benefits can be found here

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

UC Davis is a smoke and tobacco free campus effective January 1, 2014. 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 - Please contact your recruiter with questions regarding which activities apply by position * 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. A Culture of Opportunity and Belonging At UC Davis, we're committed to solving life's most urgent challenges and building a healthier, more resilient world. We believe in growing through every challenge, continually striving to improve, and welcoming new perspectives that strengthen our community. We recognize that a vibrant and innovative organization values both individual strengths and shared purpose. The best ideas often emerge when people with different experiences come together. As you consider joining UC Davis, we invite you to explore our Principles of Community , our Clinical Strategic Plan and strategic vision for research and education. We believe you belong here. 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. To view the University of California's Anti-Discrimination Policy, please visit: ;br> Because we want you to feel seen and valued, our recruitment process at UC Davis supports openness and authenticity. Research shows that some individuals hesitate to apply unless they meet every qualification. You may be an excellent fit for this role-or the next one. We encourage you to apply even if your experience doesn't match every listed requirement. #YouBelongHere