> Markdown version of [/jobs/ext/733941-senior-manager-data-warehouse-enterprise-reporting](https://www.wearedevelopers.com/jobs/ext/733941-senior-manager-data-warehouse-enterprise-reporting). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Manager, Data Warehouse & Enterprise Reporting - **Company:** St. Louis Community College - **Location:** Bridgeton, MO, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Business Analytics Applications, Data Analysis, Software Applications, Configuration Management, Information Systems, Data Governance, Extract Transform Load (ETL), Data Warehousing, Relational Databases, IBM Cognos Business Intelligence, Operational Data Store, Oracle (Applications), Oracle SQL Developer, Systems Development Life Cycle, Power BI, Secure Coding, SQL Stored Procedures, PL-SQL, Tableau (Software), Test Execution Engine, Banner Advertisement, Tools for Reporting - **Published:** June 29, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=47b9f13db18cf511 ## About the Role * 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. ## Description 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. ## Related Videos - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Best Coding Boot Camps in Germany](https://www.wearedevelopers.com/magazine/237-best-coding-boot-camps-in-germany) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)