P240326 - Business Intelligence Analyst - Business Reporting and Systems
Position Summary:
The Office of Business Reporting and Systems within Business Services is seeking a Business Intelligence (BI) Analyst who will be responsible for strategically designing the framework to organize the information management and technology components used to build Business Intelligence systems that meet the data access needs of the organization. In this role you will be responsible for:
- Developing an environment that allows business users to identify business issues, formulate business questions, determine what information is needed, determine where to find the information, retrieve, analyze, report and take action.
- Support the Business Intelligence application (Oracle Business Intelligence (OBI)
- Develop and coordinate data extract, translate and load (ETL) processes used to populate new and existing operational data stores and data warehouses, and develop new dashboards, reports and analyses for various customer groups across the campus.
- Champion data quality, integrity and reliability throughout the enterprise by designing and promoting best practices.
Outstanding Benefits Package
Working at UB comes with benefits that exceed salary alone. There are personal rewards including comprehensive health and retirement plan options. We also focus on creating and sustaining a healthy mix of work, personal and academic pursuit – all to support your work-life effectiveness. Visit our benefits website to learn about our benefit packages.
About The University at Buffalo
The University at Buffalo (UB) #ubuffalo is one of America’s leading public research universities and a flagship of the State University of New York system, recognized for our excellence and our impact. UB is a premier, research-intensive public university dedicated to academic excellence. Our research, creative activity and people positively impact the world. Like the city we call home, UB is distinguished by a culture of resilient optimism, resourceful thinking and pragmatic dreaming that enables us to reach others every day. Visit our website to learn more about the University at Buffalo.
Minimum Qualifications:
- Bachelor’s degree in a technical or science discipline, or other related field required.
- A minimum of two (2) years of experience working with Oracle SQL, Oracle database, and scripting languages such as PL/SQL.
- Thorough understanding of data warehousing concepts.
- Strong problem-solving and analytical skills.
- Ability to communicate effectively with technical and non-technical audiences.
Preferred Qualifications:
- Experience with business intelligence reporting tools, with Oracle Business Intelligence tools.
- Oracle OAS Data Visualization and Data Modeling.
- Experience with scripting languages R and Python.
- Understanding of Active Directory technology and managed group policies.
- Hands-on experience with UB InfoSource.
- Familiarity with UB business systems and related data, business rules, and processes.
FTE: 1.0
University at Buffalo is an affirmative action/equal opportunity employer and in keeping with our commitment, encourages women, minorities, persons with disabilities and veterans to apply.