NewarkDERecruiter Since 2001
the smart solution for Newark jobs

Data Systems Analyst II IT Management Information Systems

Company: University of Delaware
Location: Newark
Posted on: December 4, 2019

Job Description:

SunIRef:it Data Systems Analyst II - IT Management Information Systems University of Delaware 346 reviews - Newark, DE University of Delaware 346 reviews Read what people are saying about working here. Job no: ****** Work type: Staff Location: Newark Categories: Information Technology, Full Time PAY GRADE: 31S CONTEXT OF THE JOB: 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. MAJOR RESPONSIBILITIES: Monitor software updates (patches, fixes and security) and implement into a production environment on a regular basis. 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. QUALIFICATIONS: 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. Applications close: Jan 02 2020 Eastern Standard Time Back to search results

Keywords: University of Delaware, Newark , Data Systems Analyst II IT Management Information Systems, IT / Software / Systems , Newark, Delaware

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other IT / Software / Systems Jobs


Back End Developer
Description: Back End Developer br If you are a Back End Developer with experience, please read on Location: Newark, DESalary: 50,000 - 65,000 DOE br Top Reasons to Work with Us br - Great company culture- (more...)
Company: CyberCoders
Location: Newark
Posted on: 12/7/2019

12T Technical Engineer
Description: AGE REQUIREMENTS: Must be between the ages of 17 and 35 br br Technical Engineers pen the plans that lead construction crews to success. As a Technical Engineer in the Army National Guard, you will (more...)
Company: Army National Guard
Location: Newark
Posted on: 11/21/2019

BI Developer
Description: SunIRef:it BI Developer JP Morgan Chase 21,745 reviews - Newark, DE 19713 JP Morgan Chase 21,745 reviews Read what people are saying about working here. As an experienced member of our Software Engineering (more...)
Company: JPMorgan Chase
Location: Newark
Posted on: 12/7/2019


Front End Developer
Description: Front End Developer br If you are a Front End Developer with experience, please read on Location: Newark, DESalary: 45,000 - 55,000 DOE br Top Reasons to Work with Us br - Great company culture- (more...)
Company: CyberCoders
Location: Newark
Posted on: 12/2/2019

Back End Developer!
Description: Horizon Services LLC is searching for a Back-End Developer with a minimum of 4 years' experience to join our Digital Marketing team in Newark, DE. The back-end developer will be responsible for server-side (more...)
Company: Horizon Services
Location: Newark
Posted on: 11/20/2019

Big Data - Software Engineer
Description: SunIRef:it Big Data - Software Engineer JP Morgan Chase 21,814 reviews Newark, DE 19711 In launching your career in our Software Engineering Group we look first and foremost for people who are passionate (more...)
Company: JPMorgan Chase
Location: Newark
Posted on: 12/4/2019

Technical Support Technician 2
Description: Technical Support Technician 2 Nows our time to inspire the future of healthcare together. At Siemens Healthineers, we are passionate about enabling healthcare professionals to deliver high quality patient (more...)
Company: Siemens
Location: Newark
Posted on: 12/7/2019

Senior System SQL Server DBA
Description: OVERVIEWAimia is a fast-paced environment with a business casual work atmosphere, where our entire team focuses on building a great product for our clients. -As a DBA team on our Software as a Service (more...)
Company: Aimia Inc
Location: Newark
Posted on: 11/19/2019

Java Developer
Description: JAVA Application Developer Summary: Signature Consultants is seeking a mid to senior level JAVA Application Developer. This is a hands-on development role. Requirements include 6-8 years of system development (more...)
Company: Signature Consultants
Location: Newark
Posted on: 11/29/2019

Applications Programmer II, Full Stack Web Developer, Librar...
Description: SunIRef:it Applications Programmer II, Full Stack Web Developer, Library University of Delaware 346 reviews - Newark, DE University of Delaware 346 reviews Read what people are saying about working here. (more...)
Company: University of Delaware
Location: Newark
Posted on: 11/27/2019

Log In or Create An Account

Get the latest Delaware jobs by following @recnetDE on Twitter!

Newark RSS job feeds