Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Specialist

Brooksource

Must be local to Charlotte, NC; relocation not available. Unable to work C2C or provide sponsorship. Job Summary We are seeking a Data Analytics Specialist to support the design, build, and modernization of our enterprise data warehouse. This role will work hands‑on in Amazon Redshift, performing data modeling, SQL development, and data validation, while also partnering closely with Data Engineers to define clear, actionable pipeline specifications. The ideal candidate brings strong SQL and database experience, 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. Key Responsibilities Data Modeling & Warehouse Development Design and implement dimensional data models (fact and dimension tables) in Amazon Redshift. Build and maintain curated analytics datasets to support reporting and downstream consumption. Apply data warehousing best practices (star/snowflake schemas, SCD patterns, conformed dimensions). Write, optimize, and maintain complex SQL transformations in Redshift. Current State Analysis & Data Conversion Analyze existing SQL Server databases to understand current‑state schemas, relationships, and data usage. Perform data profiling, cleanup, and remediation during data warehouse migration/conversion efforts. Identify data quality issues (duplicates, nulls, type mismatches, integrity gaps) and define resolution logic. Reconcile source and target datasets to validate accuracy and completeness. Data Engineering Collaboration & Specifications Translate business and analytical requirements into technical specifications for data pipelines, including data quality and validation rules. Define acceptance criteria and edge cases. Partner with Data Engineers during backlog refinement and implementation. Support testing, validation, and production readiness of data pipelines. Documentation & Stakeholder Collaboration Create and maintain data models, data dictionaries, and transformation documentation. Communicate effectively with technical and non‑technical stakeholders. Act as bridge between business, analytics, and engineering teams. Required Qualifications 4–7 years of experience in analytics engineering, data warehousing, or a related technical data role. Strong hands‑on experience with Amazon Redshift or similar cloud data warehouse. Advanced proficiency in SQL, including complex joins, window functions, aggregations, and performance tuning. Experience working with SQL Server and relational databases in legacy or migration scenarios. Solid understanding of data modeling and data warehousing concepts. Experience collaborating with data engineering teams and supporting ETL/ELT pipelines. Strong analytical thinking and problem‑solving skills. Ability to document technical logic clearly and concisely. Preferred / Nice to Have Experience supporting data warehouse modernization or migration projects. Familiarity with AWS data services (Glue, S3, Lambda, dbt, Airflow, etc.). Exposure to data quality frameworks and reconciliation techniques. Experience working in Agile/Scrum delivery models. Knowledge of BI and analytics tools (Tableau, Power BI, Looker, QuickSight). What Success Looks Like Redshift data models are well‑designed, performant, and aligned with business needs. SQL Server legacy data is accurately analyzed, cleaned, and migrated. Data engineering teams receive clear, complete, and implementation‑ready specifications. Stakeholders trust the data produced and understand how it is derived. #J-18808-Ljbffr

