SQL Database Python Analyst

• Onsite, hybrid or remote: WI residency required. Must be WI resident or willing to relocate within 30 days of start date at own expense. 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.
• INTERVIEW NOTES: PLEASE NOTE: A real-time screenshot photo of the candidate MUST be uploaded to candidates bid upon confirming the interview. Please see “DCF Realtime Photo Requirement & Instructions” document in the Attachments section of this posting for details.
• Interviews will be set up shortly after the posting close date.
• MUST provide three (3) business references for the interview. (One reference must be a supervisory level.)
• Candidate will be required to provide their own equipment for this position (See job description for required specifications.)
• Interview process: via Zoom/Teams.
• Please be specific with all job duties required by the hired candidate., Project details: This position will be responsible for the assessment of data quality and metadata within DCF data architecture. They will be responsible for the data profiling, analysis and documentation of data quality. Experience with Human Services business intelligence is desirable.

List any special qualifications & years of experience: This position will be responsible for the assessment of data quality and metadata within DCF 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.
• This is a limited engagement expected to end 12/31/2026, but could be extended.

Experience with Human Services business intelligence is desirable.

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

List any special qualifications & years of experience:

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