Senior Data Management Specialist
Job Location:
Olympia, WA - USA
Yearly Salary:
Posted:
Application Deadline:
Vacancies:
Job Summary
- Position Profile
The Senior Data Management Specialist is responsible for leading and overseeing the analysis collection sorting and creation of electronic data for the integration of applications software systems and associated workflow processes into the information systems serving the needs of the Washington State courts. This position provides senior-level expertise to all data management functions.
Washington Courts Employment Opportunity
Administrative Office of the Courts
Senior Data Management Specialist
Information Services Division
Our Mission: To advance the timely effective and equitable operations of the Washington State judicial branch.
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 #:2026-51
Status:Regular Full-Time
Location: Olympia Washington
Salary:Range 72: $93804 - $123084 per year (DOQ).
Opens: June 9 2026
Closes: June 23 2026. 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 2 days per week working onsite at AOC facilities
- Duties and Responsibilities
- Leads the technical team on strategic data loading synchronization and data quality processing projects to meet organizational business objectives.
- Develops overall strategies to guide the design of Extract/Transform/Load (ETL) processes to support internal enterprise applications and designs constructs tests optimizes and deploys these processes.
- Provides directions to more junior data management specialists on all Software Development Life Cycle (SDLC) phases related to the definition design development and implementation of new subject areas for enterprise application databases.
- Creates highly complex ETL workflows from data sources to data stores.
- Develops ETL processes using various tools in the most complex portions of the agencys data environment.
- Develops optimized stored procedures functions and database views.
- Ensures all data flow diagrams created and maintained for all ETL processes adhere to established standards and practices.
- Creates and maintains detailed source-to-target ETL mapping specifications.
- Leads efforts in defining database requirements analyzing existing models and reports looking for opportunities to improve their efficiency and resolving technical problems.
- Translates highly complex business requirements into application designs and solutions.
- Proficient in utilizing Microsoft 365 products including Teams Outlook Word OneNote PowerPoint and others with expertise appropriate to the responsibilities of the role.
- Develop ETL audits and controls to ensure quality of data meets or exceeds defined standards and thresholds.
- Conducts reviews of other data management specialists work products.
- Communicates data problems and issues to key stakeholders including both technical and business end users.
- Responds to customer service requests and provides senior-level troubleshooting problem resolution and consulting.
- May perform lead duties for a workgroup. These duties may include resolving procedure or workflow conflicts providing input to the manager regarding managerial issues and informing the manager of needs issues and concerns.
- Performs other duties as assigned.
- Qualifications and Credentials
A combination of education and experience demonstrating a working knowledge of the duties responsibilities and competencies of the Senior Software Developer may substitute for the qualifications listed.
A Bachelors degree in Information Technology Computer Science OR closely allied field AND:
- Eight (8) years of experience in a complex information technology environment TO INCLUDE:
- Five (5) years of experience using modern ETL and data cleansing tools such as: Informatica PowerCenter Designer Informatica PowerCenter Workflow Manager Informatica PowerCenter Workflow Monitor Informatica PowerCenter Repository and/or SQL 2012 or higher programmable objects.
THE IDEAL APPLICANT WILL ALSO HAVE SOME OR ALL OF THE FOLLOWING EXPERIENCE EDUCATION KNOWLEDGE SKILLS AND ABILITIES
- Advanced knowledge of data modeling and database design at the conceptual logical and physical level.
- Experience in modern ETL and data quality tools while working in a environment of great technical complexity.
- Significant working experience using modern source control tools such as Azure DevOps.
- Capable of evaluating and making recommendations related to improving ETL and data cleaning components utilized in the enterprise application databases and overall information delivery solutions.
- Capable of translating the most complex business and functional requirements into detailed technical designs and the delivery of ETL processes according to specification participating with business analysts to gather requirements and producing technical specifications.
- Advanced skills in ETL methodologies and data manipulation requiring highly complex database coding.
- Expertise in the integration of data cleansing services into ETL processes to satisfy the needs of the business community.
- Ability to create workflows based on business specifications.
- In-depth knowledge of the SDLC sufficient to effectively lead code reviews with the development team as needed.
- Perform system regression and user acceptance testing using both manual and automated test processes with all assignments and work products being delivered.
- Ability to understand customer expectations and meet those expectations.
- Ability to identify analyze and resolve problems in a consultative manner bringing problems together with recommendations for solutions.
- Ability to understand the overall impact of the enterprise to independently manage high-risk high- profile initiatives impacting services.
- Eight (8) years of experience in a complex information technology environment TO INCLUDE:
- 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 or fax or via email to.
Candidates who are offered a job with AOC must possess work authorization that does not require sponsorship by the employer for a visa now or in the future.
AOC complies with the employment eligibility verification requirements of the federal government eligibility verification form I-9. The selected candidate must be able to provide proof of identify and eligibility to work in the United States consistent with the requirements for that form.
AOC does not use E-verify; therefore we are not eligible to extend STEM-Optional Practice Training (OPT). For information please visit
Persons legally authorized to work in the U.S. under federal law including Deferred Action for Childhood Arrivals recipients are eligible for employment unless prohibited by other state or federal law.
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 applicants suitability and competence to perform in the job.
Required Experience:
Senior IC
