Senior Business Intelligence Specialist

Washington State

  • Olympia, WA
  • $93,804-123,084 per year
  • Permanent
  • Full-time
  • 1 month ago
DescriptionThe 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 OpportunityAdministrative Office of the CourtsSenior Business Intelligence SpecialistInformation Services DivisionOur 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 DETAILSJob #: 2025-42Status: Regular, Full-Time*Location: Olympia, WashingtonSalary: Range 72: $93,804 - $123,084 per year (DOQ).Opens: July 23, 2025Closes: 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 INFORMATIONAOC 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 facilitiesDuties
  • 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.
QualificationsA 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 InformationHOW TO APPLYFor more information about the position, , application submission requirements, supplemental questions, inquire about benefits, or to apply for the position:IMPORTANT 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) 705-5337, or fax (360) 586-4409, or via email to .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.

Washington State