Data Analyst | ETL | Data Warehouse | T-SQL | SSIS | Bedford

DATA ANALYST | ETL | DATA WAREHOUSE | T-SQL | SSIS | BEDFORD

Data Analyst with proven experience of ETL, Data Warehouse and/or data migration needed for a 3 month contract based in Bedford.

EXPERIENCE NEEDED

- Database design and coding skills with SQL Server
- 5+ years experience of ETL, Data Warehouse and/or data migration

RESPONSIBILITY

- Built the ETL processes using SSIS and T-SQL
- 5+ years experience with SSIS development
- Design and build staging tables using SQL Server
- Modelling - contribute towards the delivery of logical and physical data models
- Collaborate with the business to produce mapping of data from Legacy system
- Perform data profiling of Legacy data either manually or using a profiling tool
- Document and review technical ETL specification's
- Supporting workshops to discuss data approach, mapping, conversion and validation
- Ability to work and troubleshoot issues raised by the SI on proposed data model

EXPECTED DELIVERY

- Software for data extraction, Enrichment and validation processes
- Refined data placed in a logical structure within staging tables
- Detailed design documentation for ETL process
- Logical and physical data models Mapping tables
- Data quality rules and Data transformation rules for cleansing process (transpose)