SQL Server Datawarehouse Architect

Role: SQL Server Datawarehouse Architect
Location: Charlotte, NC (Remote)
Duration: 12 Months

 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 modelling and tools like ER/Studio or Erwin.

Questions to check candidate’s experience.

• Difference between Clustered Index and non-clustered index
• Difference between Clustering Key and Primary Key
• How many non-clustered index we can have -> what are the challenges of having non-clustered index
• If I created index, what do I generally speed up? How will it differ between insert and select statement
• What does it mean if I have a Heap
• Benefits of a table with no indexes (Heap)
• Red flags on a query when you see - how can you make it better
• Clustered Index Scan vs Clustered Index seek
• Covering Index and Include Column