Profile:
We’re growing, we’re integrating, and we’re modernising. You’ll join a collaborative data warehousing team at a pivotal moment, working across both ongoing business initiatives and a major company‑wide integration programme. Your expertise in SSIS , T‑SQL , and modern data engineering practices will directly shape how we ingest, transform, and deliver data across the organisation.
What You’ll Be Doing:
- Analysis & Design - Partner with Data Analysts to map source systems, refine data models, and design SSIS packages and database schemas.
- ETL Development & Integration - Redevelop and uplift existing ETL pipelines to bring multiple systems together into a unified warehouse.
- T‑SQL Engineering - Write and optimise complex scripts, stored procedures, and transformations for high‑performance data processing.
- Performance Optimisation - Ensure our warehouse is stable, scalable, and ready for increasing data volumes.
- Testing & Validation - Validate ETL accuracy, troubleshoot data quality issues, and support end‑to‑end testing.
- Documentation - Keep our technical documentation clear, complete, and future‑proof.
- Collaboration - Work closely with analysts, developers, SMEs, and business stakeholders to deliver high‑value data solutions.
What You Bring: Required
- 3+ years working in operational data teams.
- Degree in Computer Science, IT, or equivalent experience.
- Hands‑on experience designing and delivering data warehouse and ETL solutions.
- Strong SSIS and SQL Server development background.
- Deep knowledge of T‑SQL, stored procedures, indexing, and query optimisation.
- Experience scripting within SSIS (PowerShell, C#, Python).
- Solid understanding of data warehousing concepts and best practices.
- Strong analytical, problem‑solving, and communication skills.
- High attention to detail and commitment to data quality.
Preferred
- Exposure to data warehouse uplift or modernisation projects.
- Experience working in organisations undergoing mergers or acquisitions.
- Familiarity with WhereScape Red .
- Knowledge of data modelling, data architecture, governance, and data quality frameworks.
Why This Role Matters:
You won’t be maintaining someone else’s legacy system, you’ll be shaping the future of how data flows across a newly integrated organisation. Your work will influence reporting, analytics, decision‑making, and the long‑term data strategy.
If you want a role where you can build, improve, collaborate, and genuinely make an impact , this is it.
