AWS Data Architect c2c jobs Charlotte, NC (Onsite​/ Hybrid

Job Title: AWS Data Architect

Location: Charlotte, NC (Onsite/ Hybrid)

Experience: 10+ Years minimum.

Mandatory

Skills:

AWS, ETL, Data Architecture

A Server Data Warehouse Architect designs and optimizes enterprise level data storage solutions mapping business needs to technical architectures. Key responsibilities include designing data models, tables loading patterns, indexing strategies, optimizing SQL Server TSQL performance and ensuring data integrity.

• Architectural Design:
  Develop end-to-end data warehouse structures within Microsoft SQL Server.
• Data Modeling ETL Design:
  Logical/physical data models and robust ETLELT workflows.
• Performance Optimization:
  Tune SQL queries, indexes and stored procedures to ensure fast data retrieval.
• Governance Security:
  Define data standards, security policies and documentation to ensure compliance.
• Collaboration:
  
  Work with data engineers, analysts and business stakeholders to translate needs into technical specifications.

• Experience:
  
  10 years in data warehousing, data engineering or solution architecture.
• Technical Expertise:
  Expert level SQL Server TSQL and query plan analysis.
• Data Modeling:
  Proficient with data modeling tools like ERStudio or Erwin.