creatorId

INTEGRATED

TEMPORARY

FULL_TIME

CONTRACTOR

jobPosting hiringOrganization as json hashed.

POSTING_API

UNKNOWN

MONSTER_PLUS

extractedJobTitles

Data Warehouse Analyst II Location: Madison, WI Need to Relocate

onet27JobTitles

caroteneV3JobTitles

Data Warehousing Analyst

They will be responsible for the data profiling, analysis and documentation of data quality.

KBSkills

CBSkills

ACTIVE

Data Warehouse Analyst II Location: Madison, WI   Need to Relocate   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)   Required Skills Skill Name <select name="viewPostingSkills$requiredSkillsList$ctrl0$selectSkillType"> <option value="3">Certification </option><option value="2">Education </option><option value="4">License </option><option value="5">Other </option><option selected="selected" value="1">Skill </option></select> Experience in metadata discovery and documentation (5+ years) <select name="viewPostingSkills$requiredSkillsList$ctrl1$selectSkillType"> <option value="3">Certification </option><option value="2">Education </option><option value="4">License </option><option value="5">Other </option><option selected="selected" value="1">Skill </option></select> Experience in data profiling (5+ years) <select name="viewPostingSkills$requiredSkillsList$ctrl2$selectSkillType"> <option value="3">Certification </option><option value="2">Education </option><option value="4">License </option><option value="5">Other </option><option selected="selected" value="1">Skill </option></select> Experience in data quality assessment and identification (5+ years) <select name="viewPostingSkills$requiredSkillsList$ctrl3$selectSkillType"> <option value="3">Certification </option><option value="2">Education </option><option value="4">License </option><option value="5">Other </option><option selected="selected" value="1">Skill </option></select> Advanced experience in SQL and Python (3+ years)    Job Description:  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.   List any special qualifications & years of experience: <table border="0" cellpadding="0" cellspacing="0"> <tbody> <tr> <td> Qualification </td> <td> Experience </td> </tr> <tr> <td> Data Profiling </td> <td> 5+ years </td> </tr> <tr> <td> Python  </td> <td> 3 years </td> </tr> <tr> <td> Database design concepts </td> <td> 5+ years </td> </tr> <tr> <td> Excellent organization, analytical, and communication skills </td> <td> 5 years </td> </tr> <tr> <td> Creating and reviewing SQL scripting </td> <td> 5 years </td> </tr> <tr> <td> Knowledge of Oracle PL/SQL </td> <td> 5 years </td> </tr> <tr> <td> Metadata tools </td> <td> 5 years </td> </tr> <tr> <td> Oracle 11g/DB2/SQL Server </td> <td> 5 years </td> </tr> <tr> <td> Oracle data dictionary views </td> <td> 4 years </td> </tr> <tr> <td> Metadata documentation experience </td> <td> 5 years </td> </tr> <tr> <td> Data quality assessment and profiling </td> <td> 5 years </td> </tr> </tbody>
</table>

Prospect Infosys Inc

