Senior Data Analyst

at  Prepcloud

DESCRIPTION

We are seeking a Senior Data Analyst to support the IPMS project by executing data conversion, cleanup, mapping, and validation processes. This role is crucial in ensuring data accuracy and integrity during system transitions and integrations. The ideal candidate should have hands-on experience handling large datasets, developing data mapping strategies, and conducting rigorous validation checks. Proficiency in SQL Server, advanced SQL scripting, and Excel-based data analysis is essential.

REQUIRED QUALIFICATIONS

• Enterprise Data Conversion Experience: Proven track record in enterprise-wide data migration projects, including mapping and validation. Experience with at least three enterprise system implementations (e.g., ERP systems).
• SQL Expertise: Advanced proficiency in SQL scripting and manipulating large datasets.
• Excel Mastery: Strong expertise in advanced Excel functions, including pivot tables, complex formulas, and macros.
• Data Quality Management: Hands-on experience with data reconciliation, cleanup, and validation techniques.
• Analytical Thinking: Strong ability to analyze complex data structures and derive actionable insights.
• Technical Documentation: Proficiency in documenting processes, workflows, and data mapping logic.
• Collaboration Skills: Experience working with cross-functional teams to meet project objectives.
• Effective Communication: Ability to convey technical concepts to non-technical stakeholders clearly and concisely.

• Data Conversion: Execute seamless data migration from legacy systems to new platforms.
• Data Cleanup: Identify and resolve inconsistencies, duplicates, and quality issues.
• Data Mapping: Develop and implement logic to align source and target data structures accurately.
• Data Validation: Perform manual validation using Excel and utilize automated validation tools as needed.
• Advanced Excel Analysis: Use pivot tables, VLOOKUP, macros, and complex formulas for data analysis and validation.
• SQL Server Expertise: Write complex SQL queries for data analysis and troubleshooting.
• Reporting: Develop reports and dashboards to track data conversion progress and key metrics.
• Cross-Functional Collaboration: Work closely with developers, business analysts, and project managers to align data-related efforts with project goals.
• Documentation: Maintain detailed documentation of data conversion processes, mapping logic, and validation results for transparency and reference.