Eastern Michigan University
Data Systems Analyst, Senior-IRIM
Unix
Edtech.com's Summary
Eastern Michigan University is hiring a Senior Data Systems Analyst for the Institutional Research and Information Management (IRIM) Department. The role involves developing and maintaining a data warehouse environment, leading IRIM projects, creating web-based user interfaces for data marts, and serving as a liaison between IRIM and IT technical staff to enhance data warehouse performance.
Highlights
- Lead the creation and maintenance of a data warehouse supporting IRIM and campus needs.
- Design and develop integrated intranet systems including databases, applications, and networks.
- Develop flexible web-based query interfaces for data marts.
- Evaluate and recommend reporting tools and improve reporting mechanisms.
- Provide database administration and ensure data security and integrity.
- Consult with users and design teams to define system requirements and workflows.
- Develop and maintain expertise in SunGard SCT Banner system documentation for data warehouse support.
- Required skills include UNIX, ORACLE databases, PHP, and source code management tools like Subversion.
- Minimum qualifications include a Master's degree or equivalent experience in computer science or related fields, with at least six years of programming and analysis experience and three years of database design and maintenance.
- Institutional Research experience is preferred.
Data Systems Analyst, Senior-IRIM Full 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
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%
Similar Jobs
Network Systems Analyst/Engineer (IT System Analyst/Engineer)
Oregon Health & Science University
🇺🇸 Hybrid - US
IT Support
Stanbridge University
🇺🇸 Irvine, CA
Interface Analyst/Engineer (Application Engineer, Sr.)
Oregon Health & Science University
🇺🇸 Remote - US
Cloud Systems Administrator III
California State University - Fullerton
🇺🇸 Fullerton, CA
Senior Systems Administrator (Linux/Cloud)
Pennsylvania State University
🇺🇸 Reston, VA
