Management Information Services (IT-MIS) supports the enterprise systems of the University, including the Human Resources, Student Information, and Financial systems, in addition to central database and data warehouse systems. IT-MIS is responsible for development of new and improved campus business practices and the support of core business systems that are critical to the University's strategic plan and institutional mission. IT-MIS is one of several groups within the larger organization of Information Technologies.
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, Database Administration.
Monitor software updates (patches, fixes and security) and implement into a production environment on a regular basis.
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 install row level security for new and updated models.
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.
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 under performing 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.
Responsible for minimizing impact systems of record when performing integration and ETL.
Turn technical specifications into system changes.
Implement and monitor data quality verification between source and destination systems to ensure data standards, consistency, and accuracy.
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 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.
Internal Number: 494568
About University of Delaware
The University of Delaware has a great tradition of excellence, from our roots extending back to a small private academy started in 1743, to the research-intensive, technologically advanced institution of today. Our alumni tell our story of achievement, from our first class, which included three signers of the Declaration of Independence and one signer of the U.S. Constitution, to the more than 154,000 living Blue Hens who are making vital contributions to the world. Vice President Joseph R. Biden Jr. and his wife, Jill, are both UD alumni. The University received its charter from the State of Delaware in 1833 and was designated one of the nation’s historic Land Grant colleges in 1867. Today, UD is a Land Grant, Sea Grant and Space Grant institution. The Carnegie Foundation for the Advancement of Teaching classifies UD as a research university with very high research activity—a designation accorded less than 3 percent of U.S. colleges and universities. UD ranks among the nation’s top 100 universities in federal R&D support for science and engineering. A state-assisted, privately governed institution, UD offers a broad range of degree programs: 3 associate programs, 147 bachelor’s p...rograms, 119 master's programs, 54 doctoral programs, and 15 dual graduate programs through our seven colleges and in collaboration with more than 70 research centers. Our student body encompasses more than 17,000 undergraduates, more than 3,600 graduate students and nearly 800 students in professional and continuing studies from across the country and around the globe. Our distinguished faculty includes internationally known authors, scientists and artists, among them a Nobel laureate, Guggenheim and Fulbright fellows, and members of the National Academy of Sciences, National Academy of Engineering and the American Association for the Advancement of Science. State-of-the-art facilities support UD's academic and public service activities. Our 146-foot coastal research vessel, Hugh R. Sharp—the most advanced in the U.S.—helps scientists across the region explore the sea. World-class figure skaters train at our High Performance Figure Skating Center. Partnerships with Nemours/A. I. du Pont Hospital for Children, Christiana Care and Thomas Jefferson University; the U.S. Army; Winterthur; Longwood Gardens and Hagley Museum offer unparalleled experiences in health sciences, defense research, art conservation, horticulture and history. The University is now transforming a 272-acre parcel, the site of a former auto assembly plant, into the Science, Technology and Advanced Research (STAR) Campus. Distinguished speaker series, symposia, 21 intercollegiate athletics programs and numerous intramural and club sports, more than 300 student organizations, concerts, exhibits and other arts and cultural activities enrich campus life.Thomas Jefferson once described Delaware as a "jewel" among states due to its strategic location on the East Coast, halfway between Washington, D.C., and New York City. Today, however, the location of Delaware's flagship university increasingly is invoked as "halfway between Los Angeles and London."In addition to our Georgian-inspired main campus in Newark, Del., UD has locations across the state--in Wilmington, Dover, Georgetown and Lewes. A thriving study-abroad program and expanding international partnerships further enhance our students' education as global citizens. We invite you to visit our campus or take our virtual tour today! http://video.realviewtv.com/education/udel/