Back

Senior Business Intelligence (BI) and Data Warehouse Analyst

Full time Business/Financial Affairs/Financial Aid Computer & Web Services/Info Technology

Job Description

4921.gif

Senior Business Intelligence (BI) and Data Warehouse Analyst

Job Description Summary:

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 (Banner, Slate, HR, finance, and external files), ensures data integrity, and enables trusted, timely, and actionable data for institutional decision-making.


Minimum Qualifications:

8 years of Experience with the following Technical Knowledge:
  • Strong understanding of data warehousing concepts, including star schemas, snowflake schemas, and Operational Data Store (ODS) architecture.
  • Proficiency in data integration tools and ETL/ELT processes, including knowledge of data transformation and loading techniques.
  • Expertise in IBM Cognos, including Report Studio, Framework Manager, and Cognos Administration.
  • Proficiency in Microsoft Power BI, including Power BI Desktop, Power BI Service, and Power Query.
  • Strong SQL skills for querying databases and managing data transformations.
  • Familiarity with database management systems (e.g., SQL Server, Oracle) and scripting languages (e.g., Python, PowerShell).

 

 
8 years of Experience with the following Analytical and Problem-Solving Skills:
  • Ability to analyze complex business requirements and translate them into effective BI solutions.
  • Strong troubleshooting and problem-solving skills for resolving data and application-related issues.
  • Attention to detail and a focus on accuracy and data integrity

8 years of Experience with the following Communication and Collaboration:
  • Excellent communication skills, with the ability to convey technical concepts to non-technical stakeholders.
  • Experience working in cross-functional teams and collaborating with business users to gather requirements and deliver solutions.
  • Ability to provide training and support to end-users, enhancing their ability to use BI tools effectively.
 
8 years of excellent demonstrable written and verbal skills.

  • 4 year of experience Experience managing BI-related projects, including planning, execution, and delivery within agreed timelines. Ability to prioritize tasks, manage time effectively, and handle multiple projects simultaneously. Experience gathering requiremets needed to create business and functional project or reporting specification
  • Bachelor’s degree in Computer Science, Information Systems, Data Science, or a related field.
  • 5+ years of experience in data warehouse administration, business intelligence, and application administration in IBM Cognos and Microsoft PowerBI.
  • Strong Experience with programming and scripting language (e.g., Python, Java, SQL R, C+++, CLI, HTML5, XMNL).
  • Ability to deal with ambiguity in a fast-paced environment.
  • Excellent verbal/written communication skills and data presentation skills.
  • Strong understanding of data governance, security, and compliance best practices.
  • Requires interpersonal skills in order to work with both technical and non-technical personnel at various levels in the organization and with outside vendors. Possess excellent documentations skill for reports and workflow processing.
  • Must be self-motivated, able to learn quickly, meet deadlines and demonstrate problem solving skills. Excellent analytical skills to define and reengineer business process to maximize the capabilities of technology without sacrificing the functional experience, business process flow, efficiencies or effectiveness
  • Working knowledge of data management software and database systems
  • Demonnstarated software repository skills. Demostrated testing and test planning skills. Demonstrated advanced and strong PL/SQL knowledge and tuning skills and oracle database design, along with an understanding of different data warehousing and dimensional modeling concept.
  • Demonstrated ability to work with end users in determining proposed data warehouse and reporting solutions, including enabling standard functionality, as well as custom modification to fulfill departmental needs.
  • Demonstrated ability to work both independently and closely with others according to project needs.
  • Demostrated ability to maintain a customer focus in providing technoloty services. Demonstrated skills in requirements gathering, designing, prototyping, troubleshooting and supporting users. Statistical analysis and/or math skills
  • Develop and implement test plans to ensure successfully delivery of a project.
  • Demonstrated ability to effectively manage time, and communicate clearly. SQL server and Oracle database query experience


Preferred Qualifications:

  • Master’s degree in Business Administration, Economics, Computer Science, Information. Management, Data Analytics, or related field with equivalent experience.
  • Ability to analyze large / complex datasets.
  • Excellent interpersonal and communication skills (oral and written), and professional demeanor and presentation, including active listening and ability to convey information clearly.
  • Analytical with strong problem-solving skills, takes initiative and uses good judgment, excellent follow-up and troubleshooting skills.
  • High attention to detail, outstanding organizational skills, and the ability to manage time effectively.
  • Certifications : A-CSD, Programmer, Scrum Developer, CSSLP/ISC2 .


Specific Duties:
Duty: 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
Percentage of Time: 30%

Duty: 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.
Percentage of Time: 20%

Duty: 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. .
Percentage of Time: 15%

Duty: 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
Percentage of Time: 15%

Duty: BI Application Administration (IBM Cognos & Power BI) serve as a backup – Install, configure, and maintain Cognos and Power BI environments to ensure system availability and performance. Manage user access, security roles, and permissions within both platforms. Develop and maintain dashboards, reports, and visualizations aligned with institutional business requirements. Troubleshoot application issues and coordinate with vendors when necessary to resolve technical problems. Stay current with platform updates, patches, and new features and ensure their smooth implementation. Provide training and support for end-users utilizing Cognos and Power BI tools.
Percentage of Time: 15%

