Data Systems Analyst, Senior-IRIM

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.
• Create 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.
• Expert level of skills in computer programming and analysis in a distributed systems environment.
• A minimum of three years experience designing, maintaining and modifying databases and related software.
• Familiarity with dimensional modeling to continue development of a data warehouse.
• Familiarity with UNIX operating system ORACLE databases, and industry-standard web applications development tools such as PHP.
• Familiarity with source code management system, such as subversion.

Preferred Qualifications

• Institutional Research experience is highly desirable.