Data Transformation Specialist

1 week ago


Swindon, Swindon, United Kingdom The Openwork Partnership Full time
About the Role

We are seeking a highly skilled Data Transformation Specialist to join our dynamic Data Engineering Team at The Openwork Partnership. As a key member of our team, you will play a crucial role in designing and developing pipelines for data transformation into our Azure Synapse Data Lake, Azure SQL Data Warehouse, and Power BI.

Key Responsibilities
  • Support the design and maintenance of the Azure SQL/Synapse metadata framework for Data Engineering.
  • Develop Azure Synapse pipelines to load source data to the Data Lake and provide data to the Report layer(s) Power BI.
  • Perform data transformations as per mapping documents.
  • Develop Azure Synapse pipelines for audit capture, error, and exception handling.
  • Automate Azure Synapse pipelines and Report Layer jobs using scheduling tools.
  • Challenge and seek clarification on data mappings/rules via Data Analysts.
  • Challenge and seek clarification on data transformation logic/business rules via Business Analysts.
  • Ensure quality is embedded and provable at every stage of code development.
  • Provide design input for all technical deliverables.
  • Create and maintain Technical Specifications.
  • Support the data office and other data consumers within the organisation.
  • Data extracts from Legacy systems.
  • Migration of data and processes from legacy systems to Azure Synapse.
  • Identify improvements to existing processes and helping to migrate data and modelling into Azure Synapse.
Requirements
  • Experience with SQL Server (TSQL).
  • Experience in Agile working.
  • Experience with Cloud services (Microsoft Azure preferably).
  • SSIS, SSRS.
  • SQL Server 2012 and above esp. SSIS/SSRS 2017 (SSIS Catalog).
  • Strong TSQL.
  • Data modelling fundamentals.
  • Power BI.
  • Data Warehouse and Report Layer design.
  • Strong Agile Practitioner.
  • Strong SQL/database querying skills.
  • Microsoft BI (full stack) expertise (desirable).
  • Knowledge of Azure portal and Azure services (Desirable).
  • Knowledge of Agile working and Azure DevOps.
  • Experience of D365.
  • Experience of data testing.
What We Offer

We offer a dynamic and fast-paced work environment with opportunities for growth and development. Our company values individuality and diversity, and we are committed to building an inclusive culture that recognizes and celebrates our colleagues' unique differences and identities.

