BI Analyst/Developer

Job description

Description
Position SummaryUniversity Information Services (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.

The Business Intelligence (BI) Analyst/Developer is a member of the Data and Business Intelligence team, which exists to support and enhance the University's reporting and analytics capabilities. CU currently maintains a Cognos and Tableau reporting system that is used to develop reporting options for business offices and campus users. The BI Analyst/Developer is a customer-centric position focused on administering and maintaining a solid BI architecture tool and providing customer guidance on BI best practices and ongoing end-user support. This position collaborates with and advises report developers, communicates enhancement roll outs, promotes end-user adoption, and ensures the continued successes of BI deliverables.

This position reports to the Assistant Director of Data and Business Intelligence and is exempt from the State of Colorado Classified Staff System.

Duties and ResponsibilitiesDuties and responsibilities of the position include, but are not limited to: 

BI Systems and Tools Administration and Support

  • Provides primary support for Tableau Server administration for the university, responsible for determining architecture required, troubleshooting issues, and driving resolutions and supporting stakeholder Tableau needs
  • Experience in Tableau Server administration, including:
    • Configuration, maintenance, and upgrades
    • Familiarity with application programming interfaces (APIs), branding options, and auditing
    • Automating tasks such as deployment of data sources/workbooks
    • Knowledge of Tableau Server best practices for scalability and performance
  • 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 and department decision makers to encourage tool adoption
  • 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
  • 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 complex analytical Cognos and 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 systems testing for objects developed by the team
  • Conducts thorough data analysis efforts to provide guidance and input towards enhancements and report development design
 

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.  However, this position is located in this position has the ability to work remotely.  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.

The University of Colorado has been proactive in response to the COVID-19 pandemic. You can visit our COVID-19 webpage for more information.

What we offer:

The budgeted salary for this position has been firmly established at $85,000.

The salary range for this position has been established at $78,447 - $96,784.

The salary of the finalist 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 budgeted 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.

More information on benefits programs, including eligibility, is available at www.cu.edu/employee-services/.

Knowledge, Skills, and Abilities To be successful in this position, candidates will need the following:

  • Knowledge of Tableau and Tableau administration concepts and best practices
  • Knowledge of structured query language (SQL) and Relational Database Management Systems
  • 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 saying 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 in Tableau
  • 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


Qualifications
Minimum Requirements
  • 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 with Tableau, which includes:
    • Tableau Server Administration
    • Developing reports and dashboards
    • Using SQL
    • Advising customers on analytical reporting methodologies, requirements, and best practices
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 as indicated above, which may also include one or more of the following:
    • Three (3) years of advance Tableau Server experience
    • Three (3) years of professional experience working directly with customers advising them on requirements, providing guidance on analytical reporting methodologies, and best practices
    • Professional experience developing reports using Tableau, Cognos version 10 or newer, MicroStrategy, or other report tools to build complex, robust reports, OLAP cubes and dashboards
  • Reporting experience in a higher education setting
  • Experience utilizing Tableau Server Management and Tableau Prep
  • Experience reporting on data warehouse data and/or exposure to star-schema design
  • Experience facilitating large BI tool training sessions


Job Category: Information Technology
Primary Location: Denver
Schedule: Full-time
Posting Date: Feb 23, 2021
Unposting Date: Ongoing

 

 

 

Diversity Profile: University

 

AAUP COMPENSATION SURVEY DATA

View more

Learn more on Inside Higher Ed's College Page for University

Arrow pointing right
Job No:
Posted: 2/24/2021
Application Due: 4/25/2021
Work Type: Full Time
Salary: