Associate Principal - Architecture

Role descriptionA 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 integrityCore ResponsibilitiesArchitectural Design Develop endtoend data warehouse structures within Microsoft SQL ServerData Modeling ETL Design logicalphysical data models and robust ETLELT workflowsPerformance Optimization Tune SQL queries indexes and stored procedures to ensure fast data retrievalGovernance Security Define data standards security policies and documentation to ensure complianceCollaboration Work with data engineers analysts and business stakeholders to translate needs into technical specificationsKey QualificationsExperience 10 years in data warehousing data engineering or solution architectureTechnical Expertise Expertlevel SQL Server TSQL and query plan analysis