SQL Server Data Warehouse Architect

LTIMindtree is an equal opportunity employer that is committed to diversity in the workplace. Our employment decisions are made without regard to race, color, creed, religion, sex (including pregnancy, childbirth or related medical conditions), gender identity or expression, national origin, ancestry, age, family-care status, veteran status, marital status, civil union status, domestic partnership status, military service, handicap or disability or history of handicap or disability, genetic information, atypical hereditary cellular or blood trait, union affiliation, affectional or sexual orientation or preference, or any other characteristic protected by applicable federal, state, or local law, except where such considerations are bona fide occupational qualifications permitted by law.

A little about us...

Role: SQL Server Data Warehouse Architect

Location: Charlotte, NC (Hybrid role 3 days/week)

Job Description:

A SQL 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 T-SQL performance, and ensuring data integrity.

Core 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/ELT 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: Expert-level (T-SQL) and query plan analysis.
• Data Modeling: Proficient with data modeling and tools like ER/Studio or Erwin.

LTIMindtree is an equal opportunity employer that is committed to diversity in the workplace. Our employment decisions are made without regard to race, color, creed, religion, sex (including pregnancy, childbirth or related medical conditions), gender identity or expression, national origin, ancestry, age, family-care status, veteran status, marital status, civil union status, domestic partnership status, military service, handicap or disability or history of handicap or disability, genetic information, atypical hereditary cellular or blood trait, union affiliation, affectional or sexual orientation or preference, or any other characteristic protected by applicable federal, state, or local law, except where such considerations are bona fide occupational qualifications permitted by law.