Data Warehouse & Enterprise Reporting Lead

St. Louis Community College

Bridgeton (MO)

On-site

USD 90,000 - 120,000

Full time

6 days ago
Be an early applicant
Application generator

Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.

Get past ATS filters

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

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Manager, Data Warehouse & Enterprise Reporting
Senior Manager, Data Warehouse & Enterprise Reporting

St. Louis Community College • Bridgeton (MO)

On-site
USD 90,000 - 120,000
Data Analyst: Enterprise Reporting & Dashboards
Data Analyst: Enterprise Reporting & Dashboards

Lake Michigan College • Benton Harbor (MI)

On-site
USD 65,000 - 90,000
Data Analytics Lead & Reporting Manager
Data Analytics Lead & Reporting Manager

Washington University in St. Louis • St. Louis (MO)

On-site
USD 75,000 - 129,000
Vacation days
Health insurance
Transit U‑Pass
+2
Strategic Data Architect: Self-Service Analytics
Strategic Data Architect: Self-Service Analytics

Lehigh Carbon Community College • North Whitehall Township (PA)

On-site
USD 90,000 - 140,000
Data Warehouse Lead & Architect — Cloud-Forward Solutions
Data Warehouse Lead & Architect — Cloud-Forward Solutions

Illinois State Board of Education • Springfield (IL)

On-site
USD 87,000 - 131,000
Data Architect: Data Lake, BI & Governance Lead
Data Architect: Data Lake, BI & Governance Lead

College of Southern Maryland • Colorado

On-site
USD 120,000 - 160,000
Health insurance
State pension
Wellness program
+1
HRIS & BI Analyst - Banner ERP Data & Reports
HRIS & BI Analyst - Banner ERP Data & Reports

St. Louis Community College • Bridgeton (MO)

On-site
USD 70,000 - 100,000
Strategic Enterprise BI & Reporting Architect
Strategic Enterprise BI & Reporting Architect

Droisys • St. Louis (MO)

On-site
USD 130,000 - 190,000
Data Integration Engineer – Hybrid Cloud & Apps
Data Integration Engineer – Hybrid Cloud & Apps

St. Louis Community College • Bridgeton (MO)

On-site
USD 85,000 - 115,000
Strategic Data Architect for Student Success
Strategic Data Architect for Student Success

The Chronicle Of Higher Education, Inc. • Chicago (IL)

On-site
USD 70,000 - 72,000