Job Description
- Our client is looking for a hands-on Datawarehouse Solution Designer/ developer to join their Data team on a long term contract.
- You will analyse the existing landscape, design and build the future data warehouse.
Responsibilities:
- Develop and support Data warehouse platform using AWS
- Support current and extend data models and sources into the data warehouse;
- Design, develop, monitor and tune data loads and queries
- Design and develop ETL jobs in Talend, SSIS or similar ETL tools
- Perform complex Data analysis using T-SQL and DAX;
- Document detailed designs based on business requirements;
- Experience in enterprise information management architecture and understanding of various Data segments i.e. Architecture, Integration, Governance, Quality, Meta Data and Master Data Management.
- Design, built and deployed data models for Enterprise Data Warehouse. Solid research and complex problem-solving skills in BI system design.
- Extensive experience of BI Architecture and Solution Design with complex source systems and good working experience with state-of-the-art BI technologies and platforms
- Demonstrated experience working on Data Warehouse and Analytics platforms
- Understanding of Data Warehousing concepts, architecture, software, data modelling techniques and implementation
- Strong conceptual and analytical data skills and proven ability to resolve complex data problems using innovative technology solutions
- Good verbal and written communication skills with technical and non-technical audiences
- At least 5 years’ experience in developing and tuning SQL Server (stored procedures, functions and views, SSIS package creation and maintenance, ETL concepts, data modelling)
- Experience with AWS & On Prem architectures