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
Source: http://jobrealtime.com/jobs/technology/senior-msbi-data-warehouse-architect-senior-developer_i19076
Jobs Real Time 