Data Warehouse Developer (SQL/SSIS)
Posted 1 day ago by GIOS Technology
£34 Per hour
Undetermined
Hybrid
London Area, United Kingdom
Summary: The Data Warehouse Developer (SQL/SSIS) role involves developing and maintaining data warehousing solutions with a focus on SQL Server and SSIS. The position requires proven expertise in ETL processes and data quality assurance, with a strong emphasis on creating technical specifications and documentation. The developer will work in a hybrid environment, spending three days in the London office. A solid understanding of data warehousing methodologies, including Kimball and Inmon, is essential for success in this role.
Key Responsibilities:
- Develop and maintain data warehousing solutions using SQL Server and SSIS.
- Design and implement ETL processes, including fact and dimension tables.
- Create comprehensive technical specifications and process documentation.
- Ensure data quality and integrity across integrated systems.
- Optimize SQL queries and performance tuning.
Key Skills:
- SQL Server Integration Services (SSIS)
- SQL Development
- T-SQL
- Data Warehousing (Kimball, Inmon approaches, Fact & Dimension Tables, SCDs)
- Data Quality & Integrity
- Performance Tuning & Optimization (SQL Query Optimization, Stored Procedures, Functions, Execution Plans)
Salary (Rate): £33.75/hr
City: London
Country: United Kingdom
Working Arrangements: hybrid
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
We are hiring for Data Warehouse Developer (SQL/SSIS) Location : Hybrid - 3 Days in London Office Proven experience as an SSIS/SQL Developer with a strong portfolio of successful projects. Expert-level knowledge of SQL Server and T-SQL Extensive experience with data warehousing concepts and ETL processes, including design of fact and dimension tables. Solid familiarity with database design and development principles and should be able to create comprehensive technical specifications and process documentation. Ensure the highest levels of data quality and integrity across all integrated systems. Data Warehousing (Kimball, Inmon approaches, Fact & Dimension Tables, SCDs) Key Skills : SQL Server Integration Services (SSIS) / SQL Development / T-SQL / Data Warehousing (Kimball, Inmon approaches, Fact & Dimension Tables, SCDs) / Data Quality & Integrity / Performance Tuning & Optimization (SQL Query Optimization, Stored Procedures, Functions, Execution Plans)