TeamSoft
Data Warehouse Analyst
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Warehouse Analyst, remote in Wisconsin, through 12/31/2026. Requires 5+ years in metadata discovery, data profiling, and quality assessment; 3+ years in SQL and Python. Occasional onsite work may be needed.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
August 13, 2026
🕒 - Duration
More than 6 months
-
🏝️ - Location
Remote
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Madison, WI
-
🧠 - Skills detailed
#Databases #Database Architecture #Data Cleansing #Data Management #Data Architecture #Metadata #Data Quality #Python #Documentation #Data Warehouse #Data Profiling #SQL (Structured Query Language) #Data Accuracy #"ETL (Extract #Transform #Load)"
Role description
Title: Data Warehouse Analyst
Location: Remote in Wisconsin — WI residency required
Work Arrangement: 90–100% Remote; occasional onsite work may be required
Duration: Through 12/31/2026, with possible extension
Top Required Skills
• Metadata discovery and documentation – 5+ years
• Data profiling – 5+ years
• Data quality assessment and identification – 5+ years
• Advanced SQL and Python – 3+ years
Key Responsibilities
The Data Warehouse Analyst II will:
• Audit existing databases to assess:
• Completeness
• Accuracy
• Outliers
• Duplicates
• Investigate and define automated validation rules to ensure data accuracy and identify errors at the point of entry.
• Develop data cleansing and remediation recommendations for data irregularities.
• Establish KPIs to measure data health.
• Build reporting dashboards to track data quality metrics and trends.
• Investigate recurring data errors, including:
• System bugs
• User errors
• Integration issues
• Recommend targeted and systemic solutions to recurring data issues.
• Document and define key metadata related to database architecture.
• Make recommendations regarding data maintenance and data quality.
• Collaborate with Data Modelers and Data Architects on data management and data quality initiatives.
• Support data warehousing initiatives.
• Monitor data warehouse systems to ensure reliability and accuracy of information loaded into databases.
• Analyze logical and physical database models and ensure they comply with applicable standards.
• Generate and prepare reports supporting business objectives.
• Perform analysis and testing of relational databases.
• Investigate data load failures and data retrieval issues
#INDTS
TeamSoft is an Equal Opportunity Employer. We do not discriminate on the basis of race, color, religion, sex (including pregnancy, sexual orientation, and gender identity), national origin, age, disability, genetic information, or any other protected status under federal, state, or local law. We are committed to fostering a diverse and inclusive workplace.
Title: Data Warehouse Analyst
Location: Remote in Wisconsin — WI residency required
Work Arrangement: 90–100% Remote; occasional onsite work may be required
Duration: Through 12/31/2026, with possible extension
Top Required Skills
• Metadata discovery and documentation – 5+ years
• Data profiling – 5+ years
• Data quality assessment and identification – 5+ years
• Advanced SQL and Python – 3+ years
Key Responsibilities
The Data Warehouse Analyst II will:
• Audit existing databases to assess:
• Completeness
• Accuracy
• Outliers
• Duplicates
• Investigate and define automated validation rules to ensure data accuracy and identify errors at the point of entry.
• Develop data cleansing and remediation recommendations for data irregularities.
• Establish KPIs to measure data health.
• Build reporting dashboards to track data quality metrics and trends.
• Investigate recurring data errors, including:
• System bugs
• User errors
• Integration issues
• Recommend targeted and systemic solutions to recurring data issues.
• Document and define key metadata related to database architecture.
• Make recommendations regarding data maintenance and data quality.
• Collaborate with Data Modelers and Data Architects on data management and data quality initiatives.
• Support data warehousing initiatives.
• Monitor data warehouse systems to ensure reliability and accuracy of information loaded into databases.
• Analyze logical and physical database models and ensure they comply with applicable standards.
• Generate and prepare reports supporting business objectives.
• Perform analysis and testing of relational databases.
• Investigate data load failures and data retrieval issues
#INDTS
TeamSoft is an Equal Opportunity Employer. We do not discriminate on the basis of race, color, religion, sex (including pregnancy, sexual orientation, and gender identity), national origin, age, disability, genetic information, or any other protected status under federal, state, or local law. We are committed to fostering a diverse and inclusive workplace.