&lt;p&gt;&lt;b&gt;Data Warehouse Analyst II&lt;/b&gt;&lt;/p&gt; &lt;p&gt;&lt;b&gt;Location: Madison, WI&lt;/b&gt;&lt;/p&gt; &lt;p&gt;&lt;b&gt; &lt;/b&gt;&lt;/p&gt; &lt;p&gt;&lt;b&gt;Need to Relocate&lt;/b&gt;&lt;/p&gt; &lt;p&gt; &lt;/p&gt; &lt;p&gt;&lt;b&gt;Top skills:&lt;/b&gt;&lt;/p&gt; &lt;p&gt;· Experience in &lt;b&gt;metadata &lt;/b&gt;discovery and documentation (5+ years)&lt;/p&gt; &lt;p&gt;· Experience in &lt;b&gt;data profiling&lt;/b&gt; (5+ years)&lt;/p&gt; &lt;p&gt;· Experience in &lt;b&gt;data quality assessment&lt;/b&gt; and identification (5+ years)&lt;/p&gt; &lt;p&gt;· Advanced experience in &lt;b&gt;SQL and Python&lt;/b&gt; (3+ years)&lt;/p&gt; &lt;p&gt; &lt;/p&gt; &lt;p&gt;&lt;b&gt;Required Skills&lt;/b&gt;&lt;/p&gt; &lt;p&gt;&lt;b&gt;Skill Name&lt;/b&gt;&lt;/p&gt; &lt;p&gt; &lt;select name=&quot;viewPostingSkills$requiredSkillsList$ctrl0$selectSkillType&quot;&gt; &lt;option value=&quot;3&quot;&gt;Certification &lt;/option&gt;&lt;option value=&quot;2&quot;&gt;Education &lt;/option&gt;&lt;option value=&quot;4&quot;&gt;License &lt;/option&gt;&lt;option value=&quot;5&quot;&gt;Other &lt;/option&gt;&lt;option selected=&quot;selected&quot; value=&quot;1&quot;&gt;Skill &lt;/option&gt;&lt;/select&gt;&lt;/p&gt; &lt;p&gt;Experience in metadata discovery and documentation (5+ years)&lt;/p&gt; &lt;p&gt; &lt;select name=&quot;viewPostingSkills$requiredSkillsList$ctrl1$selectSkillType&quot;&gt; &lt;option value=&quot;3&quot;&gt;Certification &lt;/option&gt;&lt;option value=&quot;2&quot;&gt;Education &lt;/option&gt;&lt;option value=&quot;4&quot;&gt;License &lt;/option&gt;&lt;option value=&quot;5&quot;&gt;Other &lt;/option&gt;&lt;option selected=&quot;selected&quot; value=&quot;1&quot;&gt;Skill &lt;/option&gt;&lt;/select&gt;&lt;/p&gt; &lt;p&gt;Experience in data profiling (5+ years)&lt;/p&gt; &lt;p&gt; &lt;select name=&quot;viewPostingSkills$requiredSkillsList$ctrl2$selectSkillType&quot;&gt; &lt;option value=&quot;3&quot;&gt;Certification &lt;/option&gt;&lt;option value=&quot;2&quot;&gt;Education &lt;/option&gt;&lt;option value=&quot;4&quot;&gt;License &lt;/option&gt;&lt;option value=&quot;5&quot;&gt;Other &lt;/option&gt;&lt;option selected=&quot;selected&quot; value=&quot;1&quot;&gt;Skill &lt;/option&gt;&lt;/select&gt;&lt;/p&gt; &lt;p&gt;Experience in data quality assessment and identification (5+ years)&lt;/p&gt; &lt;p&gt; &lt;select name=&quot;viewPostingSkills$requiredSkillsList$ctrl3$selectSkillType&quot;&gt; &lt;option value=&quot;3&quot;&gt;Certification &lt;/option&gt;&lt;option value=&quot;2&quot;&gt;Education &lt;/option&gt;&lt;option value=&quot;4&quot;&gt;License &lt;/option&gt;&lt;option value=&quot;5&quot;&gt;Other &lt;/option&gt;&lt;option selected=&quot;selected&quot; value=&quot;1&quot;&gt;Skill &lt;/option&gt;&lt;/select&gt;&lt;/p&gt; &lt;p&gt;Advanced experience in SQL and Python (3+ years)&lt;/p&gt; &lt;p&gt; &lt;/p&gt; &lt;p&gt;&lt;b&gt; &lt;/b&gt;&lt;b&gt;Job Description:&lt;/b&gt; &lt;b&gt; &lt;/b&gt;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.&lt;/p&gt; &lt;p&gt;The individual in this position will:&lt;/p&gt; &lt;p&gt;Audit existing databases to assess data characteristics such as completeness, accuracy, outliers, and duplicates.&lt;/p&gt; &lt;p&gt;Investigate and define automated validation rules to guarantee data accuracy and catch errors at the point of entry.&lt;/p&gt; &lt;p&gt;Develop data cleansing and remediation recommendations for data irregularities.&lt;/p&gt; &lt;p&gt;Establish key performance indicators (KPIs) to measure data health, and build reporting dashboards to track quality metrics and trends. &lt;/p&gt; &lt;p&gt;Investigate the origins of recurring data errors (e.g., system bugs, user errors, integration issues) and recommend targeted, systemic solutions.&lt;/p&gt; &lt;p&gt;Document and define key metadata around database architecture.&lt;/p&gt; &lt;p&gt;Make recommendations on data maintenance and data quality.&lt;/p&gt; &lt;p&gt;Collaborate with Data Modelers and Data Architects on recommendations for key data management and data quality efforts.&lt;/p&gt; &lt;p&gt; &lt;/p&gt; &lt;p&gt;&lt;b&gt;List any special qualifications &amp; years of experience: &lt;/b&gt;&lt;/p&gt; &lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot;&gt; &lt;tbody&gt; &lt;tr&gt; &lt;td&gt; &lt;p&gt;&lt;b&gt;Qualification&lt;/b&gt;&lt;/p&gt; &lt;/td&gt; &lt;td&gt; &lt;p&gt;&lt;b&gt;Experience&lt;/b&gt;&lt;/p&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; &lt;p&gt;Data Profiling&lt;/p&gt; &lt;/td&gt; &lt;td&gt; &lt;p&gt;5+ years&lt;/p&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; &lt;p&gt;Python &lt;/p&gt; &lt;/td&gt; &lt;td&gt; &lt;p&gt;3 years&lt;/p&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; &lt;p&gt;Database design concepts&lt;/p&gt; &lt;/td&gt; &lt;td&gt; &lt;p&gt;5+ years&lt;/p&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; &lt;p&gt;Excellent organization, analytical, and communication skills&lt;/p&gt; &lt;/td&gt; &lt;td&gt; &lt;p&gt;5 years&lt;/p&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; &lt;p&gt;Creating and reviewing SQL scripting&lt;/p&gt; &lt;/td&gt; &lt;td&gt; &lt;p&gt;5 years&lt;/p&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; &lt;p&gt;Knowledge of Oracle PL/SQL&lt;/p&gt; &lt;/td&gt; &lt;td&gt; &lt;p&gt;5 years&lt;/p&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; &lt;p&gt;Metadata tools&lt;/p&gt; &lt;/td&gt; &lt;td&gt; &lt;p&gt;5 years&lt;/p&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; &lt;p&gt;Oracle 11g/DB2/SQL Server&lt;/p&gt; &lt;/td&gt; &lt;td&gt; &lt;p&gt;5 years&lt;/p&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; &lt;p&gt;Oracle data dictionary views&lt;/p&gt; &lt;/td&gt; &lt;td&gt; &lt;p&gt;4 years&lt;/p&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; &lt;p&gt;Metadata documentation experience&lt;/p&gt; &lt;/td&gt; &lt;td&gt; &lt;p&gt;5 years&lt;/p&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; &lt;p&gt;Data quality assessment and profiling&lt;/p&gt; &lt;/td&gt; &lt;td&gt; &lt;p&gt;5 years&lt;/p&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/tbody&gt;
&lt;/table&gt; &lt;p&gt; &lt;/p&gt;

Location	Madison, WI, WI
Job Type	Temporary, Contractor, Full-time

Data Warehouse Analyst II Location: Madison, WI Need to Relocate

Prospect Infosys Inc

Highlights

Numbers & Facts

Description

Similar Jobs

Salesforce Data Cloud Architect Kforce Inc.

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