Senior ETL Data Warehouse ArchitectOnsite Job, Need Locals

Role: Senior Data Warehouse Architect, Location: NYC NY (Onsite THREE DAYS A WEEK). Duration: Long Term Contract Job Description: The Data Warehouse Data Architect / Developer defines and designs both solution and application architecture for the enhancing capabilities of an existing Data Warehouse technologies. This role comprises of 50% architectural and 50% hands on. 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.

• Bachelor's degree in Computer Science, Information Systems, or another four-year degree with significant IS experience OR equivalent experience. Master's degree preferred
• 10+ years of experience delivering Data Warehouse solutions
• 10+ years in Microsoft technology SQL Server, SSIS, SSAS, C#, .Net technologies
• 4+ 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

• Relational Database Concepts
• Data Warehouse Concepts
• Dimensional Data Modeling and Notation
• Microsoft SSIS
• ETL Processes
• OLAP Cube Development using MDX
• Microsoft Tabular Models and SSAS Cubes
• Microsoft Team Foundation Server / Git
• Application Performance Tuning and Optimization
• Data Warehouse Technologies: Azure Synapse Analytics
• Agile development methods and Dev/Ops CI/CD (Preferred)
• Jira (Preferred)