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 performed under moderate supervision of the Data Management and Support Team Lead with moderate latitude for the use of initiative and independent judgement.

Responsibilities

• Expand and continuously refine the data quality program.
• Ensures adherence to the data quality programs and standards.
• Ensures that the data quality corrective action plan is thoroughly documented.
• Promote the importance and awareness of an enterprise data quality program.
• Leverages data management knowledge to define and maintain data quality, reference data, and meta-data processes.
• Participates in the development of data quality rules, thresholds, and standard/quality expectations for data elements that support critical business processes.
• Continuously execute and monitor the Data Quality Lifecycle on a daily basis.
• Profiles data for statistical analysis and assessment of data to document the effectiveness of data quality controls and identifies improvement opportunities.
• Identifies and implements best practices and tools based on the business needs.
• Implement controls to mitigate data quality risks including continuously monitoring data quality results, reports and dashboards.
• Impeccable oral and written communication skills are essential for effectively interacting with data users, managers, and other stakeholders.
• Complies with all applicable agency policies and procedures, including safety and standards of conduct.
• Performs other duties as assigned
• Communicates respectfully and works harmoniously with all co-workers, customers, and
• vendors.
• Provides exceptional customer service.
• Is flexible; able to work under pressure and; able to adapt to change; and able to work on multiple problems and tasks.
• Takes initiative to prevent and solve problems.

Qualifications

• 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)
• 2 years experience or familiarity with Alteryx & Tableau.
• Any years experience or familiarity with Benefits Administration, Pension Administration, and Payroll
• oriented data in the PeopleSoft HRMS package or similar package.