Senior MSBI Data Warehouse Architect / Senior Developer
Location: NYC only(Locals)
Type: Contract


Key Responsibilities:

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

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



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



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)




Reference : Senior MSBI Data Warehouse Architect / Senior Developer jobs