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 Data Analytics Specialist to support the design, build, and modernization of our enterprise data warehouse. This role will work handson in Amazon Redshift, performing data modeling, SQL development, and data validation, while also partnering closely with Data Engineers to define clear, actionable pipeline specification

s.The ideal candidate brings strong SQL and database expertise, experience analyzing legacy SQL Server environments, and the ability to perform data cleanup and reconciliation during platform conversions. 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 implement dimensional data models (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 complex SQL transformations in Redsh

iftCurrent State Analysis & Data Convers

• ionAnalyze existing SQL Server databases to understand currentstate schemas, relationships, and data us
• agePerform data profiling, cleanup, and remediation 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 into technical specifications 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 with Amazon Redshift or similar cloud data wareho
• usesAdvanced proficiency in SQL, including complex joins, window functions, aggregations, and performance tu
• ningExperience working with SQL Server and relational databases in legacy or migration scena
• riosSolid understanding of data modeling and data warehousing conc
• eptsExperience collaborating with data engineering teams and supporting ETL/ELT pipel
• inesStrong analytical thinking and problemsolving sk
• illsAbility to document technical logic clearly and conci

sely
Preferred / NicetoHave S

• killsExperience supporting 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