Administrative Office of the Courts, WA
Senior Business Intelligence Specialist
Administrative Office of the Courts, WA, Olympia, Washington, United States, 98502
Salary :
$93,804.00 - $123,084.00 Annually Location :
Olympia, WA Job Type:
.REGULAR: Full-Time Job Number:
2025-42 Division:
Information Services Division Department:
Enterprise Data Services (I3) Opening Date:
07/23/2025 Closing Date:
Continuous
Position Profile The Senior Business Intelligence Specialist is responsible for the design, development, testing and deployment of data warehouse and reporting solutions for the acquisition, storage and retrieval of data. The position will create reports using ad hoc reporting and/or dashboard creation tools to meet agency and customer needs. This position provides Senior level expertise to the Reporting Function. Washington Courts Employment Opportunity
Administrative Office of the Courts Senior Business Intelligence Specialist
Information Services Division Our Mission : Advance the efficient and effective operation of the Washington Judicial System. The Administrative Office of the Courts (AOC) is looking for top-performing employees who embody its core values integrity, inclusion, accountability, and teamwork. It is committed to both employee growth and work-life balance. Our diversity and inclusion efforts include embracing different cultures, backgrounds, and perspectives while fostering growth and advancement in the workplace. POSITION DETAILS Job #:
2025-42
Status:
Regular, Full-Time*
Location:
Olympia, Washington
Salary:
Range 72: $93,804 - $123,084 per year (DOQ).
Opens:
July 23, 2025
Closes:
Open until filled
AOC reserves the right to close the recruitment at any time but no sooner than seven calendar days after posting. WASHINGTON STATE RESIDENCY AND TELEWORK INFORMATION AOC requires employees to reside in Washington State. Any exceptions must be approved. If you are invited to interview and currently reside outside of Washington State, seek more information about residency requirements from the AOC hiring manager of this recruitment. This position requires at least 1 day per week working onsite at AOC facilities
Duties and Responsibilities
Perform data analysis on large volumes of data using data stories, data patterns, or other data engineering tools to ensure data reported represents expected business practices. Perform analysis of documented business requirements to validate the scope. Provide insights for the development efforts pertaining to various business requirements. Liaise with technical and business groups, communicating effectively between the two entities. Analyze documentation and technical specifications of any new application or data source under development or consideration to determine its intended functionality. Create and maintain detailed test plans, test conditions, test criteria, test cases, test scripts, test cycles, test data, and issues logs. Peer review and provide feedback for other team members' work products. Provide and/or participate in solution design. Perform software administration of SAP Business Objects and/or other dashboarding tools. Perform user security configuration in SAP Business Objects and/or other dashboarding tools. Unit test code using manual and automated test processes. Regression tests the application and reporting solutions when defects have been corrected and resubmitted. Develop in-depth understanding of underlying data, data model, and court business domains to ensure reports meet expectations. Ability to model data using tools like Business Object Information Design Tool or Tableau Prep. Gathers report requirements and analyzes, develops and maintains operational, statistical, and management reports for a variety of stakeholders. Addresses problem tickets to resolve issues within mission critical systems as assigned. Work collaboratively to enhance or improve business processes via integration, or as necessary, minimize the impact of integration on those processes. Development and testing of reports using Tableau Prep, Business Intelligence tools, Extract, Transform, and Load solutions, and/or SQL queries. Evaluate results of integration efforts, then report and make recommendations based on findings. Coordinate and perform in-depth tests, including end-user reviews, for modified and new systems. Communicate data problems and issues to key stakeholders, including both technical and business end users. Qualifications and Credentials A combination of education and experience demonstrating a working knowledge of the duties, responsibilities and competencies of the Business Intelligence Specialist may substitute for the qualifications listed. A Bachelor's degree in Information Technology, Computer Science, OR closely allied field,
AND:
Eight (8) years of experience in a complex information technology environment. THE IDEAL APPLICANT WILL ALSO HAVE SOME OR ALL OF THE FOLLOWING EXPERIENCE, EDUCATION, KNOWLEDGE, SKILLS, AND ABILITIES
SQL Programming Language knowledge and ability to generate queries and reports. Technical and business requirements analysis. Ability to work in a fast-paced and changing environment. Hands-on troubleshooting skill. Ability to create automated test scripts. Knowledge of SQL 2012 or higher, including programmable objects such as stored procedures. Knowledge of SAP Business Objects or other ad hoc reporting tools and/or knowledge of dashboarding tools such as Tableau and Power BI. Practical application knowledge with the reporting tools to demonstrate appropriate development, testing, and maintenance of business and data layer objects, queries and reports of high complexity. Interpreting complex instructional manuals, guidelines, and procedures. Skills in analytical thinking, problem solving, troubleshooting, resolving conflicts and bringing others to consensus. Specialized knowledge in software development methodologies, design, and implementation. Proven analytical and quantitative skills and an ability to use metrics to back up assumptions, develop business cases, and complete root cause analysis. Familiarity with data analysis, verification of data, and data science principals. Proficient in utilizing Microsoft 365 products, including Teams, Outlook, Word, OneNote, PowerPoint, and others, with expertise appropriate to the responsibilities of the role. Familiarity with Windows Active Directory set up for users. Strong customer service orientation and focus. Proven analytical and problem-solving abilities. Strong leadership skills. Ability to effectively prioritize and execute tasks in a high-pressure environment. Good written, oral, and interpersonal communication skills. Ability to conduct research into data, software, and reporting solutions as required by the business. Ability to present ideas in a business-friendly and user-friendly language. Highly self-motivated and directed. Keen attention to detail. Team-oriented and skilled in working within a collaborative environment. Supplemental Information
The workweek may fluctuate depending on workload or agency needs. Overnight travel may be required based on business needs. This position
is not
overtime eligible. The AOC is an equal opportunity employer and does not discriminate based on gender, pregnancy, race, color, national origin, ancestry, religion, creed, physical, mental or sensory disability (actual or perceived), use of a service animal, marital status, sexual orientation, gender identity or expression, veteran or military status, age, HIV or Hepatitis C status, or any other basis protected by federal or state law. Persons of disability needing assistance in the application process, or those needing this announcement in an alternative format, please contact the AOC Human Resource Office, at (360) 704-4143 or fax (360) 586-4409, or via email to Recruitment@courts.wa.gov. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and complete the required employment eligibility verification form upon hire. SPECIAL NOTE
:
Before a new hire, a background check, including criminal history, will be conducted. Information from the background check will not necessarily preclude employment but will be considered in determining the applicant's suitability and competence to perform in the job. We are a team-oriented culture, and a balance of family and work-life in a wonderful community. We offer a family-friendly package of pay, benefits, paid time off, and workplace opportunities to help you get the most out of your career and life.
Our compensation plan includes:
Health, Dental, and Vision Plans Retirement Plan Options Deferred Compensation Plan Paid Time Off (Vacation, Sick Leave and Holidays) Paid Basic Life Insurance Policy and Long Term Disability Insurance Employee Assistance Program Flexible Spending Account and Dependent Care Assistance Program Public Service Loan Forgiveness
Part-time employees will receive benefits on a pro-rated basis.
To learn more details about all we have to offer, visit the benefits page at 01
Do you have a Bachelor's degree in Information Technology, Computer Science, OR closely allied field?
Yes No
02
Do you have at least eight (8) years of experience in a complex information technology environment?
Yes No
Required Question
$93,804.00 - $123,084.00 Annually Location :
Olympia, WA Job Type:
.REGULAR: Full-Time Job Number:
2025-42 Division:
Information Services Division Department:
Enterprise Data Services (I3) Opening Date:
07/23/2025 Closing Date:
Continuous
Position Profile The Senior Business Intelligence Specialist is responsible for the design, development, testing and deployment of data warehouse and reporting solutions for the acquisition, storage and retrieval of data. The position will create reports using ad hoc reporting and/or dashboard creation tools to meet agency and customer needs. This position provides Senior level expertise to the Reporting Function. Washington Courts Employment Opportunity
Administrative Office of the Courts Senior Business Intelligence Specialist
Information Services Division Our Mission : Advance the efficient and effective operation of the Washington Judicial System. The Administrative Office of the Courts (AOC) is looking for top-performing employees who embody its core values integrity, inclusion, accountability, and teamwork. It is committed to both employee growth and work-life balance. Our diversity and inclusion efforts include embracing different cultures, backgrounds, and perspectives while fostering growth and advancement in the workplace. POSITION DETAILS Job #:
2025-42
Status:
Regular, Full-Time*
Location:
Olympia, Washington
Salary:
Range 72: $93,804 - $123,084 per year (DOQ).
Opens:
July 23, 2025
Closes:
Open until filled
AOC reserves the right to close the recruitment at any time but no sooner than seven calendar days after posting. WASHINGTON STATE RESIDENCY AND TELEWORK INFORMATION AOC requires employees to reside in Washington State. Any exceptions must be approved. If you are invited to interview and currently reside outside of Washington State, seek more information about residency requirements from the AOC hiring manager of this recruitment. This position requires at least 1 day per week working onsite at AOC facilities
Duties and Responsibilities
Perform data analysis on large volumes of data using data stories, data patterns, or other data engineering tools to ensure data reported represents expected business practices. Perform analysis of documented business requirements to validate the scope. Provide insights for the development efforts pertaining to various business requirements. Liaise with technical and business groups, communicating effectively between the two entities. Analyze documentation and technical specifications of any new application or data source under development or consideration to determine its intended functionality. Create and maintain detailed test plans, test conditions, test criteria, test cases, test scripts, test cycles, test data, and issues logs. Peer review and provide feedback for other team members' work products. Provide and/or participate in solution design. Perform software administration of SAP Business Objects and/or other dashboarding tools. Perform user security configuration in SAP Business Objects and/or other dashboarding tools. Unit test code using manual and automated test processes. Regression tests the application and reporting solutions when defects have been corrected and resubmitted. Develop in-depth understanding of underlying data, data model, and court business domains to ensure reports meet expectations. Ability to model data using tools like Business Object Information Design Tool or Tableau Prep. Gathers report requirements and analyzes, develops and maintains operational, statistical, and management reports for a variety of stakeholders. Addresses problem tickets to resolve issues within mission critical systems as assigned. Work collaboratively to enhance or improve business processes via integration, or as necessary, minimize the impact of integration on those processes. Development and testing of reports using Tableau Prep, Business Intelligence tools, Extract, Transform, and Load solutions, and/or SQL queries. Evaluate results of integration efforts, then report and make recommendations based on findings. Coordinate and perform in-depth tests, including end-user reviews, for modified and new systems. Communicate data problems and issues to key stakeholders, including both technical and business end users. Qualifications and Credentials A combination of education and experience demonstrating a working knowledge of the duties, responsibilities and competencies of the Business Intelligence Specialist may substitute for the qualifications listed. A Bachelor's degree in Information Technology, Computer Science, OR closely allied field,
AND:
Eight (8) years of experience in a complex information technology environment. THE IDEAL APPLICANT WILL ALSO HAVE SOME OR ALL OF THE FOLLOWING EXPERIENCE, EDUCATION, KNOWLEDGE, SKILLS, AND ABILITIES
SQL Programming Language knowledge and ability to generate queries and reports. Technical and business requirements analysis. Ability to work in a fast-paced and changing environment. Hands-on troubleshooting skill. Ability to create automated test scripts. Knowledge of SQL 2012 or higher, including programmable objects such as stored procedures. Knowledge of SAP Business Objects or other ad hoc reporting tools and/or knowledge of dashboarding tools such as Tableau and Power BI. Practical application knowledge with the reporting tools to demonstrate appropriate development, testing, and maintenance of business and data layer objects, queries and reports of high complexity. Interpreting complex instructional manuals, guidelines, and procedures. Skills in analytical thinking, problem solving, troubleshooting, resolving conflicts and bringing others to consensus. Specialized knowledge in software development methodologies, design, and implementation. Proven analytical and quantitative skills and an ability to use metrics to back up assumptions, develop business cases, and complete root cause analysis. Familiarity with data analysis, verification of data, and data science principals. Proficient in utilizing Microsoft 365 products, including Teams, Outlook, Word, OneNote, PowerPoint, and others, with expertise appropriate to the responsibilities of the role. Familiarity with Windows Active Directory set up for users. Strong customer service orientation and focus. Proven analytical and problem-solving abilities. Strong leadership skills. Ability to effectively prioritize and execute tasks in a high-pressure environment. Good written, oral, and interpersonal communication skills. Ability to conduct research into data, software, and reporting solutions as required by the business. Ability to present ideas in a business-friendly and user-friendly language. Highly self-motivated and directed. Keen attention to detail. Team-oriented and skilled in working within a collaborative environment. Supplemental Information
The workweek may fluctuate depending on workload or agency needs. Overnight travel may be required based on business needs. This position
is not
overtime eligible. The AOC is an equal opportunity employer and does not discriminate based on gender, pregnancy, race, color, national origin, ancestry, religion, creed, physical, mental or sensory disability (actual or perceived), use of a service animal, marital status, sexual orientation, gender identity or expression, veteran or military status, age, HIV or Hepatitis C status, or any other basis protected by federal or state law. Persons of disability needing assistance in the application process, or those needing this announcement in an alternative format, please contact the AOC Human Resource Office, at (360) 704-4143 or fax (360) 586-4409, or via email to Recruitment@courts.wa.gov. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and complete the required employment eligibility verification form upon hire. SPECIAL NOTE
:
Before a new hire, a background check, including criminal history, will be conducted. Information from the background check will not necessarily preclude employment but will be considered in determining the applicant's suitability and competence to perform in the job. We are a team-oriented culture, and a balance of family and work-life in a wonderful community. We offer a family-friendly package of pay, benefits, paid time off, and workplace opportunities to help you get the most out of your career and life.
Our compensation plan includes:
Health, Dental, and Vision Plans Retirement Plan Options Deferred Compensation Plan Paid Time Off (Vacation, Sick Leave and Holidays) Paid Basic Life Insurance Policy and Long Term Disability Insurance Employee Assistance Program Flexible Spending Account and Dependent Care Assistance Program Public Service Loan Forgiveness
Part-time employees will receive benefits on a pro-rated basis.
To learn more details about all we have to offer, visit the benefits page at 01
Do you have a Bachelor's degree in Information Technology, Computer Science, OR closely allied field?
Yes No
02
Do you have at least eight (8) years of experience in a complex information technology environment?
Yes No
Required Question