Data Warehouse Analyst
Listed on 2026-08-15
-
IT/Tech
Data Analyst, Data Engineering, Database Administrator, Data Warehousing
Client Name Wisconsin Department of Children & Families (DCF)
Requisition 164337
Location Madison, WI
Duration 3+ months (This is a limited engagement expected to end 12/31/2026 but could be extended)
Due Date 08/17/2026
C2C Possible No. Rate depends on experience
Interview Method Web-based with Camera On
WI residency required. Must be WI resident or willing to relocate prior to start date at own expense.
Description:Our client seeks a Data Warehouse Analyst. This position will be responsible for the assessment of data quality and metadata within client's data architecture. They will be responsible for the data profiling, analysis and documentation of data quality.
Tasks:
- 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.
Knowledge, Skills and Abilities Required:
Excellent organization, analytical, and communication skills
Skills Required5 years Metadata discovery and documentation experience
5+ years Data Profiling experience
3 years Advanced Python experience
5 years Data quality assessment and identification experience
5 years Creating and reviewing SQL scripting experience
5+ years' Experience with database design concepts
5 years' Knowledge of Oracle PL/SQL
5 years Metadata tools experience
5 years' Experience with Oracle 11g/DB2/SQL Server
4 years' Experience with Oracle data dictionary views
Experience with Human Services business intelligence
#J-18808-Ljbffr(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).