Duty: Performs other special projects and assignments as requested.
Percentage of Time: 5%

Salary Range
Maximum: $114,535.11
Minimum: $98,718.83

Benefits Summary:

Applicants, please note that actual compensation is determined by several factors that are unique to each candidate, including but not limited to job-related skills, depth of experience, certifications, relevant education or training, and specific work location, among others. The offered wage or salary is only one aspect of an employee’s total compensation

Benefits include a comprehensive health and wellness plan, tuition remission program for employee, spouse, and dependent children, a generous contribution to the University’s 403B retirement plan, and a generous time off plan.

Employment is contingent upon successful completion and clearance of a background check and employment verification.


Location: La Verne Main Campus
Close Date:
Open Until Filled: No

To be considered for this position please visit our web site and apply on line at the following link: http://laverne.edu

Institutional Profile
Located in Southern California, the University of La Verne offers a distinctive and relevant educational experience to a diverse population of students, preparing them for successful careers and a commitment to lifelong learning across the liberal arts and professional programs. The academic units of the not-for-profit university include the College of Arts and Sciences, the College of Business and Public Management, the LaFetra College of Education, and the College of Law. The university offers both undergraduate and graduate programs, including degree programs tailored for working adults. The university's central campus is located 30 miles east of Los Angeles in the historic Old Town section of La Verne, a city with a population of approximately 35,000 at the foothills of the San Gabriel Mountains. The university also has eight regional campuses throughout California and the College of Law campus in Ontario, California. The university is classified as a Carnegie Doctoral Institution with moderate research activity. Core values are reflected throughout all curricular and co-curricular programs, its emphasis on close professor-student interaction, personal support of its students, and its diversity.

The University of La Verne prides itself in being reflective of the diversity of Southern California. Approximately 80 percent of its nearly 8,500 students come from diverse backgrounds and the U.S. Department of Education has designated the university as a Hispanic Serving Institution (HSI). With 80,000 alumni, the university fulfills a critical community function in educating students from underserved populations, many of whom are the first generation in their family to attend college.

The University of La Verne is an equal opportunity employer and does not discriminate against employment or employees on any basis prohibited by state and federal law. University of La Verne hires and promotes individuals based on their qualifications and is consistent with applicable state and federal laws, without regard to race, color, religion, gender, disability, medical condition a or sexual orientation






img.php?id=7076613&image=logo
Copyright ©2025 Jobelephant.com Inc. All rights reserved.

Posted by the FREE value-added recruitment advertising agency





jeid-c1ada1291e67b64da1276d6e93e346ed

Application Details (to apply use the Apply Now button below.)

How to Apply: Please click the "Apply Now" button below.

 


Jobs at the University of La Verne. When inquiring or applying for positions at the University of La Verne, please also reference AcademicCareers.com

Applicants with dual-career considerations can find university jobs such as professor jobs, dean jobs, chair / department head jobs, and other faculty jobs and professional and administrative staff employment opportunities at the University of La Verne and at other institutions of higher education in the region on www.AcademicCareers.com

To receive email alerts when new jobs at the University of La Verne are posted, job seekers can sign up at new job openings at the University of La Verne

 

 



 

University of La Verne
About University of La Verne

The University of La Verne is a private not-for-profit university located in La Verne, California, United States, about 35 miles east of Los Angeles.

Founded in 1891, the university is composed of the College of Arts and Sciences, the College of Business and Public Management, the LaFetra College of Education, the College of Health and Community Well-Being, and the College of Law and Public Service, eight regional campuses throughout Southern California, and robust online offerings. Scholastic opportunities abound, thanks to more than 50 undergraduate programs, more than 20 master’s degrees, five doctorates, and six credential programs.

Across all of the colleges, La Verne’s approximately 6,000 traditional age and adult learners help make the federally-designated Hispanic-Serving Institution one of the most diverse universities in the nation. Nearly half of the traditional undergraduates are first-generation students – the first in their immediate families to attend college. More than 70 percent of University of La Verne students receive some form of financial aid.

The university is also a pioneer in adult education, offering accelerated programs for adult learners at the La Verne Campus, regional campuses, and online.

University of La Verne is dedicated to the belief that a quality, values-based education enriches the human condition by engendering community engagement, scholarly accomplishment, and professionalism. Along with encouraging diversity, the university focuses on the individual as evidenced by its small class sizes. Professors are personally engaged and committed to helping students achieve their academic and professional goals.

 


To see additional information about our job opening(s) or to apply, please click on the “Apply Now” button at the bottom of our job posting.

Jobs at University of La Verne. When inquiring or applying for jobs at University of La Verne, please also reference AcademicCareers.com

Applicants with dual-career considerations can find university jobs such as professor jobs, dean jobs, chair / department head jobs, and other faculty jobs and professional and administrative staff employment opportunities with University of La Verne and at other institutions of higher education in the region on AcademicCareers.com

To receive email alerts when new jobs at University of La Verne are posted, please sign up for new job openings at University of La Verne.

 

 

Diversity_Logo.png



 

Apply Now