Senior Manager, Data Warehouse & Enterprise Reporting

Location: Corporate College

Job Type: Full-Time Non-Academic Affairs

Job
Number: 26-00322

Organization: Enterprise Computing Services (900201)

Closing
Date:
Continuous

Salary: Commensurate with Experience

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

Tagged as: CSS