Senior Business Intelligence (BI) Data Warehouse and Application Administrator
Apply NowCompany: University Of La Verne
Location: La Verne, CA 91750
Description:
Job Vacancy Announcement
Position Information
Functional Title
Senior Business Intelligence (BI) Data Warehouse and Application Administrator
Position Type
Administrative/Professional
Appointment Type
Regular
FTE %
100%
Work Schedule (if atypical)
This position is onsite. Eligibility to apply for Hybrid/ remote status after 6 months of employment.
University Overview
Embark on an exciting journey with the University of La Verne, where your career aspirations come to life in a vibrant and welcoming environment. Established in 1891, our diverse and inclusive community is more than just a university-it's a home for passionate individuals like you.
At the University of La Verne, we embody four core values that set us apart-Ethical Reasoning, Diversity and Inclusivity, Lifelong Learning, and Civic and Community Engagement. If you're fueled by these principles and are eager to make a meaningful impact, your journey begins here.
With a rich history spanning 132 years, the University of La Verne boasts a global Leo Family of 89,000+ accomplished alumni. As the #1 private university in California for social mobility according to U.S. News and World Report 2024, and recently recognized as the 33rd Best U.S. College by the Wall Street Journal 2024, we take pride in our commitment to excellence in education.
Join us in shaping the future, where your passion meets purpose. Come be part of something extraordinary and apply today!
Diversity Statement
The University supports a diverse and inclusive environment where students recognize and benefit from the life experiences and viewpoints of other students, faculty, and staff. Diversity is an active and intentional practice that supports difference and multiplicity to expand knowledge, educate capable citizens, develop the whole person, and serve our local and global communities. Promoting and sustaining diversity is a commitment to educational quality and the creation of positive, respectful learning communities.
Job Description Summary
The Senior Business Intelligence (BI) Analyst, Data Warehouse, and Application Administrator is responsible for the design, development, implementation, and 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 data architects 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.
Minimum Qualifications
Preferred Qualifications
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
Number of Vacancies
1
Physical Demands Summary
The physical demands primarily include prolonged sitting, frequent use of hands for typing and mouse work, and extended screen time, which may cause eye strain. Occasional light lifting (e.g., files or office supplies) and minimal movement are typical. Proper posture and periodic breaks are essential to mitigate discomfort or strain associated with these tasks.
Do the essential functions of this job require lifting?
Yes
If yes, list maximum weight and duration
20
Describe work environment
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be available to enable individuals with disabilities to perform.
Duties
Specific Duties
Data Warehouse Administration (ODS):
Percentage Of Time
25%
Specific Duties
BI Application Administration (IBM Cognos and Microsoft Power BI):
Percentage Of Time
20%
Specific Duties
Business Intelligence and Reporting:
Percentage Of Time
20%
Specific Duties
Project Management and Collaboration:
Percentage Of Time
15%
Specific Duties
Performance Monitoring and Optimization:
Percentage Of Time
15%
Specific Duties
Performs other special projects and assignments as requested.
Percentage Of Time
5%
Salary Range
Minimum:
$96,800.00
Maximum:
$97,057
Posting Detail Information
Posting Number
2024-251046SA
Special Instructions to Applicants
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.
Open Date
11/15/2024
Close Date
Open Until Filled
No
Position Information
Functional Title
Senior Business Intelligence (BI) Data Warehouse and Application Administrator
Position Type
Administrative/Professional
Appointment Type
Regular
FTE %
100%
Work Schedule (if atypical)
This position is onsite. Eligibility to apply for Hybrid/ remote status after 6 months of employment.
University Overview
Embark on an exciting journey with the University of La Verne, where your career aspirations come to life in a vibrant and welcoming environment. Established in 1891, our diverse and inclusive community is more than just a university-it's a home for passionate individuals like you.
At the University of La Verne, we embody four core values that set us apart-Ethical Reasoning, Diversity and Inclusivity, Lifelong Learning, and Civic and Community Engagement. If you're fueled by these principles and are eager to make a meaningful impact, your journey begins here.
With a rich history spanning 132 years, the University of La Verne boasts a global Leo Family of 89,000+ accomplished alumni. As the #1 private university in California for social mobility according to U.S. News and World Report 2024, and recently recognized as the 33rd Best U.S. College by the Wall Street Journal 2024, we take pride in our commitment to excellence in education.
Join us in shaping the future, where your passion meets purpose. Come be part of something extraordinary and apply today!
Diversity Statement
The University supports a diverse and inclusive environment where students recognize and benefit from the life experiences and viewpoints of other students, faculty, and staff. Diversity is an active and intentional practice that supports difference and multiplicity to expand knowledge, educate capable citizens, develop the whole person, and serve our local and global communities. Promoting and sustaining diversity is a commitment to educational quality and the creation of positive, respectful learning communities.
Job Description Summary
The Senior Business Intelligence (BI) Analyst, Data Warehouse, and Application Administrator is responsible for the design, development, implementation, and 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 data architects 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.
Minimum Qualifications
- 8 years of Experience with the following Technical Knowledge:
- Strong understanding of data warehousing concepts, including star schemas, snowflake schemas, and ODS architecture.
- Proficiency in data integration tools and ETL 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.
- 3 year of experience with Project Management:
- 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.
- 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.
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 .
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
Number of Vacancies
1
Physical Demands Summary
The physical demands primarily include prolonged sitting, frequent use of hands for typing and mouse work, and extended screen time, which may cause eye strain. Occasional light lifting (e.g., files or office supplies) and minimal movement are typical. Proper posture and periodic breaks are essential to mitigate discomfort or strain associated with these tasks.
Do the essential functions of this job require lifting?
Yes
If yes, list maximum weight and duration
20
Describe work environment
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be available to enable individuals with disabilities to perform.
Duties
Specific Duties
Data Warehouse Administration (ODS):
- Oversee the design, development, and maintenance of the operational data store (ODS).
- Manage data integration, ETL (Extract, Transform, Load) processes, and ensure data quality and consistency.
- Optimize data warehouse performance, manage storage, and monitor daily operations to ensure availability.
- Implement and maintain data governance policies and procedures to ensure data integrity and security.
- Collaborate with data architects to define and implement data models that support business reporting needs.
Percentage Of Time
25%
Specific Duties
BI Application Administration (IBM Cognos and Microsoft Power BI):
- Install, configure, and maintain IBM Cognos and Microsoft Power BI environments, ensuring that they are available and perform efficiently.
- Manage user access, security roles, and permissions in both Cognos and Power BI platforms.
- Develop and maintain reports, dashboards, and visualizations that meet business requirements.
- Troubleshoot and resolve issues related to Cognos and Power BI, working with vendors if necessary for support.
- Stay up to date with product updates, patches, and new features, and ensure their smooth implementation.
Percentage Of Time
20%
Specific Duties
Business Intelligence and Reporting:
- Collaborate with business users to gather requirements and translate them into BI solutions.
- Develop and maintain key performance indicators (KPIs) and other metrics to drive business decision-making.
- Provide training and support to end-users on Cognos and Power BI, ensuring they can utilize the tools effectively.
- Perform data analysis and provide actionable insights to support strategic business initiatives.
Percentage Of Time
20%
Specific Duties
Project Management and Collaboration:
- Lead or participate in BI-related projects, ensuring timely and accurate delivery of solutions.
- Work closely with cross-functional teams including IT, finance, operations, and marketing to align BI strategies with business goals.
- Document BI processes, standards, and best practices to facilitate knowledge sharing and ensure consistency across projects.
Percentage Of Time
15%
Specific Duties
Performance Monitoring and Optimization:
- Monitor the performance of BI applications and the ODS, identifying areas for improvement and optimization.
- Implement performance tuning measures for queries, reports, and dashboards to enhance speed and efficiency.
- Automate routine tasks and processes to improve efficiency and reduce manual intervention.
Percentage Of Time
15%
Specific Duties
Performs other special projects and assignments as requested.
Percentage Of Time
5%
Salary Range
Minimum:
$96,800.00
Maximum:
$97,057
Posting Detail Information
Posting Number
2024-251046SA
Special Instructions to Applicants
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.
Open Date
11/15/2024
Close Date
Open Until Filled
No