Data Warehouse Analyst
🚨 HIRING | DATA WAREHOUSE ANALYST II 🚨📍 Madison, WI🏠 90–100% REMOTE within Wisconsin🏢 Occasional onsite as required💼 Contract: Through 12/31/2026 | Extension Possible💰 Rate: $45/hr W2 – Client🛂 Visa: Any Visa🎯 Experience: 5+ Years🇺🇸 US Candidates Only | Wisconsin Residency Required⚠️ All work must be performed within Wisconsin. Candidates outside Wisconsin must be willing to relocate within 30 days at their own expense. No work outside the US.🔥 ROLE OVERVIEWSeeking a Data Warehouse Analyst II with strong experience in data profiling, data quality, metadata, SQL, Python, database analysis, and reporting.The candidate will collaborate with Data Modelers and Data Architects to support data management, data quality, and data warehouse initiatives.🛠️ KEY RESPONSIBILITIES🔹 Perform data profiling & quality assessments🔹 Audit data for completeness, accuracy, duplicates, outliers & inconsistencies🔹 Develop validation rules, cleansing & remediation recommendations🔹 Define data quality KPIs and reporting dashboards🔹 Investigate recurring data, system & integration issues🔹 Discover and document metadata🔹 Analyze logical & physical database models🔹 Support data warehouse initiatives and data-load monitoring🔹 Investigate data-load failures and retrieval issues🔹 Perform relational database analysis and testing🔹 Collaborate with Data Modelers & Data Architects⭐ MUST-HAVE SKILLS✅ 5+ Years: Data Profiling & Data Quality✅ 5+ Years: SQL / SQL Scripting✅ 5+ Years: Oracle PL/SQL✅ 5+ Years: Metadata Tools & Documentation✅ 5+ Years: Database Design Concepts✅ 5+ Years: Oracle 11g / DB2 / SQL Server✅ 4+ Years: Oracle Data Dictionary Views✅ 3+ Years: Python✅ Strong analytical & communication skills⭐ Preferred: Human Services Business Intelligence experience📄 SUBMISSION REQUIREMENTS📌 Updated Resume📌 RFS📌 Driver’s License📌 Visa Copy🎯 LOCATION REQUIREMENTS🇺🇸 Currently in the US📍 Wisconsin resident OR willing to relocate within 30 days🏠 Available for 90–100% remote work within Wisconsin🏢 Available for occasional onsite work⚠️ No work outside the US