Data Analyst 3

<h5>Engagement Type</h5> <p>Contract</p> <h5><br /> </h5> <hr data-end=""904/"" data-start=""901/"" /> <h3 data-end=""935/"" data-start=""906/""><strong data-end=""935/"" data-start=""910/"">Key Responsibilities:</strong></h3> <ul data-end=""1767/"" data-start=""936/""> <li data-end=""1036/"" data-start=""936/""> <p data-end=""1036/"" data-start=""938/"">Conduct detailed data <strong data-end=""1002/"" data-start=""960/"">cleanup, validation, and normalization</strong> within the Dataverse environment.</p> </li> <li data-end=""1149/"" data-start=""1037/""> <p data-end=""1149/"" data-start=""1039/"">Use <strong data-end=""1058/"" data-start=""1043/"">SQL queries</strong> to analyze and compare records from legacy SQL systems and the current Dataverse platform.</p> </li> <li data-end=""1286/"" data-start=""1150/""> <p data-end=""1286/"" data-start=""1152/"">Perform <strong data-end=""1183/"" data-start=""1160/"">data reconciliation</strong> to confirm accuracy and completeness of migrated data, identifying mismatches and resolving anomalies.</p> </li> <li data-end=""1383/"" data-start=""1287/""> <p data-end=""1383/"" data-start=""1289/"">Collaborate with stakeholders to understand business rules and define expected data standards.</p> </li> <li data-end=""1477/"" data-start=""1384/""> <p data-end=""1477/"" data-start=""1386/"">Develop scripts and tools to automate data quality checks and support ongoing data hygiene.</p> </li> <li data-end=""1558/"" data-start=""1478/""> <p data-end=""1558/"" data-start=""1480/"">Document findings and cleanup efforts to ensure transparency and auditability.</p> </li> <li data-end=""1683/"" data-start=""1559/""> <p data-end=""1683/"" data-start=""1561/"">Assist with building reports and views in Dataverse and Power BI to support data quality monitoring and operational needs.</p> </li> <li data-end=""1767/"" data-start=""1684/""> <p data-end=""1767/"" data-start=""1686/"">Support efforts to enforce data governance and improve data management practices.</p> </li> </ul> <hr data-end=""1772/"" data-start=""1769/"" /> <h3 data-end=""1795/"" data-start=""1774/""><strong data-end=""1795/"" data-start=""1778/"">Requirements:</strong></h3> <ul data-end=""2398/"" data-start=""1796/""> <li data-end=""1883/"" data-start=""1796/""> <p data-end=""1883/"" data-start=""1798/"">Proficient in <strong data-end=""1819/"" data-start=""1812/"">SQL</strong>, including complex joins, data comparison, and troubleshooting.</p> </li> <li data-end=""1992/"" data-start=""1884/""> <p data-end=""1992/"" data-start=""1886/"">Strong understanding of <strong data-end=""1933/"" data-start=""1910/"">Microsoft Dataverse</strong>, including schema, data relationships, and business rules.</p> </li> <li data-end=""2083/"" data-start=""1993/""> <p data-end=""2083/"" data-start=""1995/"">Experience with <strong data-end=""2046/"" data-start=""2011/"">data quality and reconciliation</strong> efforts following system migrations.</p> </li> <li data-end=""2180/"" data-start=""2084/""> <p data-end=""2180/"" data-start=""2086/"">Ability to analyze large datasets and identify discrepancies, duplicates, and inconsistencies.</p> </li> <li data-end=""2275/"" data-start=""2181/""> <p data-end=""2275/"" data-start=""2183/"">Familiarity with <strong data-end=""2218/"" data-start=""2200/"">Power Platform</strong> tools, particularly <strong data-end=""2251/"" data-start=""2239/"">Power BI</strong> and <strong data-end=""2274/"" data-start=""2256/"">Power Automate</strong>.</p> </li> <li data-end=""2398/"" data-start=""2276/""> <p data-end=""2398/"" data-start=""2278/"">Strong documentation and communication skills for reporting findings and working with both technical and business teams.</p> </li> </ul> <hr data-end=""2403/"" data-start=""2400/"" /> <h3 data-end=""2438/"" data-start=""2405/""><strong data-end=""2438/"" data-start=""2409/"">Preferred Qualifications:</strong></h3> <ul data-end=""2821/"" data-start=""2439/""> <li data-end=""2562/"" data-start=""2439/""> <p data-end=""2562/"" data-start=""2441/"">Experience using <strong data-end=""2474/"" data-start=""2458/"">KingswaySoft</strong>, <strong data-end=""2484/"" data-start=""2476/"">SSIS</strong>, or other ETL tools (helpful but not required for this post-migration phase).</p> </li> </ul> <h5>Required/Desired Skills</h5> <tableborder=""1/""style="border-collapse:collapse/""> <thead> <tr> <th>Skill</th> <th>Required/Desired</th> <th>Amount</th> <th>of Experience</th> </tr> </thead> <tbody> <tr> <td>Proficient in SQL</td> <td>Required</td> <td>3</td> <td>Years</td> </tr> <tr> <td>Strong understanding of Microsoft Dataverse</td> <td>Required</td> <td>2</td> <td>Years</td> </tr> <tr> <td>Power BI</td> <td>Required</td> <td>2</td> <td>Years</td> </tr> <tr> <td>Experience analyzing large datasets</td> <td>Required</td> <td>2</td> <td>Years</td> </tr> <tr> <td>Power Automate</td> <td>Required</td> <td>1</td> <td>Years</td> </tr> <tr> <td>Experience with Kingsway Soft and/or SSIS</td> <td>Nice to have</td> <td>0</td> <td> </td> </tr> </tbody> </table> <h5> </h5>