Senior Manager, Data Warehouse & Enterprise Reporting

St. Louis Community College; Bridgeton (MO); On-site; USD 90,000 - 120,000; Full time

Job summary

St. Louis Community College is seeking an experienced data architect/analyst to manage the ODS and data warehouse, develop enterprise reporting, and support Cognos, Tableau, and Power BI environments.

You will translate stakeholders' requirements into scalable solutions and oversee end-to-end data workflows. The role requires strong Oracle SQL/PL-SQL skills, Banner ODS experience, and collaboration with analysts, project managers, and business users to ensure timely, accurate institutional

Qualifications

• Requires a Bachelor's degree with 7+ years in data systems.
• Extensive experience with relational databases and Oracle SQL/PL-SQL.
• Experience with Banner ODS and higher education data workflows preferred.

Responsibilities

• Manage development and maintenance of data warehouse and CI/CD practices.
• Plan and support enterprise reporting system across Cognos, Oracle, and BI tools.
• Communicate complex technical concepts to non-technical stakeholders.
• Evaluate user requirements and translate into technical specifications.
• Design and maintain data extracts for institutional reporting.
• Lead SDLC adherence and change management processes.
• Provide after-hours on-call support as needed.
• Coordinate with analysts, developers, and business users on projects.

Skills

Oracle SQL

PL/SQL

Data Modeling

Education

Bachelor's Degree with seven years of related experience

Tools

Banner ODS

Cognos

Tableau

Power BI

Job 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