Data Systems Analyst, Senior-IRIM

Careerwebsite; Ypsilanti, Northern (MI, KY); Hybrid; USD 42,000 - 64,000; Part time

Job summary

Careerwebsite is seeking a Data Systems Analyst, Senior-IRIM to lead data warehouse initiatives and create flexible data marts for the IRIM department and campus stakeholders.

You will design and develop interfaces, boost data warehouse performance, and act as liaison between IRIM and IT teams to ensure compliant, scalable data solutions.

Qualifications

• Master's degree in Computer Science, MIS, or a related field, or equivalent combination of education and experience.
• At least six years of progressively responsible experience in distributed systems and database design is required.
• Minimum of three years designing and maintaining databases and related software.
• Familiarity with dimensional modeling for data warehouses.
• Experience with UNIX, Oracle databases, and web apps using PHP.
• Knowledge of source code management systems such as Subversion.

Responsibilities

• Provide database administrative functions in building a data warehouse.
• Design integrated intranet systems with applications, databases, and networks.
• Develop web-based interface with data warehouse to provide flexibility for users creating data marts.
• Evaluate and recommend new reporting tools for IRIM.
• Research and improve reporting mechanisms.
• Prepare documentation to support new IRIM systems and operations procedures.
• Participate as a technical team member in scope definition, feasibility, analysis, design and implementation phases.
• Structure and implement database to optimize data access and security.
• Maintain data security and integrity by enforcing access standards.
• Consult with users or design team to identify requirements and specs.
• Develop and maintain knowledge of SunGard SCT Banner system sufficient to support data warehouse development.
• Perform related departmental duties, as required.

Skills

Data warehousing

Database design

Project leadership

Web interfaces

Liaison between IRIM and IT

Education

Master's Degree in Computer Science / MIS or related field

Tools

UNIX

Oracle databases

PHP

Subversion

SunGard SCT Banner

Job description

Title: Data Systems Analyst, Senior-IRIM

Employee Classification: PT

Pay Grade: PT 10

Division: Academic and Student Affairs

Subdivision:Institutional Res and Info Mgt

Department: Inst Research and Accreditation

Campus Location: Main Campus

General Summary

Create and maintain a data warehouse environment capable of serving the needs of both the Institutional Research and Information Management (IRIM) Department and the campus. Serve as project leader for designated IRIM projects. Create internet-based user input and query interfaces for creating flexible, user-defined data marts from a data warehouse. Design and develop effective ways to boost data warehouse performance. Act as liaison between IRIM and IT technical staff.

Principal Duties and Responsibilities

• Provide database administrative functions in building a data warehouse.
• Design fully integrated Intranet systems that will include applications, database, networks, and related systems.
• Develop web-based interface with data warehouse to provide flexibility for the users in creating data marts.
• Evaluate and recommend new reporting tools for IRIM.
• Research and improve reporting mechanisms.
• Prepare documentation to provide user support for new IRIM systems and operations procedures.
• Participate as an integral member of the technical team in scope definition and feasibility, analysis, design and implementation phases.
• Structure and implement database to optimize data access and security.
• Maintain data security and integrity by implementing system access standards and procedures.
• Consult with users or design team to identify and document software/system purpose, workflow issues and output needs and to determine overall IRIM systems requirements and specifications.
• Develop and maintain knowledge of SunGard SCT Banner system, including system documentation, entity-relationship diagrams and foreign key relationships sufficient to support data warehouse development.
• Perform related Departmental duties, as required.

Minimum Qualifications

• Advanced knowledge of database design and maintenance, and user input and query interface design that is typically acquired through the completion of a Master's Degree in Computer Science, Management Information Systems or a related field, or a combination of formal education and experience is necessary.
• Expert level of skills in computer programming and analysis in a distributed systems environment typically acquired through at least six years progressively more responsible and complex experience is necessary.
• A minimum of three years experience designing, maintaining and modifying databases and related software is required.
• Familiarity with dimensional modeling to continue development of a data warehouse is required.
• Familiarity with UNIX operating system ORACLE databases, and industry-standard web applications development tools such as PHP is required.
• Familiarity with source code management system, such as subversion is required.

Preferred Qualifications

Institutional Research experience is highly desirable.

Special Instructions

N/A

Appointment Percentage

100%

All qualified applicants will receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity, religion, national origin, disability, veteran status, age, marital status, pregnancy, genetic information, or other legally protected status.