Overview
Skills
Job Details
Introduction:
The Employees Retirement System of Texas requests the services of a Data Analyst/ Report Writer 3.
Duties and Responsibilities / Essential Functions:
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
Qualification 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.