- 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
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
- 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:
- Email: email@example.com
- Fax: 360-704-4415
- Mail: Adrian Hill
SBCTC Human Resource Office
PO Box 42495
Olympia, WA 98504-2495
- 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.
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.
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.
Discover the benefits and recreational opportunities available to you throughout Washington state.
Last Modified: 5/6/19 11:19 AM