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

Skills

Mandatory Skills : Data Architecture

Benefits
Compensation range: $75 to $80.00 per hour
About LTM
LTM is an AI-centric global technology services company and the Business Creativity partner to the world’s largest and most disruptive enterprises. We bring human insights and intelligent systems together to help clients create greater value at the intersection of technology and domain expertise. Our capabilities span integrated operations, transformation, and business AI — enabling new ways of working, new productivity paradigms, and new roads to value. Together with over 87,000 employees across 40 countries and our global network of partners, LTM — a Larsen & Toubro company — owns business outcomes for our clients, helping them not just outperform the market, but to Outcreate it. Please also note that neither LTM nor any of its authorized recruitment agencies/partners charge any candidate registration fee or any other fees from talent (candidates) towards appearing for an interview or securing employment/internship. Candidates shall be solely responsible for verifying the credentials of any agency/consultant that claims to be working with LTM for recruitment. Please note that anyone who relies on the representations made by fraudulent employment agencies does so at their own risk, and LTM disclaims any liability in case of loss or damage suffered as a consequence of the same. Recruitment Fraud Alert - https://www.ltimindtree.com/recruitment-fraud-alert/