This position will be responsible for the assessment of data quality and metadata within the client data architecture. They will be responsible for the data profiling, analysis and documentation of data quality.

The individual in this position will:
Audit existing databases to assess data characteristics such as completeness, accuracy, outliers, and duplicates.
Investigate and define automated validation rules to guarantee data accuracy and catch errors at the point of entry.
Develop data cleansing and remediation recommendations for data irregularities.
Establish key performance indicators (KPIs) to measure data health, and build reporting dashboards to track quality metrics and trends.
Investigate the origins of recurring data errors (e.g., system bugs, user errors, integration issues) and recommend targeted, systemic solutions.
Document and define key metadata around database architecture.
Make recommendations on data maintenance and data quality.
Collaborate with Data Modelers and Data Architects on recommendations for key data management and data quality efforts.

Experience with Human Services business intelligence is desirable.

Latitude for independent judgment. Typically requires four to five years experience or equivalent education.

Provide support for data warehousing initiatives and monitor data warehousing system to ensure reliability and accuracy of information loaded into the databases. Analyze the logical and physical database models and ensure models are in accordance with standards. Generate and prepare reports to support business objectives. Perform analysis and testing of relational databases and investigate any data load failures or data retrieval issues. Career-Development position within field. Requires moderate skill sets and developing proficiency within discipline. Conducts tasks and assignments as directed.

Qualification - Experience
Data Profiling - 5+ years
Python - 3 years
Database design concepts - 5+ years
Excellent organization, analytical, and communication skills - 5 years
Creating and reviewing SQL scripting - 5 years
Knowledge of Oracle PL/SQL - 5 years
Metadata tools - 5 years
Oracle 11g/DB2/SQL Server - 5 years
Oracle data dictionary views - 4 years
Metadata documentation experience - 5 years
Data quality assessment and profiling - 5 years

Top skills:
Experience in metadata discovery and documentation (5+ years)
Experience in data profiling (5+ years)
Experience in data quality assessment and identification (5+ years)
Advanced experience in SQL and Python (3+ years)

Notes:
90-100% remote but can require staff to come onsite as necessary with sufficient notice. Onsite work is not likely, but candidate should be prepared to come onsite if required.
Candidate must be available to perform all work during the Central Standard Time (CST) business hours 9:00 am – 3 pm (or CST hours as defined by the hiring manager)