Senior Manager, Data Warehouse & Enterprise Reporting

St. Louis Community College•Corporate College, MO

2d•Onsite

About The Position

Performs duties necessary to manage college information in the operational data store (ODS) and data analytics platform (Cognos) for operational, management, and strategic purposes. As a member of the Information System Analytics and Data Governance team, this position is responsible for negotiating with stakeholders about planning, gathering requirements and designing and developing solutions that support the college’s Analytic and Data Governance initiatives; providing end user and campus report writing support; providing administrative support for the Enterprise Analytic tools; providing technical expertise to analytics project in areas such as implementation, testing, quality control, and the post implementation review.

Requirements

Bachelor’s Degree with seven (7) years of related experience, or an equivalent combination of education and experience.
A minimum of five (5) years’ experience with relational databases with thorough competence in Oracle SQL, including Oracle Packages, PL/SQL, Procedures and Functions, and relational data models required.
Demonstrated experience with Banner Operational Data Store.

Nice To Haves

Experience in Higher Education with data and business processes, project management, and Ellucian Banner is highly preferred.

Responsibilities

Manage the development, implementation and maintenance of our custom data warehouse and embrace continuous improvement and incremental delivery, enforce coding best practices and secure coding standards through peer code reviews and automation.
Plan and manage the development, implementation, and support of a new college-wide enterprise reporting system, including but not limited to the analysis, design, and development of reporting standards.
Effectively communicate technical information to non-technical individuals and groups and keep all levels of management members informed and educated on technology-related issues and initiatives that impact and add value to the college.
Evaluate the requirements of users, develop specifications to meet these requirements, develop or assign projects to staff as needed, and manage the status of all projects assigned.
Design, develop, manage, and maintain established data extracts necessary to support the ongoing data requirements for institutional reporting.
Perform varied research and analysis tasks to support the college administration and process internal and external requests for institutional data.
Provide leadership, establish protocols/processes/guidelines, and manage PL/SQL packages, duties include designing data warehouse/mart objects and creating and maintaining tables, views, indexes, functions, stored procedures, packages, and scheduled events in Oracle using PL/SQL.
Collaborate with developers, project managers, business analysts and business users in conceptualizing, estimating, and developing new software applications and enhancements.
Responsible for managing, maintenance, operational support, and configuration management of Ellucian Operational Data Store (ODS), data warehouse.
Establish and maintain documentations of the enterprise reporting service which includes ODS, Cognos and the need assessment and the best practices for implementation using the PL/SQL programming language.
Designs, develops, and maintains data models; Cognos, Tableau and Power BI metadata models; ETL and other reporting infrastructure components for the other analytic environments.
Lead the creation, enhancement, and performance of reports/dashboards to support analytics environment and work on problems of diverse scope and complexity.
Responsible for the managing operational support, configuration management, custom views development, and manages security for Enterprise BI tools.
Reviewing documents test plans for reporting solutions and assists in test execution.
This will be done in collaboration with Analysts and other resources responsible for the systems being interfaced.
Responsible for following the defined SDLC, ensuring solution development adheres to process controls.
Participate in the formal system change management process and is responsible for ensuring that all changes are tested and perform as intended.
Availability to work after hours and/or weekends, as specified by supervisor.
Performs other job-related duties as assigned.