Data Mapping Specialist

Title: Data Mapping Specialist (Business Systems Analyst Lead) Duration: 6 months - Possibility to extend Pay Range: $45 - $56/hr What They ACTUALLY Need This is NOT just a traditional BSA role. They want someone who can combine: 1. Strong Data Analysis + SQL Expertise AND 1. Functional/System Mapping Experience AND 1. Communication & Stakeholder Management This is a highly data-heavy conversion/migration role. Core Responsibilities Source-to-Target Mapping Candidate will: • Analyze source system data • Understand destination system structure • Create mapping logic between systems • Define transformation/business rules • Document field-level mappings Examples: • Source field → destination field • Logic/transformation needed • Data flow understanding SQL/Data Analysis Work Heavy SQL involvement. Must be comfortable: • Writing joins • Subqueries • Window functions • Auditing large databases • Data validation • Root cause analysis • Reporting/query creation Purpose: • Validate conversion accuracy • Compare source vs destination data • Identify data issues • Support mock conversions & production go-live Conversion Testing They WILL be involved in testing. Testing includes: • Mock conversion testing • Post-load validation • Data accuracy checks • Exception reporting • Identifying failed mappings/issues No specific testing tool required. Production/Go-Live Support During actual conversion: • Validate production data • Resolve issues quickly • Investigate defects/root causes • Support customer-impacting events Stakeholder Communication Very important differentiator. Candidate must: • Explain technical findings clearly • Communicate root causes • Socialize mapping decisions • Coordinate with: • Product teams • Tech teams • Business/process leads • PMs This is NOT a head-down SQL-only role. Required Skills MUST HAVE SQL (Advanced) Need strong hands-on SQL: • Joins • Complex queries • Subqueries • Window functions • Large-scale data analysis Source-to-Target Mapping Critical requirement. Need proven experience: • Mapping documents • Data lineage • Data flow diagrams • Conversion logic Snowflake Very important. Manager said: “That’s the major source of where we look at data.” Ideal candidate: • Has worked in Snowflake directly • Can write SQL in Snowflake environment • Comfortable joining/querying large datasets Data Validation / Testing • Mock conversion validation • Data reconciliation • Reporting support Communication Skills Strong differentiator. Need someone who can: • Communicate findings • Handle stakeholders • Explain technical issues • Work cross-functionally Tools / Systems Required: • Snowflake • Google Sheets • SQL Nice to have: • Automation mindset • Reporting improvements • Manual process optimization