Senior Business Intelligence; BI and Data Warehouse Analyst

Senior Business Intelligence (BI) and Data Warehouse Analyst

The University of La Verne is unable to provide sponsorship for work visas at this time. Applicants must be authorized to work in the United States without the need for visa sponsorship now or in the future.

Responsible for the design, development, implementation, and the administration of the organization’s operational data store (ODS) and BI applications, including IBM Cognos and Microsoft Power BI. This role involves working closely with business stakeholders, IT teams, and others to ensure that the data warehouse and BI platforms meet business intelligence and reporting requirements. The incumbent will be responsible for the end-to-end management of BI applications and data integration processes, ensuring optimal performance, security, and data accuracy.

Lead the design, implementation, and maintenance of a centralized data warehouse and BI infrastructure to support departmental and University reporting, analytics, and dashboards. This role addresses workflow inefficiencies, integrates disparate data sources, ensures data integrity, and enables trusted, timely, and actionable data for institutional decision-making.

• Data Warehouse Administration ( ODS ) – Oversee the design, development, and maintenance of the institutional Operational Data Store ( ODS ) and supporting data warehouse infrastructure. Manage ETL processes to ensure accurate data extraction, transformation, and integration across institutional systems. Monitor data warehouse performance, manage storage resources, and ensure reliable daily operations. Maintain data models, schemas, and metadata to support reporting and analytics.
  
  Optimize database performance, including indexing, partitioning, and query tuning for high-volume datasets. Implement and maintain data governance policies and procedures to support data integrity, security, and compliance. Collaborate with data users and technical stakeholders to design and implement data models that support institutional reporting and analytics needs. Conduct data analysis and deliver actionable insights that support institutional initiatives and performance monitoring.

• Business Intelligence & Reporting – Collaborate with campus stakeholders to gather reporting requirements and translate them into business intelligence solutions. Develop and maintain key performance indicators (KPIs) and institutional metrics that support strategic planning and operational decision‑making. Ensure BI reports and dashboards are up‑to‑date, accurate, and delivered on schedule. Provide training and support for end‑users utilizing Cognos and Power BI tools.
  
  Conduct data analysis and deliver actionable insights that support institutional initiatives and performance monitoring.

• Project Management & Collaboration – Lead or participate in data and business intelligence initiatives that improve institutional reporting infrastructure. Collaborate with cross‑functional teams including Institutional Research, Information Technology, Finance, Operations, and other administrative units to align analytics capabilities with institutional goals. Provide support to users, troubleshoot data or application issues, and implement fixes or improvements. Document BI processes, data models, ETL processes, and BI application configurations, standards, and best practices to ensure consistency across projects.
  
  Manage complex communication flows among multiple institutional stakeholders involved in data and reporting initiatives.

• Performance Monitoring & Optimization – Identify opportunities to improve data warehouse architecture, BI applications, and data quality. Support advanced analytics initiatives, including data mining, predictive modeling, and self‑service BI. Monitor the performance of BI applications and the Operational Data Store to ensure reliability and efficiency. Identify opportunities for system optimization and implement improvements in query performance, reporting efficiency, and dashboard responsiveness.
  
  Automate routine reporting and data processes to reduce manual workload and improve operational efficiency.

• BI Application…