Data Systems Analyst II, IT-Enterprise Systems and Cloud Services
Job no: 496492
Work type: Staff
Categories: Information Technology, Full Time
Data Systems Analyst II – IT Enterprise Systems & Cloud Services
Pay Grade: 31S
CONTEXT OF THE JOB:
The IT Enterprise Systems & Cloud Services (ESCS) unit in Information Technologies supports the University’s central computing systems which include enterprise class client/server, data storage and retrieval systems, web, and learning management, e-mail servers, the enterprise systems (human resources, student information, and financials), central databases, reporting, fundraising and data warehouse systems. The unit is responsible for the development of new and improved campus business practices and processes and the support of core business and information systems that are critical to the University’s strategic plan and the institutional mission. Support is also provided for enterprise architecture, business intelligence and analytics, cloud strategy, identity and access management, mobile applications, and workflow and document management, and for the institution wide web-based information services that support the core business systems.
The Data Systems Analyst II has data management responsibilities, including support of business intelligence (BI), analytic, Extract, Transform, and Load (ETL), and data warehouse management. The incumbent is part of a team of IT Data Custodians responsible for the maintenance and availability of the university’s BI ecosystem. Data Systems Analysts interface with data architects, business analysts, and system administrators to ensure analytic and intelligence workloads are efficient and available. Data Systems Analysts monitor the systems looking for performance and other issues, then suggest changes to indexes, configuration, etc. to ensure a high performing data ecosystem.
The Data Systems Analyst II reports to the Associate Director, IT Financials.
- Ensure a streamlined, efficient and robust data architecture from the data model down to the operating system by working closely with data architects and BI specialists.
- Responsible for operational data modeling for IT projects outside the scope of business area data architects.
- Administers the University Informatica Intelligent Cloud Services account.
- Configures data integrations in Informatica’s IICS offering.
- Maintain and support existing Informatica integrations.
- Uses SQL in OLTP and OLAP environments.
- Responsible for developing and supporting the integration of multiple systems of record
- Monitor the databases and data warehouses for underperforming queries and suggest optimizations.
- Responsible for database and data warehouse capacity monitoring, analysis, and planning.
- Participate on the expansions of Data Marts and Design.
- Implement and install schema changes for new and updated data models.
- Implement and install row level security for new and updated models.
- Responsible for minimizing impact systems of record when performing integration and ETL.
- Turn technical specifications into system changes.
- Apply data governance principles to identify and implement security controls to support the roles and responsibilities of Data Custodians.
- Provide guidance for data security (i.e. user roles).
- Implement and monitor data quality verification between source and destination systems to ensure data standards, consistency, and accuracy.
- Monitor software updates (patches, fixes and security) and implement into a production environment on a regular basis.
- Serves as a technical expert resource to Associate Director, Director, VP, and IT colleagues. Has an expert-level understanding of the business systems of the institution and associated data requirements and has mastered a variety of database design methods, security procedures and utilities. Participates in external training programs and provides instruction for internal training programs. Maintains knowledge and skills with respect to relevant state-of-the-art technology. Researches and evaluates future technologies and solutions.
- Establishes and maintains appropriate working relationships with colleagues and clients and follows University and department policies and procedures governing IT efforts. Contributes to the planning, leadership, and support regarding technical initiatives and innovative solutions. Works within the department’s overall strategic plan following project priorities and scope. Meets deadlines and achieves goals.
- Performs miscellaneous job-related duties as assigned.
- Bachelor of Science in CIS, MIS, or related discipline and five years of experience in a data warehouse environment, or equivalent combination of education and experience.
- Experience working with data warehouses, database, Business Intelligence storage, and ETL.
- Understand how the various components of a data management ecosystem interact.
- Data integration and modeling skills (conceptual, logical, and physical) with transactional and dimensional modeling experience.
- Good understanding of data modeling across relational, star/dimensional or other emerging approaches. Experience in data mapping and transformation.
- Experience with Informatica PowerCenter and/or IICS, preferably both.
- Experience with Oracle, Microsoft SQL Server, and an MPP data warehouse system.
- Experience with ETL, ESB, iPaaS, REST, SOAP, and Master Data Management systems.
- Strong analytical problem-solving skills.
- Effective verbal & written communication skills.
- Ability to document system configurations and changes.
- Ability to work on multiple projects simultaneously with minimal supervision.
- Experience reviewing database logs and system information to diagnose infrastructure issues.
- Highly self-motivated and directed with keen attention to detail.
Notice of Non-Discrimination, Equal Opportunity and Affirmative Action
The University of Delaware does not discriminate against any person on the basis of race, color, national origin, sex, gender identity or expression, sexual orientation, genetic information, marital status, disability, religion, age, veteran status or any other characteristic protected by applicable law in its employment, educational programs and activities, admissions policies, and scholarship and loan programs as required by Title IX of the Educational Amendments of 1972, the Americans with Disabilities Act of 1990, Section 504 of the Rehabilitation Act of 1973, Title VII of the Civil Rights Act of 1964, and other applicable statutes and University policies. The University of Delaware also prohibits unlawful harassment including sexual harassment and sexual violence.
Back to search results Apply now Refer a friend