Skip to content

Business Intelligence Supervisor

Position Overview

The ctcLink Reporting team supports the data and analytics needs of the State Board and the thirty community and technical college districts in the state of Washington who are using the PeopleSoft ERP system, also known as ctcLink.  Reporting tools used by the team primarily include Application Designer, PS Query, Pivot Grid, nVision and BI Publisher.  The team is also responsible for creating and maintaining dashboards using Oracle Business Intelligence Applications (OBIA) and other dashboard tools such as Tableau. 

The Business Intelligence Supervisor supervises the ctcLink Reporting team and reports to the Director of Data Services.  This position is responsible for implementing the director’s reporting strategies and leading the team to accomplish these goals. 

In addition to supervising, the Business Intelligence Supervisor will design, develop, test and maintain PeopleSoft queries, reports and database views and will ensure the Query Development Life Cycle (QDLC) is followed by both internal and external query developers.

Developing and maintaining supporting documentation is also a requirement of this position.

Job #: 2019-12

Annual Salary: $89,018.40

Location: Olympia, WA

Opens: Tuesday, Apr. 23, 2019

Closes: Open until filled

Recruitment and screening of applications will be ongoing until the position is filled. However, to ensure full consideration, return completed materials by 5 p.m. on the closing date. Note: Agency hiring authorities reserve the right — and may exercise the option — to make a hiring decision prior to the conclusion of the recruitment process.

Expand All
  • Create and maintain PeopleSoft queries, reports and database views using Application Designer, BI Publisher, Pivot Grid, PS Query and nVision.
    • This task includes working closely with end users and functional analysts to obtain the requirements and determine  the appropriate reporting tool and approach.  Requests for  new or modified queries or reports are made through the SBCTC Service desk system. 
    • The development of complex database views using SQL script.
    • Once the appropriate reporting tool is selected, this position will develop and test the solution following pre-defined standards in the non-production environment.
    • This position will follow the reporting solution through migration into the production environment, update appropriate documentation and work with the original requester to resolve the ticket.
  • Implement the agency’s reporting strategy
    • Within the framework and vision established by the Director of Data Services, implement the reporting road map by assisting the agency and the college system to advance their transactional reporting capabilities.  This also includes implementing and advancing the business intelligence analytics capabilities of both internal and external staff.
    • Participate on a system-wide query and reporting governance committee representing the State Board.
  • Supervise the SBCTC ctcLink Reporting team.
    • Supervising the reporting team includes approving/disapproving and tracking leave requests, monitoring the successful and timely completion of tasks and supporting the team with advanced or challenging requests.
    • The position also monitors the service desk requests assigned to the ctcLink Reporting team.
    • This position implements corrective action when needed.
  • Develops and maintains documentation
    • This task includes maintaining on boarding and off boarding documentation as well as step by step instructions for recurring technical tasks such as monitoring reports that cite differences between PeopleSoft database instances and may impact reporting objects.

Decision Making Authority

This position regularly applies their expertise and independent judgment to determine the appropriate implementation of reporting tools and the accuracy of the data produced.  This includes prioritizing their own tasks as well as those of the team.

This position requires next-level supervisory approval for software purchases and training for self or team. 

  • A Bachelor’s degree or higher in computer science or related field and two years progressive technical experience

          Or

A minimum of six years of progressive technical experience in Information Technology within data management or reporting object development

  • Advanced knowledge of relational databases
  • Advanced knowledge of Oracle reporting tools such as Oracle Application Designer, PS Query, BI Publisher and/or Pivot Grid
  • Advanced SQL Scripting ability
  • Ability to develop strong working relationships, understand core needs of the customer and define requirements appropriately
  • Ability to create effective solutions to problems
  • Ability to adapt easily to changing priorities in business needs, conditions and work responsibilities
  • Ability to make independent decisions about work priorities and perform multiple tasks with conflicting timelines
  • Ability to prepare technical documentation
  • Excellent written and oral communication skills

Desired Qualifications

  • Knowledge of Oracle 11g or 12c databases
  • One or more years’ experience leading a team of business intelligence developers
  • Working knowledge of data governance models and best practices

This is a full-time, exempt position. The annual compensation for this position is listed above. Washington state has a generous benefit package including health, dental, life insurance, long-term disability, retirement, and two optional deferred compensation programs. For more information, see Employee Benefits.

This position reports to the Director of Data Services.

Interested candidates may apply by submitting the following items:

  • Letter of formal application that addresses your interest in the position and ability to perform the responsibilities described in this announcement.
  • Detailed résumé of all educational and professional experience that demonstrates how you meet the qualifications.
  • List of at least three professional references with contact information. References are typically contacted after interviews.

Send application materials

Email is preferred, but you may send application materials by one of the following delivery methods:

Application tips

  • Make sure you clearly indicate the position you are applying for in your letter of interest and within your email and/or subject line – suggested subject line format:  Last name, First name –  Position Title or Recruitment #.
  • Include your name, address, current phone number, and email on the first page of each document you submit. 

Contact

Adrian Hill
Human Resource Consultant 3
employment@sbctc.edu
360-704-4305

 

Submitted applications are the property of SBCTC and will not be returned.

Applicants must be currently authorized to work in the United States for any employer.

The Washington State Board for Community and Technical Colleges (SBCTC) supports Executive Order 13-01 Veterans Transition Support and is an equal opportunity employer. SBCTC complies with the Americans with Disabilities Act.

Applicants who need accommodation in the application process or this announcement in an alternative format, may contact the Human Resources Office at 360-704-4301. A TDD relay service is available by dialing 800-833-6388 or voice 800-833-6384.

Employee Benefits

Your paycheck is just part of your total compensation. As an exempt employee, you will also have access to an outstanding employee benefits package worth about 30 percent of your salary.

Life in Olympia

Find out more about living and working in Olympia.

Experience Washington

Discover the benefits and recreational opportunities available to you throughout Washington state.

More Information

Contact the Human Resource Office at 360-704-4301 or visit the HR web page.

Page Manager: shagreen@sbctc.edu
Last Modified: 5/6/19 11:19 AM

starburst graphic