Edtech.com's Summary

St. Louis Community College is hiring a Senior Manager, Data Warehouse & Enterprise Reporting to manage the college's operational data store and Cognos analytics platform for institutional decision-making. The role leads development of a custom data warehouse and a new college-wide enterprise reporting system, working across PL/SQL, Oracle, Cognos, Tableau, and Power BI. It also directs a team through requirements gathering, project management, and stakeholder communication on data governance initiatives.

Highlights

Leads development and maintenance of a custom data warehouse using continuous improvement and secure coding practices
Plans and builds a new college-wide enterprise reporting system, including reporting standards
Designs and maintains data models for Cognos, Tableau, and Power BI reporting environments
Manages PL/SQL packages, tables, views, procedures, and scheduled events in Oracle
Oversees operational support and configuration management of the Ellucian Operational Data Store
Evaluates user requirements and assigns and manages data and reporting projects
Communicates technical initiatives to non-technical stakeholders and college leadership
Collaborates with developers, project managers, and business analysts on new software applications
Documents enterprise reporting standards and best practices for ODS and Cognos implementation
Requires a bachelor's degree with seven years of related experience, or an equivalent combination
Draws on five years of relational database experience, including Oracle SQL and PL/SQL
Prefers candidates with Banner Operational Data Store and higher-education experience
Involves after-hours and weekend availability for technical emergencies

Senior Manager, Data Warehouse & Enterprise Reporting Full Description

Position Summary

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.

Primary Duties Performed

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.

Qualifications/Experience

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. Experience in Higher Education with data and business processes, project management, and Ellucian Banner is highly preferred.

Working Conditions

Must be able to respond to technical emergencies and outages that may occur after hours.

Physical Requirements

Negligible

Let me find your next job.

Thanks - you're signed up.

Senior Manager, Data Warehouse & Enterprise Reporting

Edtech.com's Summary

Senior Manager, Data Warehouse & Enterprise Reporting Full Description

Virtual Desktop and Applications System Analyst Engineer (IT System Analyst/Engineer)

Specialist, Media

Associate, Technology Asset

IAM Engineer

Apprentice - IT Helpdesk Campus Support