Data Specialist

Data Specialist/Analyst

Charlotte, NC

Hybrid: 3 days a week, 1 day remote

$65-$70/hour - depending on Experience

** Must be local to Charlotte, NC, not open to relocation at this tim

e**No able to work c2c or provide sponsorship at this tim

e
Job Summa

ryWe are seeking an Dat a Analytics Specialis t to support the design, build, and modernization of our enterprise data warehouse. This role will work handson i n Amazon Redshi ft, performin g data modeling, SQL development, and data validati on, while also partnering closely with Data Engineers to defin e clear, actionable pipeline specificatio n

s.The ideal candidate brings stron g SQL and database experti se, experience analyzin g legacy SQL Server environmen ts, and the ability to perfor m data cleanup and reconciliation during platform conversio ns. This role sits at the intersection of analytics, data engineering, and technical analysis, requiring both execution and documentation skill

s.
Key Responsibilit

iesData Modeling & Warehouse Developm

• entDesign and impleme nt dimensional data mod els (fact and dimension tables) in Amazon Redsh
• iftBuild and maintain curated analytics datasets to support reporting and downstream consumpt
• ionApply data warehousing best practices (star/snowflake schemas, SCD patterns, conformed dimensio
• ns)Write, optimize, and maintain compl ex SQL transformati ons in Redsh

iftCurrent State Analysis & Data Convers

• ionAnalyze existi ng SQL Server databa ses to understand currentstate schemas, relationships, and data us
• agePerfo rm data profiling, cleanup, and remediat ion during data warehouse migration/conversion effo
• rtsIdentify data quality issues (duplicates, nulls, type mismatches, integrity gaps) and define resolution lo
• gicReconcile source and target datasets to validate accuracy and completen

essData Engineering Collaboration & Specificati

• onsTranslate business and analytical requirements in to technical specificati ons for data pipelines, includi
• ng:sourcetotarget mappi
• ngstransformation lo
• gicdata quality and validation ru
• lesacceptance criteria and edge ca
• sesPartner with Data Engineers during backlog refinement and implementat
• ionSupport testing, validation, and production readiness of data pipeli

nesDocumentation & Stakeholder Collaborat

• ionCreate and maintain data models, data dictionaries, and transformation documentat
• ionCommunicate effectively with technical and nontechnical stakehold
• ersAct as a bridge between business, analytics, and engineering te

ams
Required Qualificat

• ions4–7 years of experience in analytics engineering, data warehousing, or a related technical data
• roleStrong handson experience w ith Amazon Reds hift or similar cloud data wareho
• usesAdvanced proficiency in SQL, including complex joins, window functions, aggregations, and performance tu
• ningExperience working w ith SQL Se rver and relational databases in legacy or migration scena
• riosSolid understanding of data modeling and data warehousing conc
• eptsExperience collaborating w ith data engineering t eams and supporting ETL/ELT pipel
• inesStrong analytical thinking and problemsolving sk
• illsAbility to document technical logic clearly and conci

sely
Preferred / NicetoHave S

• killsExperience suppor ting data warehouse modernization or migration pro
• jectsFamiliarity with AWS data services (Glue, S3, Lambda, dbt, Airflow,
• etc.)Exposure to data quality frameworks and reconciliation techn
• iquesExperience working in Agile/Scrum delivery m
• odelsKnowledge of BI and analytics tools (Tableau, Power BI, Looker, QuickS

ight)
What Success Look

• s LikeRedshift data models are welldesigned, performant, and aligned with business
• needsSQL Server legacy data is accurately analyzed, cleaned, and mi
• gratedData engineering teams receive clear, complete, and implementationready specific
• ationsStakeholders trust the data produced and understand how it is d