Vacancy posted 1 day ago
Similar jobs that could be interesting for youBased on the Data Specialist in Charlotte, NC vacancy
  •  ...hackajob is collaborating with Vanguard to connect them with exceptional professionals for this role. Analyzes data, assesses trends and develops actionable insights and recommendations in support of large strategic business initiatives. Actively develops the analytics... 
    Suggested
    Work experience placement

    Vanguard

    Charlotte, NC
    20 days ago
  •  ...hackajob is collaborating with Vanguard to connect them with exceptional professionals for this role. Analyzes data, assesses trends and develops actionable insights and recommendations in support of enterprise-wide strategic business initiatives. Develops the analytics... 
    Suggested

    Vanguard

    Charlotte, NC
    18 days ago
  •  ...hackajob is collaborating with Vanguard to connect them with exceptional professionals for this role. Role Summary The Data Analyst, Specialist is responsible for leveraging data-driven insights to support strategic business decisions and improve operational... 
    Suggested
    Work experience placement

    Vanguard

    Charlotte, NC
    22 days ago
  •  ...actionable insights and scalable analytics that enable Personal Investor Distribution to drive growth, improve client experiences, and make data-informed decisions across the sales channels. This data analyst role will play a pivotal part in transforming complex data into... 
    Suggested
    Work experience placement

    Vanguard

    Charlotte, NC
    22 days ago
  •  ...them with exceptional professionals for this role. Analyzes data, assesses trends and develops actionable insights and recommendations...  ...external events. Role Summary The Data Analyst, Senior Specialist is responsible in driving data-driven decision-making across... 
    Suggested
    Work experience placement

    Vanguard

    Charlotte, NC
    22 days ago
  •  ...Employment Type: Full-Time, Mid-Level. Department: Data Science. As a Data Specialist for CGS you will help our government client in processing data using LAW. The ideal candidate will regularly load large volumes of production data; running exports from the database... 
    Full time
    Flexible hours

    CGS Federal (Contact Government Services)

    Charlotte, NC
    5 days ago
  •  ...Overview Insight Global is looking for a Data Specialist for one of our larger automotive companies sitting in Ballantyne, NC. This individual will be responsible for working statements as well as uploading the cancellation data and moving the data into their workflow... 
    Work at office

    Insight Global

    Charlotte, NC
    3 days ago
  •  ...analytics expert on cross-functional teams for enterprise-wide strategic initiatives. Acquires and compiles structured and unstructured data and verifies its quality, accuracy and reasonableness. Leads the development of data quality standards, and the tools and methods... 
    Work experience placement

    Vanguard

    Charlotte, NC
    2 days ago
  •  ...Certified Oncology Data Specialist The Certified Oncology Data Specialist plays a critical role in ensuring the accuracy of the data collected in accordance with state and national mandated regulations to support Novant Health's Cancer Institutes. What You Will Do... 
    Private practice
    Flexible hours

    Novant Health

    Belmont, NC
    2 days ago
  •  ...Overview Employment Type: Full-Time, Experienced Department: eDiscovery CGS is seeking an experienced Senior Data Specialist II with extensive knowledge of litigation discovery processes to provide assistance in the EDRM workflow for a large Federal agency initiative.... 
    Full time
    For contractors
    Flexible hours

    CGS Federal (Contact Government Services)

    Charlotte, NC
    4 days ago
  • A government services contractor is seeking an experienced Senior Data Specialist in Charlotte, NC. This role requires extensive knowledge of litigation discovery processes and support in the EDRM workflow for a large Federal agency initiative. Responsibilities include... 
    For contractors

    CGS Federal (Contact Government Services)

    Charlotte, NC
    3 days ago
  • $136.75k - $218.8k

     ...-demand professional development resources that allow you to hone existing skills and learn new ones I can succeed as a Data Governance Specialist at Capital Group. As a Data Governance Specialist, you will help shape and advance data governance capabilities across Capital... 
    Temporary work
    Local area
    Flexible hours

    Capital Group

    Charlotte, NC
    1 day ago
  • $110k - $125k

     ...Job Description Must Have Technical/Functional Skills: Data Annotator / Data Labeling Specialist, Agile concepts, CI/CD. 10+ years’ experience. Roles & Responsibilities Accurately label text, image, audio, or structured data based on project-specific guidelines. Follow... 

    Tata Consultancy Services

    Charlotte, NC
    5 days ago
  •  ...Required Skills 10+ years of experience in Data Annotation / Data Labeling. Knowledge of Agile concepts and CI/CD processes. Experience with annotation tools such as Labelbox, CVAT, VGG, etc. Familiarity with image annotation, NLP labeling, and data categorization. Proficiency... 

    Veriipro

    Charlotte, NC
    5 days ago
  • $55k - $108.5k

     ...Crowe is looking for a Campaign Data Operations Senior Associate in Charlotte, NC. The role focuses on managing audience data, optimizing campaign workflows, and supporting team adoption of sales technologies. Ideal candidates will have a BA in Marketing or a related... 

    Crowe

    Charlotte, NC
    3 days ago
  •  ...SAP Master Data Specialist We are seeking a highly skilled SAP Master Data Specialist with deep expertise in Material Master, product setup processes, and end-to-end master data governance. This role will work closely with cross-functional business teams, product development... 

    Futran Tech Solutions Pvt. Ltd.

    Belmont, NC
    4 days ago
  • IBM is seeking a Technology Sales Representative in Charlotte, North Carolina to enhance enterprises’ success with data-driven solutions. The role involves managing a dedicated client set and using solution-selling expertise to engage decision makers and create partnerships... 

    IBM

    Charlotte, NC
    2 days ago
  •  ...Data Center System Administrator We are currently hiring for a Data Center System Administrator in Charlotte, North Carolina, with experience in Linux, Unix, RedHat, to work a mix of on-site and remote support to our customers. This role will require you to be on site... 
    Currently hiring
    Work at office
    Local area
    Remote work
    3 days per week

    Lenovo

    Charlotte, NC
    4 days ago
  •  ...spans across experimentation, measurement, advanced analytics, and data storytelling to deliver on client-alpha focused outcomes....  ...engagement to our program. Role Summary The Data Analyst, Senior Specialist role analyzes complex datasets to provide actionable insights,... 
    Work experience placement

    Vanguard

    Charlotte, NC
    14 days ago
  •  ...a critical role in shaping how we engage with prospects and clients—bringing the power of Vanguard’s trusted brand to life through data-driven, personalized marketing. This role will be pivotal in enhancing the performance of our marketing campaigns through advanced... 
    Work experience placement

    Vanguard

    Charlotte, NC
    20 days ago
  •  ...Job Description Job Description CPI Security is looking to hire a Human Resources Data and Systems Specialist (HRIS Specialist) to serve our team based in Charlotte, North Carolina. CPI Security was founded in 1991 on an entrepreneurial spirit and a passion for helping... 
    Temporary work

    CPI Security

    Charlotte, NC
    16 days ago
  • $79.64k

     ...Job Description At Regions, the Risk Information Technology and Data Analyst is a key member of the IT and Data Risk Management organization and performs general activities consistent with the second line of defense, including IT and Data risk identification, measurement... 
    Full time
    Flexible hours

    Regions Bank

    Charlotte, NC
    2 days ago
  •  ...TITLE IT Data Analyst REPORTING TO Sr. Manager, IT Architect SUPERVISORY RESPONSBILITIES N/A LOCATION Charlotte, NC THE COMPANY From humble beginnings, GALE Pacific has grown to become a global leader in technical fabrics and consumer... 
    Local area

    Gale Pacific USA, Inc.

    Charlotte, NC
    3 days ago
  •  ...Job Description Insight Global is looking for a Data Analytics Analyst to support the Internal Audit organization at one of our large financial clients. This individual will perform in a few functions, including: Support Internal Audit teams by developing and executing... 

    Insight Global

    Charlotte, NC
    4 days ago
  •  ...Job Title: Data Center Analyst Location: Charlotte, NC Position: Fulltime, Multiple Openings Responsibilities Data Center Operations provides monitoring, problem escalation, job scheduling and tape management services for the various Data Centers. The Data Center Operations... 
    Full time

    MMI

    Charlotte, NC
    4 days ago
  •  ...REQUIREMENT Job Title: Data Analyst Job ID: R251000318 Location: Charlotte, NC, 28246 Duration: 6 Months+ Background required: Investment/Fund/Financial CW-Data Analyst The Data Analyst identifies current market... 
    Contract work
    Work experience placement
    Work at office
    Night shift
    Afternoon shift

    Maintec Technologies

    Charlotte, NC
    5 days ago
  •  ...Data Analyst Role: Data Analyst with Guidewire and P&C Insurance Locations: Boston, MA; Charlotte, NC; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Fargo, ND; Florham Park, NJ; Garden City, NY; Houston, TX; Jacksonville, IL; Lenexa, KS; Los Angeles, CA; Lubbock... 
    Full time

    Keylent Inc

    Charlotte, NC
    1 day ago
  •  ...Mindtree in solving the most complex business challenges and delivering transformation at scale. For more information, please visit Role: Data Analyst Job Description Mandatory Skills Key Responsibilities Job Summary Experience in Python for Data within the Data Analysis... 
    Temporary work
    Local area

    LTM

    Charlotte, NC
    1 day ago
  •  ...TX; Morristown, NJ; Mt Juliet, TN; New York, NY; Purchase, NY; Topeka, KS. Requirements ~8+ years as a hands-on IT Reporting data analyst. ~4+ years of experience in reporting or data analysis within the Property & Casualty insurance industry; reinsurance... 

    The Dignify Solutions, LLC

    Charlotte, NC
    1 day ago
  • $55 - $60 per hour

     ...Job Overview Pay Range: $55hr - $60hr Requirement/Must Have: ~1+ years of experience in data analysis. ~ Strong verbal and written communication skills. ~ Excellent communication and presentation skills. ~ Ability to communicate effectively with stakeholders... 

    Cynet Systems

    Charlotte, NC
    3 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Specialist. Be the first to apply!