We believe that everyone can make a difference, and we strive to create a work environment that balances a successful career with personal commitments and interests outside of work. We offer a range of benefits, including salary, bonus scheme, pension scheme, critical illness cover, income protection, death in service, and flexible benefits such as private medical insurance and dental insurance.



  • Swindon, Swindon, United Kingdom Primus Connect Full time

    About the RoleWe are seeking a highly skilled Data Transformation Specialist to join our Primus Connect team. As a key member of our Data Engineering team, you will play a crucial role in designing and maintaining our Azure SQL/Synapse metadata framework.Key ResponsibilitiesDesign and develop Azure Synapse pipelines to load source data to the Data Lake and...


  • Swindon, Swindon, United Kingdom Primus Connect Full time

    About the RoleWe are seeking a highly skilled Data Transformation Specialist to join our Primus Connect team. As a key member of our Data Engineering team, you will play a crucial role in designing and maintaining our Azure SQL/Synapse metadata framework.Key ResponsibilitiesDesign and develop Azure Synapse pipelines to load source data to the Data Lake and...


  • Swindon, Swindon, United Kingdom Primus Connect Full time

    About Primus ConnectWe are a leading organisation in the industry, committed to delivering exceptional results and driving innovation. Our team is passionate about leveraging data to drive business growth and improvement.Job SummaryWe are seeking a highly skilled Data Engineer to join our multi-function Data Engineering team. As a key member of our team, you...


  • Swindon, Swindon, United Kingdom Primus Connect Full time

    About Primus ConnectWe are a leading organisation in the industry, committed to delivering exceptional results and driving innovation. Our team is passionate about leveraging data to drive business growth and improvement.Job SummaryWe are seeking a highly skilled Data Engineer to join our multi-function Data Engineering team. As a key member of our team, you...


  • Swindon, Swindon, United Kingdom Primus Connect Full time

    About the RoleWe are seeking a highly skilled Data Engineer to join our multi-function team at Primus Connect, a top organisation listed in the 'Best 100 Large Companies' to work for. As a Data Engineer, you will play a crucial role in developing and contributing to our future strategic ambitions.Key ResponsibilitiesDesign and Maintain Azure SQL / Synapse...


  • Swindon, Swindon, United Kingdom Primus Connect Full time

    About the RoleWe are seeking a highly skilled Data Engineer to join our multi-function team at Primus Connect, a top organisation listed in the 'Best 100 Large Companies' to work for. As a Data Engineer, you will play a crucial role in developing and contributing to our future strategic ambitions.Key ResponsibilitiesDesign and Maintain Azure SQL / Synapse...


  • Swindon, Swindon, United Kingdom Transformation Unit Full time

    Job Title: Transformation Unit Seeks Experienced Physiotherapist as Team LeadJob Summary:We are seeking an experienced physiotherapist to join our team as a team lead. The successful candidate will be responsible for managing a locality physiotherapy team, leading a clinical area, and supporting the professional lead with service development.Main...


  • Swindon, Swindon, United Kingdom Transformation Unit Full time

    Job Title: Transformation Unit Seeks Experienced Physiotherapist as Team LeadJob Summary:We are seeking an experienced physiotherapist to join our team as a team lead. The successful candidate will be responsible for managing a locality physiotherapy team, leading a clinical area, and supporting the professional lead with service development.Main...


  • Swindon, Swindon, United Kingdom Transformation Unit Full time

    Job DescriptionJob Title: Physiotherapist Team LeadJob Reference: Not ApplicableLocation: Not ApplicableJob Type: Full-timeSalary: Not ApplicableHours: Not ApplicableAbout the RoleWe are seeking an experienced physiotherapist to join our team as a team lead. As a team lead, you will be responsible for managing a locality physiotherapy team, leading a...


  • Swindon, Swindon, United Kingdom Transformation Unit Full time

    Job DescriptionJob Title: Physiotherapist Team LeadJob Reference: Not ApplicableLocation: Not ApplicableJob Type: Full-timeSalary: Not ApplicableHours: Not ApplicableAbout the RoleWe are seeking an experienced physiotherapist to join our team as a team lead. As a team lead, you will be responsible for managing a locality physiotherapy team, leading a...


  • Swindon, Swindon, United Kingdom Recruitment Partnership (Bristol) Ltd (RP) Full time

    Job Summary:We are seeking a highly skilled Business Transformation Specialist to lead our Investment client in the South West on a high-profile and large-scale programme.About the Role:This is an exciting opportunity for a seasoned Change Management Expert to join our team at Recruitment Partnership (Bristol) Ltd (RP) and work closely with our client to...


  • Swindon, Swindon, United Kingdom Recruitment Partnership (Bristol) Ltd (RP) Full time

    Job Summary:We are seeking a highly skilled Business Transformation Specialist to lead a high-profile investment programme in the South West region. As a key member of our team at Recruitment Partnership (Bristol) Ltd (RP), you will be responsible for driving business change and managing stakeholders effectively.Key Responsibilities:Lead a large-scale...


  • Swindon, Swindon, United Kingdom UK Shared Business Services Ltd Full time

    Lean Transformation Specialist Partnerships & Change Hybrid Working Options Band E: £40,175 - £50,677 DOE UK Shared Business Services Ltd (UKSBS) is a public sector shared service organization dedicated to delivering exceptional HR, Payroll, Finance, Procurement, and IT services to our partners. We take pride in our role in helping our partners...


  • Swindon, Swindon, United Kingdom Recruitment Partnership (Bristol) Ltd (RP) Full time

    Job OverviewWe are seeking a highly skilled Business Transformation Specialist to join our team at Recruitment Partnership (Bristol) Ltd (RP) in a key role that will drive business change and lead a large-scale investment programme.Key Responsibilities:Lead business change initiatives to drive growth and improvementDevelop and maintain strong relationships...


  • Swindon, Swindon, United Kingdom RWE AG Full time

    RWE AG: A Leader in Energy TransformationAbout the RoleWe are seeking a highly motivated and talented Electrical Engineer Trainee to join our team at RWE AG. As a Trainee, you will have the opportunity to work on a wide range of projects and gain valuable experience in the field of energy transformation.Key ResponsibilitiesParticipate in project development...


  • Swindon, Swindon, United Kingdom Swindon Borough Council Full time

    About Swindon Borough Council Swindon Borough Council is dedicated to making our town a better place for everyone. We strive to deliver high-quality public services, efficient processes, and an improved quality of life for all residents and businesses. Your Role: Housing Data Management We are seeking a meticulous and detail-oriented individual to join our...


  • Swindon, Swindon, United Kingdom Swindon Borough Council Full time

    About Swindon Borough Council Swindon Borough Council is dedicated to making our town a better place for everyone. We strive to deliver high-quality public services, efficient processes, and an improved quality of life for all residents and businesses. Your Role: Housing Data Management We are seeking a meticulous and detail-oriented individual to join our...


  • Swindon, Swindon, United Kingdom Network Rail Full time

    **Job Summary**The role of Performance Data Quality Specialist at Network Rail involves ensuring the accuracy and reliability of performance data across the business.**Key Responsibilities**Develop and implement audit protocols to measure data quality and identify areas for improvement.Conduct quality checks and maintain the quality of delay attribution in...


  • Swindon, Swindon, United Kingdom Network Rail Full time

    **Job Summary**The role of Performance Data Quality Specialist at Network Rail involves ensuring the accuracy and reliability of performance data across the business.**Key Responsibilities**Develop and implement audit protocols to measure data quality and identify areas for improvement.Conduct quality checks and maintain the quality of delay attribution in...


  • Swindon, Swindon, United Kingdom Nationwide Full time

    About the RoleWe are seeking a highly motivated and experienced Digital Transformation Consultant to join our team at Nationwide. As a key member of our Digital Strategy and Transformation Team, you will play a critical role in shaping and delivering journeys that enhance our customers' experiences and drive business growth.Key ResponsibilitiesWork with...