Data Warehouse Architect Jobs

Education and professional experience Required: Bachelor's degree in Computer Science, Information Systems, or another four-year degree with IT OR equivalent experience. Master's degree preferred. Overall 15+ years in Microsoft technology SQL Server, SSIS, SSAS 10+ years of experience delivering Data Warehouse solutions 5+ years serving as a Data Warehouse architect with a demonstrated track record of implementing highly scalable and available solutions into a highly transactional production setting Data Warehousing & ETL o Significant data warehouse experience from planning, to design, to implementation. o Experience of designing strategies for ETL audit, load balance, exception handling and high data volumes. Hands on experience in all areas of SQL Server development including stored procedures, functions, and triggers. Proven expertise in Data warehouse methodologies as well as extensive knowledge of OLTP/OLAP technologies. Ability to design, organize, and implement module, perform system testing, Plan and automate tasks to maintain existing system Ability to research and trouble-shoot application problems Highly motivated team player with strong communication and interpersonal skills Business analysis, especially business requirements gathering Proficient In: Relational Database Concepts Data Warehouse Concepts Dimensional Data Modeling and Notation Microsoft SSIS ETL Processes OLAP Cube Development experience MDX experience is preferred Microsoft Team Foundation Server / Git Application Performance Tuning and Optimization Data Warehouse Technologies: Azure Synapse Analytics, Data Lake, pipelines Agile development methods and Dev/Ops CI/CD (Preferred)