What are the responsibilities and job description for the Data Management Specialist position at State of Washington?
JOB
The Data Management Specialist is responsible to analyze, collect, sort, and create 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 journey-level expertise to all data management functions. Reporting to an Information Technology Manager, Information Technology Supervisor, or equivalent, this is a journey-level position that works within a team to oversee the process of moving data between systems for reporting purposes. This position provides data management services using products such as, but not limited to, Informatica Power Center, SQL, and Azure DevOps. This position has limited decision-making responsibility as defined by managerial level staff. Able to complete routine tasks independently using established data management principles. Work products are subject to review and approval by senior data management specialists, supervisors, or managers. Washington Courts Employment OpportunityAdministrative Office of the Courts Data Management SpecialistInformation 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 DETAILSJob #: 2024-106Status: Regular, Full-TimeLocation: Olympia, WashingtonSalary: Range 68: $82,512 - $108,252 per year (DOQ). Opens: December 19, 2024Closes: January 9, 2025. AOC reserves the right to close the recruitment at any time. 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 1 day per week working onsite at AOC facilities
EXAMPLE OF DUTIES
Serves as technical resource on strategic data loading, synchronization, and data quality processing projects to meet organizational business objectives. Designs, constructs, tests, optimizes, and deploys Extract/Transform/Load (ETL) processes to support internal enterprise applications.Conducts all Software Development Life Cycle (SDLC) phases related to the definition, design, development, and implementation of new subject areas for enterprise application databases.Creates ETL workflows from data sources to data stores.Develops ETL processes using various tools in a complex data environmentDevelops optimized SQL Server stored procedures, functions, and database views for use in applications, jobs, and ETL workflows.Creates and maintains data flow diagrams for existing and future ETL processes.Creates and maintains detailed source-to-target ETL mapping specifications.Participates in defining database requirements, analyzing existing models and reports looking for opportunities to improve their efficiency, and resolving technical problems.Translates business requirements into application designs and solutions.Conducts ETL audits and implements controls to ensure quality of data meets or exceeds defined standards and thresholds.Responds to customer service requests and provides journey-level troubleshooting, problem resolution and consulting. Conduct 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.Performs other duties as assigned.
SUPPLEMENTAL INFORMATION
HOW TO APPLY For more information about the position, to review the job description, application submission requirements, supplemental questions, inquire about benefits, or to apply for the position: CLICK HERE TO APPLY 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 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.
The Data Management Specialist is responsible to analyze, collect, sort, and create 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 journey-level expertise to all data management functions. Reporting to an Information Technology Manager, Information Technology Supervisor, or equivalent, this is a journey-level position that works within a team to oversee the process of moving data between systems for reporting purposes. This position provides data management services using products such as, but not limited to, Informatica Power Center, SQL, and Azure DevOps. This position has limited decision-making responsibility as defined by managerial level staff. Able to complete routine tasks independently using established data management principles. Work products are subject to review and approval by senior data management specialists, supervisors, or managers. Washington Courts Employment OpportunityAdministrative Office of the Courts Data Management SpecialistInformation 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 DETAILSJob #: 2024-106Status: Regular, Full-TimeLocation: Olympia, WashingtonSalary: Range 68: $82,512 - $108,252 per year (DOQ). Opens: December 19, 2024Closes: January 9, 2025. AOC reserves the right to close the recruitment at any time. 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 1 day per week working onsite at AOC facilities
EXAMPLE OF DUTIES
Serves as technical resource on strategic data loading, synchronization, and data quality processing projects to meet organizational business objectives. Designs, constructs, tests, optimizes, and deploys Extract/Transform/Load (ETL) processes to support internal enterprise applications.Conducts all Software Development Life Cycle (SDLC) phases related to the definition, design, development, and implementation of new subject areas for enterprise application databases.Creates ETL workflows from data sources to data stores.Develops ETL processes using various tools in a complex data environmentDevelops optimized SQL Server stored procedures, functions, and database views for use in applications, jobs, and ETL workflows.Creates and maintains data flow diagrams for existing and future ETL processes.Creates and maintains detailed source-to-target ETL mapping specifications.Participates in defining database requirements, analyzing existing models and reports looking for opportunities to improve their efficiency, and resolving technical problems.Translates business requirements into application designs and solutions.Conducts ETL audits and implements controls to ensure quality of data meets or exceeds defined standards and thresholds.Responds to customer service requests and provides journey-level troubleshooting, problem resolution and consulting. Conduct 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.Performs other duties as assigned.
SUPPLEMENTAL INFORMATION
HOW TO APPLY For more information about the position, to review the job description, application submission requirements, supplemental questions, inquire about benefits, or to apply for the position: CLICK HERE TO APPLY 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 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.
Salary : $82,512 - $108,252
