MSBI Data Warehouse Architect

Skills

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 Significant data warehouse experience from planning to design to implementation. 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

Description

The Data Warehouse Data Architect / Developer defines and designs both solution and application architecture for the enhancing capabilities of existing Data Warehouse technologies. This role comprises 50% architectural and 50% hands-on. This position is strictly for NYC location.

Responsibilities

• Rollup sleeves to analyze and fix production issues
• Analyze and assess existing platform for maintainability, reliability, scalability, security, and performance.
• Define standards for the design and analysis of load processes, data flows and data models.
• Lead the design, build, and deployment of ETL (extract, transform, and load) processes for large data sets.
• Review the existing platform architecture and come up with recommendations to solve the current performance issues which exists in cube processing, Data imports, Drill throughs.
• Facilitate code reviews, software design sessions and architectural reviews.
• Participate in technical advisory roles, as required
• Interact with business users, as required.
• Provide ad hoc support in troubleshooting highly complex production issues as they arise.
• Conduct root cause analysis and performance tuning for data load processes.
• Ability to problem solve, recommend, and develop technical solutions.

Educational Requirements

• 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)