Senior AWS Data Architect - Data Warehouse & SQL Mastery

Tech Mirrors; Charlotte (NC); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Tech Mirrors in Charlotte, NC is seeking an AWS Data Architect to design enterprise data warehouse solutions, optimize SQL Server performance, and map business needs to technical architectures.

The role requires 10+ years in data warehousing or data architecture, hands-on AWS and ETL, and experience with ERStudio/Erwin for data modeling. You will collaborate with data engineers, analysts and business stakeholders to translate requirements into scalable data solutions.

Qualifications

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

Responsibilities

• Architectural design: Develop end-to-end data warehouse structures within Microsoft SQL Server.
• Data modeling ETL design: Logical/physical data models and robust ETL workflows.
• Performance optimization: Tune SQL queries, indexes and stored procedures for 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.

Skills

AWS

ETL

Data Architecture

Tools

SQL Server

ERStudio

Erwin

Job description

Tech Mirrors in Charlotte, NC is seeking an AWS Data Architect to design enterprise data warehouse solutions, optimize SQL Server performance, and map business needs to technical architectures.

The role requires 10+ years in data warehousing or data architecture, hands-on AWS and ETL, and experience with ERStudio/Erwin for data modeling. You will collaborate with data engineers, analysts and business stakeholders to translate requirements into scalable data solutions.