Current jobs related to Data Transformation Specialist - Swindon, Swindon - The Openwork Partnership


  • Swindon, Swindon, United Kingdom The Openwork Partnership Full time

    The OpportunityAs a Data Transformation Specialist at The Openwork Partnership, you will be part of a dynamic and fast-paced team that is shaping the future of data engineering. We are seeking an experienced professional to join our Azure Synapse team and contribute to the design and development of pipelines for data transformation into the Azure Synapse...


  • Swindon, Swindon, United Kingdom The Openwork Partnership Full time

    About the RoleWe are seeking a skilled Data Transformation Engineer to join our dynamic Data Engineering Team at The Openwork Partnership. This is an exciting opportunity for someone with a passion for data transformation and a desire to contribute to our future strategic ambitions.Key ResponsibilitiesDesign and maintain the Azure SQL/Synapse metadata...


  • Swindon, Swindon, United Kingdom The Openwork Partnership Full time

    The OpportunityAs a Data Transformation Engineer at The Openwork Partnership, you will be an integral part of our multi-function Data Engineering Team. The team owns the Azure Synapse service and designs and develops pipelines for data transformation into the Azure Synapse Data Lake, Azure SQL Data Warehouse, and out to Power BI. Additionally, this role will...


  • Swindon, Swindon, United Kingdom The Openwork Partnership Full time

    The OpportunityWe are seeking a highly skilled Data Transformation Engineer to join our dynamic Data Engineering Team. As a key member of the team, you will play a crucial role in designing and developing pipelines for data transformation into Azure Synapse Data Lake, Azure SQL Data Warehouse, and Power BI.Key ResponsibilitiesDesign and maintain the Azure...


  • Swindon, Swindon, United Kingdom The Openwork Partnership Full time

    The OpportunityWe are seeking a highly skilled Data Transformation Engineer to join our dynamic Data Engineering Team. As a key member of the team, you will play a crucial role in designing and developing pipelines for data transformation into Azure Synapse Data Lake, Azure SQL Data Warehouse, and Power BI.Key ResponsibilitiesDesign and maintain the Azure...


  • Swindon, Swindon, United Kingdom Primus Connect Full time

    Join a Talented Team at Primus ConnectAre you ready to be an integral part of a multi-function Data Engineering team for a top organisation listed in the 'Best 100 Large Companies' to work for? This is a great role for someone with experience in Data Transformation, keen to develop and contribute to our future strategic ambitions. £60,000 + 15% Bonus Hybrid...


  • Swindon, Swindon, United Kingdom Primus Connect Full time

    Join a Talented Team at Primus ConnectAre you ready to be an integral part of a multi-function Data Engineering team for a top organisation listed in the 'Best 100 Large Companies' to work for? This is a great role for someone with experience in Data Transformation, keen to develop and contribute to our future strategic ambitions. £60,000 + 15% Bonus Hybrid...


  • Swindon, Swindon, United Kingdom The Openwork Partnership Full time

    The OpportunityAs a Data Transformation Engineer at The Openwork Partnership, you will be part of a dynamic and fast-paced team that is passionate about delivering exceptional results. We are seeking a skilled professional to join our Data Engineering team, responsible for designing and developing pipelines for data transformation into Azure Synapse Data...


  • Swindon, Swindon, United Kingdom newscientist - Jobboard Full time

    Job DescriptionAs a Data Transformation Engineer, you will be responsible for designing and developing pipelines for data transformation into the Azure Synapse Data Lake, Azure SQL Data Warehouse, and out to Power BI. This role will also support legacy data processes (SSIS / SSRS) and data migrations as required.This is a great opportunity for someone with...


  • Swindon, Swindon, United Kingdom Primus Connect Full time

    Data Engineer Role at Primus ConnectWe are seeking a skilled Data Engineer to join our 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 Responsibilities:Migrate data from Synapse to...


  • Swindon, Swindon, United Kingdom Primus Connect Full time

    Data Engineer Role at Primus ConnectWe are seeking a skilled Data Engineer to join our 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 Responsibilities:Migrate data from Synapse to...


  • Swindon, Swindon, United Kingdom The Openwork Partnership Full time

    The OpportunityAs a Data Transformation Engineer at The Openwork Partnership, you will be an integral part of our multi-function Data Engineering Team. The team owns the Azure Synapse service and designs and develops pipelines for data transformation into the Azure Synapse Data Lake, Azure SQL Data Warehouse, and out to Power BI. Additionally, this role will...


  • Swindon, Swindon, United Kingdom newscientist - Jobboard Full time

    Job Title: Data Transformation EngineerWe are seeking a highly skilled Data Transformation Engineer to join our Data Engineering Team. As a key member of the team, you will be responsible for designing and developing pipelines for data transformation into the Azure Synapse Data Lake, Azure SQL Data Warehouse, and out to Power BI.Key Responsibilities:Design...


  • Swindon, Swindon, United Kingdom Openwork Full time

    About the RoleWe are seeking a highly skilled Data Transformation Engineer to join our Data Engineering Team at Openwork. As a key member of the team, you will be responsible for designing and developing pipelines for data transformation into Azure Synapse Data Lake, Azure SQL Data Warehouse, and out to Power BI.Key ResponsibilitiesDesign and maintain the...


  • Swindon, Swindon, United Kingdom Openwork Full time

    About the RoleWe are seeking a highly skilled Data Transformation Engineer to join our Data Engineering Team at Openwork. As a key member of the team, you will be responsible for designing and developing pipelines for data transformation into Azure Synapse Data Lake, Azure SQL Data Warehouse, and out to Power BI.Key ResponsibilitiesDesign and maintain the...


  • Swindon, Swindon, United Kingdom Transformation Unit Full time

    Job OverviewTransformation Unit is seeking a skilled End of Life Nurse Specialist to join our team. As a key member of our Community End of Life Team, you will provide high-quality care and support to patients at the end of their lives.The successful candidate will work collaboratively with primary and social care colleagues to deliver a seamless end of life...


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

    Lean Transformation SpecialistUK Shared Business Services Ltd is seeking a Lean Transformation Specialist to join our dynamic team. As a key member of our Partnerships & Change directorate, you will play a critical role in driving our lean transformation journey.The successful candidate will be responsible for facilitating Value Stream Mapping initiatives...


  • Swindon, Swindon, United Kingdom Nationwide Full time

    Job SummaryWe are seeking a skilled Digital Transformation Specialist to join our team at Nationwide, focusing on the Oracle Cloud Application known as PeopleCloud.About the RoleThis exciting opportunity involves providing expert support and guidance to HR Users and Employees in resolving day-to-day queries and issues. You will identify, manage, and resolve...


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

    Lean Transformation SpecialistUK Shared Business Services Ltd is seeking a skilled Lean Transformation Specialist to join our dynamic team. As a key member of our Partnerships & Change directorate, you will play a critical role in driving operational excellence and continuous improvement across the organisation.The successful candidate will have a strong...


  • Swindon, Swindon, United Kingdom Primus Connect Full time

    Unlock Your Potential as a Data EngineerAre you a skilled Data Engineer looking to take your career to the next level? Do you have a passion for working with Azure Data Services, SQL Server, and Power BI? We're seeking a talented individual to join our multi-function Data Engineering team at Primus Connect, a top organisation listed in the 'Best 100 Large...

Data Transformation Specialist

2 months ago


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

We are seeking a highly skilled Data Transformation Engineer 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 Azure Synapse Data Lake, Azure SQL Data Warehouse, and Power BI.

Key Responsibilities
  • Design and maintain 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 competitive salary up to £60,000, a bonus scheme with on-target bonus of 15%, a pension scheme with employer matching, critical illness cover, income protection, death in service, and a range of flexible benefits including private medical insurance, dental insurance, and more.

We are a dynamic, fast-paced, and growing business with huge ambition. We invest heavily in our colleagues, striving to give them the platform to develop personally and professionally. We are proud of our culture, which values individuality and respects differences. We believe everyone can make a difference, and we are committed to building an inclusive culture and environment.