SQL Server Data Warehouse Architect

About CompanyDroisys is an innovation technology company focused on helping companies accelerate their digital initiatives from strategy and planning through execution. We leverage deep technical expertise, Agile methodologies, and data-driven intelligence to modernize systems of engagement and simplify human/tech interaction. Amazing things happen when we work in environments where everyone feels a true sense of belonging and when candidates have the requisite skills and opportunities to succeed. At Droisys, we invest in our talent and support career growth, and we are always on the lookout for amazing talent who can contribute to our growth by delivering top results for our clients. Join us to challenge yourself and accomplish work that matters .SQL Server Data Warehouse ArchitectRate : $65/hr on c2c Location: Charlotte - North Carolina/HybridWe are looking for an experienced SQL Server Data Warehouse Architect to design and optimize enterprise-level data warehouse solutions. The ideal candidate should have strong expertise in SQL Server, dimensional data modeling, ETL/ELT processes, query optimization, indexing strategies, and performance tuning.Key Responsibilities:• Design scalable data warehouse architectures using Microsoft SQL Server• Develop logical and physical dimensional data models• Build and optimize ETL/ELT workflows and data pipelines• Tune SQL queries, stored procedures, and indexing for high performance• Define data governance, security standards, and documentation• Collaborate with business and technical teams to deliver scalable solutionsRequired Skills:• MS SQL Server• T-SQL & Query Performance Tuning• Dimensional Data Modeling• ETL Concepts• ER StudioGood to Have:• ERWIN• Enterprise Data Governance experienceDroisys is an equal opportunity employer. We do not discriminate based on race, religion, color, national origin, gender, gender expression, sexual orientation, age, marital status, veteran status, disability status or any other characteristic protected by law. Droisys believes in diversity, inclusion, and belonging, and we are committed to fostering a diverse work environment.