Reporting to the Manager of Enterprise Applications and Integration, the Data Warehouse/BI Developer is responsible for implementation, support and coordination of the college Data Warehouse and Business Intelligence systems, including managing the data flows necessary to support enterprise-wide reports, alerts and dashboards.
Architect, maintain and upgrade the Ellucian Data Warehouse (EDW) and Operational Data Store (ODS) systems, which are built upon Oracle Data Warehouse software.
Work with college programmers and departments to support and coordinate the migration of various existing MS Access reports to the Cognos BI system; Coordinate and support the setting up of new reports, alerts, dashboards and supporting Cognos BI packages as necessary.
Design and implement ETL processes as necessary to support the college data warehouse/BI systems.
Provide backup support for the college Oracle and MS SQL Server database administrators.
Maintain the college Oracle-based ImageNow document imaging system.
This position requires the employee to carry a cell phone.
Perform other duties as assigned.
Database management experience required. Experience supporting Oracle and/or MS SQL servers preferred.
Proficiency in writing SQL queries, Oracle PL/SQL preferred.
Experience with Data Warehouse systems such as Oracle Data Warehouse preferred.
Experience supporting a BI environment such as IBM/Cognos BI preferred.
Experience managing data from Ellucian Banner or similar ERP system preferred.
Experience supporting databases on MS Windows and/or Red Hat Linux preferred.
Effective writing, oral communications and teamwork skills.
Wheaton College is an explicitly Christian, academically rigorous, fully residential liberal arts college and graduate school located in...