Senior Data Warehouse Architect / Senior Developer

Must Have:

• SSAS
• Data Warehouse
• SQL
• Azure

Key Responsibilities: As a part of the firm s IT Application Development and Support department, responsibilities will include:

Participate in the architectural discussions, design and development of the cloud migration project

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 exist 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

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 Warehouse Technologies: Azure Synapse Analytics, Data Lake, pipelines, Azure SQL Pool

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

Agile development methods and Dev/Ops CI/CD (Preferred)