University of Colorado Senior Business Intelligence Engineer in Denver, Colorado
Senior Business Intelligence Engineer
Senior Business Intelligence Engineer - 28725 University Staff
Who We Are:
System Administration, which also houses the Office of the President, is located in the uptown neighborhood of Denver with a few smaller offices located on the campuses. Many of our departments support the educational and research missions of the four University of Colorado campuses, but System Administration is not considered a campus. We provide diverse opportunities for professional development, innovation, and collaboration with talented staff and faculty. Learn more about CU System Administration (https://apptrkr.com/get_redirect.php?id=3831226&targetURL=https://www.cu.edu/cu-careers/cu-system) .
University Information Systems (UIS) provides technical services and enterprise applications to the University of Colorado's (CU) four campuses and the Office of the President. UIS is committed to excellence in customer service, technical expertise, and the development of enterprise applications responsible for supporting CU's students, faculty, human resources employees, finance employees, and others.
As part of the Data and Business Intelligence (BI) team, this position exists to support and enhance the university's reporting and analytics. The university currently maintains a Tableau and Cognos reporting system that is used to develop reporting options for business offices and campus users.
The Sr. Business Intelligence Engineer is a customer-centric position focused on collaborating with, advising and assisting campus report developers, providing BI trainings, developing reports for internal UIS customers, communicating the roll-out of enhancements, BI tool administration and end-user adoption and continued successes of the BI deliverables. This role provides ongoing end-user support and maintains a solid BI architecture tool and provides customer guidance on BI best practices as a member of a smaller Business Intelligence team.
This position reports to the Assistant Director of Data and Business Intelligence and is exempt from the State of Colorado Classified Staff System.
Where You Will Work:
This position has the ability to work remotely within the United States.
Diversity and Equity:
The University of Colorado System Administration Office is committed to recruiting and supporting a diverse workforce. The university strives to promote a culture of inclusiveness, respect, communication and understanding. We encourage applications from women, ethnic minorities, persons with disabilities, persons within the LGBTQ+ community and all veterans.
Duties & Responsibilities:
Duties and responsibilities of the position include, but are not limited to:
BI Systems and Tools Administration and Support
Provides front-line support of enterprise reporting and BI tools
Performs technical analysis and troubleshoots system problems
Utilizes best practices to assist with BI strategic vision and subsequent implementation of strategic initiatives
Collaborates with report developers, site admins, and department decision makers to encourage tool adoption and proper utilization
Facilitates classroom and Zoom BI tool training sessions and provides ongoing mentoring to end users throughout the CU System
Provides content for the Data and Business Intelligence team's web site, blog, and training efforts
Collaborates with campus developers to migrate all reports and dashboards through systems development life cycle (SDLC) environments, quality assurance (QA), and production
Partakes in specific campus functional unit meetings to review status of existing requests, capture upcoming needs, and facilitate any questions or concerns to resolution
Partners with middleware and infrastructure teams to maintain the BI tool administration and configuration
Enhances and maintains the BI tool architecture, Cognos Framework Manager
Continuously participates in educational and professional development activities, such as attending trainings and conferences and completing self-directed learning
Business Intelligence Analysis/Development and Testing
Provides guidance and oversight of analytical reporting and delivery of dashboards to campus and System customers
Collaborates with end users and developers to determine business requirements for reports, dashboards and ETL enhancements
Communicates requirements to ETL developers and assists end users with User Acceptance Testing (UAT) needs
Participates in the implementation of end-to-end BI solutions
Develops medium to complex analytical Cognos or Tableau reports and/or dashboards generation for the UIS department and/or other campus departments as needed
Utilizes best practices to review existing reports, recommend performance improvements, and advise on the best visual representation of analytics
Analyzes data to help campus customers identify new BI trends
Performs report and dashboard system and integration testing (SIT) for objects developed by the team
Conducts thorough data analysis efforts to provide guidance and input towards enhancements and report development design
Extract, Transform, and Load (ETL) Development and Testing (Optional)
Assesses and gathers requirements from a business and data warehouse architecture perspective
Analyzes data in order to create technical design and complete simple data modeling efforts
Extract data from complex disparate system data base sources for ETL job generation within IBM DataStage and automation
Performs both unit and system testing to ensure the code meets the functional and technical requirements
Participates in production support on-call weekly rotations
Updates documentation such as source to target mappings, technical specification, system test scorecards, deployment checklists and change management tickets
What We Offer:
Salary: The anticipated hiring range has been established at $84,000.
The salary of the finalist(s) selected for this role will be set based on a variety of factors, including but not limited to, internal equity, experience, education, specialty and training.
The above salary range (or hiring range) represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting.
Benefits: The University of Colorado offers an excellent benefits package including:
Medical: Multiple plan options
Dental: Multiple plan options
Additional Insurance: Disability, Life, Vision and Wellness
Retirement 401(a) Plan: Employer contributes 10% of your gross pay
Paid Time Off: Accruals over the year
Vacation Days: 22
Sick Days: 15
Holiday Days: 10
Tuition Benefit: System employees have the benefit on all campuses
ECO Pass: RTD Bus and light rail service
Additional Perks & Programs: Click here to access a few more Perks and Programs (https://apptrkr.com/get_redirect.php?id=3831226&targetURL=https://www.cu.edu/cu-careers/perks/cu-system)
Click here to access our Total Compensation Calculator (https://apptrkr.com/get_redirect.php?id=3831226&targetURL=https://www.cu.edu/node/153125) to see what your total rewards could be at CU. This position is a University Staff position.
Additional taxable fringe benefits may be available.
More information on benefits programs, including eligibility, is available at www.cu.edu/employee-services/ (https://apptrkr.com/get_redirect.php?id=3831226&targetURL=http://www.cu.edu/employee-services/) .
Please ensure your resume includes any and all relevant experience to be accurately assessed against these qualifications. You must meet all minimum requirements listed at the time of application to be considered for this role.
Bachelor's degree from an accredited institution of higher education, or equivalent professional experience (professional experience may be substituted for the degree on a year-for-year basis)
Three (3) years' business intelligence experience, which includes:
Professional experience developing reports using Cognos version 11 or newer, MicroStrategy, Tableau 2019.1 or newer, or other report tool to build complex, medium to complex robust reports, OLAP cubes and dashboards, along with administrator experience
Advanced SQL experience
Bachelor's degree from an accredited institution of higher education in information technology, computer science, computer engineering, information systems, or related IT field
Five (5) years' business intelligence experience, which may include:
Three (3) years of advance SQL experience, and/or
Three (3) years of professional experience working directly with customers advising them on requirements, providing guidance on analytical reporting methodologies, and best practices, and/or
One (1) year experience working with IBM DataStage, Kimball methodologies including star schema design, and accumulating and periodic snapshots, and SDLC best practices as they relate to data warehousing and BI
Professional experience developing reports using Cognos version 10 or newer, Tableau, MicroStrategy, or other report tools to build complex, robust reports, OLAP cubes and dashboards
Reporting experience in a higher education setting
Visual arts training or degree
Experience reporting on data warehouse data and/or exposure to star-schema design
Experience facilitating large BI tool training sessions
Technical Lead experience working with a development team responsible for the design, development and implementation and/or upgrades resulting in high quality and expedient performance
Working knowledge of database design and data modeling
Knowledge, Skills, and Abilities:
To be successful in this position, employees will need to know the following:
Knowledge of data warehouse concepts and best practices
Knowledge of SQL and Relations Database Management Systems
Knowledge of Kimball methodologies, including star schema design and accumulating and periodic snapshots
Knowledge of SDLC best practices as they relate to data warehousing and BI
Oral, written, and listening communication skills, including the ability to accurately interpret what others are communicating and convey messages, information, concepts, and details clearly
Analytical and problem-solving skills, including the ability to analyze data and trends in order to produce results
Strong performance tuning skills, Oracle, Tableau and Cognos skills.
Ability to work independently and in a team setting
Ability to work under pressure, manage multiple concurrent and competing tasks and responsibilities, and adapt to changing priorities while maintaining personal effectiveness
Ability to work effectively in a fast-paced environment
Ability to communicate technical solutions to technical and non-technical users
Ability to maintain a high level of service orientation, with the ability to be sensitive to the needs of users of all skill levels
Ability to visualize data, including statistical and informational graphics and plots
Ability to create strong effective relationships with stakeholders
Additional skills that are preferred but not required:
Knowledge of ETL architecture
Knowledge of database design and data modeling
Knowledge of IBM DataStage
Knowledge of Multi-Node Server Architecture both for Cognos Analytics and Tableau
The University of Colorado has a requirement for COVID-19 vaccinations and full completion of the attestation form within the first 30 days after hire date. Information regarding this requirement, and exemptions can be found at https://www.cu.edu/vaccine-requirement (https://apptrkr.com/get_redirect.php?id=3831226&targetURL=https://www.cu.edu/vaccine-requirement)
How to Apply:
For full consideration, please attach the following as separate documents to your application:
A cover letter identifying the job specific minimum qualifications you possess
A resume including any and all relevant experience to be accurately assessed against the qualifications listed in the posting.
Please ensure you check the "Job Specific Attachments" box next to each document on the "Required Documents" page of the application for the appropriate documents to be attached.
When to Apply:
For full consideration completed applications must be submitted by February 14, 2023. Reference checking is a standard step in our hiring process. You may be asked to provide contact information, including email addresses, for up to five references as part of the search process for this position. Please note: All application materials must be submitted through CU Careers; emailed materials will not be considered.
Background Check Statement:
The University of Colorado is committed to providing a safe and productive learning and living community. To achieve that goal, we conduct background investigations for all final applicants being considered for employment. Background investigations include a criminal history record check, and when appropriate, a financial and/or motor vehicle history. The Immigration Reform and Control Act requires that a verification of employment eligibility be documented for all new employees by the end of the third day of work. The University of Colorado is committed to diversity and equality in education and employment.
We are committed to an inclusive and barrier-free search process. We provide accommodations for applicants requesting accommodation through the search process such as alternative formats of this posting. Individuals with disabilities in need of accommodations throughout the search process should contact the ADA Coordinator at: firstname.lastname@example.org (https://apptrkr.com/get_redirect.php?id=3831226&targetURLemail@example.com) .
Application Materials Required: Resume/CV
Job Category : Information Technology
Primary Location : Denver Department: S0001 -- System Administration - 50119 - University InformationServices
Schedule : Full-time
Posting Date : Jan 24, 2023
Unposting Date : Ongoing Posting Contact Name: System HR Posting Contact Email: SystemHR@cu.edu Position (https://apptrkr.com/get_redirect.php?id=3831226&targetURL=Email: SystemHR@cu.edu Position) Number: 00749973
To apply, visit https://cu.taleo.net/careersection/2/jobdetail.ftl?job=28725&lang=en (https://apptrkr.com/3831226)
Copyright 2022 Jobelephant.com Inc. All rights reserved.
Posted by the FREE value-added recruitment advertising agency (https://www.jobelephant.com/)
University of Colorado
- University of Colorado Jobs