Data Mapping Specialist (Henrico)
Title: Data Mapping Specialist (Business Systems Analyst Lead)Duration: 6 months - Possibility to extendPay Range: $45 - $56/hrWhat They ACTUALLY NeedThis is NOT just a traditional BSA role.They want someone who can combine:1. Strong Data Analysis + SQL ExpertiseAND2. Functional/System Mapping ExperienceAND3. Communication & Stakeholder ManagementThis is a highly data-heavy conversion/migration role.Core ResponsibilitiesSource-to-Target MappingCandidate will:Analyze source system dataUnderstand destination system structureCreate mapping logic between systemsDefine transformation/business rulesDocument field-level mappingsExamples:Source field → destination fieldLogic/transformation neededData flow understandingSQL/Data Analysis WorkHeavy SQL involvement.Must be comfortable:Writing joinsSubqueriesWindow functionsAuditing large databasesData validationRoot cause analysisReporting/query creationPurpose:Validate conversion accuracyCompare source vs destination dataIdentify data issuesSupport mock conversions & production go-liveConversion TestingThey WILL be involved in testing.Testing includes:Mock conversion testingPost-load validationData accuracy checksException reportingIdentifying failed mappings/issuesNo specific testing tool required.Production/Go-Live SupportDuring actual conversion:Validate production dataResolve issues quicklyInvestigate defects/root causesSupport customer-impacting eventsStakeholder CommunicationVery important differentiator.Candidate must:Explain technical findings clearlyCommunicate root causesSocialize mapping decisionsCoordinate with:Product teamsTech teamsBusiness/process leadsPMsThis is NOT a head-down SQL-only role.Required SkillsMUST HAVESQL (Advanced)Need strong hands-on SQL:JoinsComplex queriesSubqueriesWindow functionsLarge-scale data analysisSource-to-Target MappingCritical requirement.Need proven experience:Mapping documentsData lineageData flow diagramsConversion logicSnowflakeVery important.Manager said:"That's the major source of where we look at data."Ideal candidate:Has worked in Snowflake directlyCan write SQL in Snowflake environmentComfortable joining/querying large datasetsData Validation / TestingMock conversion validationData reconciliationReporting supportCommunication SkillsStrong differentiator.Need someone who can:Communicate findingsHandle stakeholdersExplain technical issuesWork cross-functionallyTools / SystemsRequired:SnowflakeGoogle SheetsSQLNice to have:Automation mindsetReporting improvementsManual process optimization