Principal - Architecture

LTM

Charlotte, NC

Apply

JOB DETAILS

SKILLS

Architectural Design, Data Analysis, Data Mapping, Data Modeling, Data Modeling Tools, Data Quality, Data Recovery, Data Storage, Data Structures, Data Warehousing, Database Extract Transform and Load (ETL), Documentation, Information/Data Security (InfoSec), Maintain Compliance, Microsoft FAST, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Performance Tuning/Optimization, Query Analysis, Query Optimization, SQL (Structured Query Language), Server Architecture, Standards Development, Stored Procedures, erwin Data Modeler

LOCATION

Charlotte, NC

POSTED

1 day ago

Role description

A SQL Server Data Warehouse Architect designs and optimizes enterpriselevel 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

Core Responsibilities

Architectural Design Develop endtoend data warehouse structures within Microsoft SQL Server

Data Modeling ETL Design logicalphysical 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

Key Qualifications

Experience 10 years in data warehousing data engineering or solution architecture

Technical Expertise Expertlevel SQL Server TSQL and query plan analysis

Data Modeling Proficient with data modeling and tools like ERStudio or Erwin

About the Company

LTM

Resume Resources

Free Resume Templates Free Resume Builder