Overview
Skills
Job Details
Only W2
Essential Technical Skills
- Responsible for analyzing, assessing, and documenting diverse data from its source through many complex transformations to all applications that consume the data to assist the Data Management and Support (DMS) Team with continuous improvement in its mission to the agency.
- Additionally the individual will identify the issues from the profiling, follow up with the business, document the business rules, and assist with the processes involved around continuous improvement of the quality of the data and other capabilities of the DMS Team.
- Strong skills to identify and resolve data issues and effectively apply the broad range of professional concepts, practices, and methods in moderately complex and diverse circumstances. Work is perform under moderate supervision of the Data Management and Support Team Lead with moderate latitude for the use of initiative and independent judgement.
Qualification Requirements
Education/Special Requirements:
Bachelor s degree in computer science, engineering, statistics, economics, finance, library science, or related business field.
Experience and Training
3 years of experience creating functional and technical documentation, business glossaries, and diagrams, that communicates the desired message to business and technical audiences.
3 years of experience working with enterprise grade databases - preferably SQL Server and Oracle.
3 years of experience developing and writing complex SQL scripts/queries preferably Oracle and SQL Server.
2 years of experience, within the last 5 years, developing data quality rules, thresholds, and standard metrics/quality-expectations for data elements that support critical business processes.
2 years of experience, within the last 5 years, with an enterprise grade data quality tool such as Alteryx Data Quality, SAS Data Quality, etc.
2 years of experience, within in the last 5 years, in the Data Quality field developing and implementing best practices and tools based on the business needs.
Leads and participates in discussions with cross-functional teams.
Preferred Qualifications
3 years of experience working with complex Excel functions, including but not limited to VLookUp, Macros, Pivot Tables, etc.
2 years of experience with the Microsoft SQL Server BI Stack (RDMS, SSIS, SSRS)
Experience or familiarity with Alteryx & Tableau.
Experience or familiarity with Benefits Administration, Pension Administration, and Payroll oriented data in the PeopleSoft HRMS package or similar package.