2 of 2 SQL Server Integration Services Jobs in the East of England

nonclustered index strategy, deduplication, parallel-run cutovers, schema migration, performance tuning of high-impact production queries. · Driving the in-flight ETL replatform — replacing legacy SSIS jobs with a table-driven, parallel-run E-L-T framework, removing Linked Server dependencies, eliminating the BI-server database-restore … Kimball-style dimensional modelling (fact/dim schemas), incremental and full-load patterns, slowly changing dimensions, ETL/ELT framework design. · Production ETL development — SSIS for understanding/decommissioning legacy work, plus modern alternatives (custom T-SQL frameworks, ADF, dbt, or equivalent) for new build. · Operational SQL ...

Organisation: Cranfield University Faculty or Department: IT Services Based at: Cranfield Campus, Cranfield, Bedfordshire Hours of work: 37 hours per week, normally worked Monday to Friday. Flexible working will be considered. Contract type: Permanent Salary: Full time starting salary is normally in the range … will also lead the technical preparation for mandatory HESA and Office for Students regulatory returns. About You You will have solid experience with Microsoft SSIS/PowerBI and, ideally, the SAP Business Objects platform. This will be coupled with strong technical knowledge of relational database design, dimensional modelling, and SQL. ...