Senior Business Intelligence Engineer

Senior Business Intelligence Engineer - 28725 University Staff 

Description 
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.

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.

Position Summary:

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

Click here to access our Total Compensation Calculator 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/.

Qualifications:

Minimum Qualifications:

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

Preferred Qualifications:

• 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

COVID-19:

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

How to Apply:

For full consideration, please attach the following as separate documents to your application:

1. A cover letter identifying the job specific minimum qualifications you possess
2. 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.

ADA Statement:

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: systemhr@cu.edu.
         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 Number: 00749973

To apply, visit https://cu.taleo.net/careersection/2/jobdetail.ftl?job=28725&lang=en







Copyright ©2022 Jobelephant.com Inc. All rights reserved.

Posted by the FREE value-added recruitment advertising agency
jeid-414ef55d889946478d2bda8402de307d