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 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 and respects individuality, and we are committed to building an inclusive environment that truly recognises and celebrates our colleagues' individual differences and identities.

  • Data Transformation Specialist

    2 weeks ago

    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...

  • Data Transformation Specialist

    2 weeks ago

    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...

  • Data Transformation Specialist

    2 weeks ago

    Swindon, Swindon, United Kingdom The Openwork Partnership Full time

    About the RoleWe 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...

  • Data Transformation Specialist

    2 weeks ago

    Swindon, Swindon, United Kingdom The Openwork Partnership Full time

    About the RoleWe 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...

  • Data Transformation Specialist

    4 weeks ago

    Swindon, Swindon, United Kingdom The Openwork Partnership Full time

    About the RoleWe 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...

  • Data Transformation Specialist

    1 week ago

    Swindon, Swindon, United Kingdom Primus Connect Full time

    Unlock Your Potential as a Data EngineerAt Primus Connect, we're seeking a talented Data Engineer to join our dynamic team. As a key member of our Data Engineering team, you'll play a crucial role in shaping our data transformation strategy and driving business growth.Key Responsibilities:Design and implement data pipelines using Azure Data Services and...

  • Data Transformation Specialist

    1 week ago

    Swindon, Swindon, United Kingdom Primus Connect Full time

    Unlock Your Potential as a Data EngineerAt Primus Connect, we're seeking a talented Data Engineer to join our dynamic team. As a key member of our Data Engineering team, you'll play a crucial role in shaping our data transformation strategy and driving business growth.Key Responsibilities:Design and implement data pipelines using Azure Data Services and...

  • Data Transformation Specialist

    2 weeks ago

    Swindon, Swindon, United Kingdom The Openwork Partnership Full time

    About the RoleWe 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...

  • Data Transformation Specialist

    2 weeks ago

    Swindon, Swindon, United Kingdom The Openwork Partnership Full time

    About the RoleWe 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...

  • Data Transformation Specialist

    1 week ago

    Swindon, Swindon, United Kingdom Primus Connect Full time

    Unlock Your Potential as a Data EngineerAt Primus Connect, we're seeking a talented Data Engineer to join our multi-function team. As a key player in our organization, you'll have the opportunity to develop and contribute to our future strategic ambitions.This is an exciting role for someone with experience in data transformation, keen to work with Azure...

  • Data Transformation Specialist

    1 week ago

    Swindon, Swindon, United Kingdom Primus Connect Full time

    Unlock Your Potential as a Data EngineerAt Primus Connect, we're seeking a talented Data Engineer to join our multi-function team. As a key player in our organization, you'll have the opportunity to develop and contribute to our future strategic ambitions.This is an exciting role for someone with experience in data transformation, keen to work with Azure...

  • Data Transformation Specialist

    2 weeks ago

    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...

  • Data Transformation Specialist

    2 weeks ago

    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...

  • Data Transformation Specialist

    4 days ago

    Swindon, Swindon, United Kingdom The Openwork Partnership Full time

    The OpportunityWe are seeking a highly skilled Data Transformation Engineer to join our multi-function 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 ResponsibilitiesSupport the design...

  • Data Transformation Specialist

    4 days ago

    Swindon, Swindon, United Kingdom The Openwork Partnership Full time

    The OpportunityWe are seeking a highly skilled Data Transformation Engineer to join our multi-function 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 ResponsibilitiesSupport the design...

  • Data Transformation Specialist

    2 days ago

    Swindon, Swindon, United Kingdom The Openwork Partnership Full time

    The OpportunityWe are seeking a highly skilled Data Transformation Engineer to join our multi-function 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 ResponsibilitiesSupport the design...

  • Data Transformation Specialist

    2 days ago

    Swindon, Swindon, United Kingdom The Openwork Partnership Full time

    The OpportunityWe are seeking a highly skilled Data Transformation Engineer to join our multi-function 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 ResponsibilitiesSupport the design...

  • Data Transformation Specialist

    7 days ago

    Swindon, Swindon, United Kingdom Primus Connect Full time

    Unlock Your Potential as a Data EngineerAt Primus Connect, we're seeking a talented Data Engineer to join our multi-function team. As a key player in our organization's strategic ambitions, you'll have the opportunity to develop and contribute to our future goals.We're looking for someone with experience in Data Transformation, keen to work with Azure Data...

  • Data Transformation Specialist

    7 days ago

    Swindon, Swindon, United Kingdom Primus Connect Full time

    Unlock Your Potential as a Data EngineerAt Primus Connect, we're seeking a talented Data Engineer to join our multi-function team. As a key player in our organization's strategic ambitions, you'll have the opportunity to develop and contribute to our future goals.We're looking for someone with experience in Data Transformation, keen to work with Azure Data...

  • Data Transformation Specialist

    1 week ago

    Swindon, Swindon, United Kingdom Primus Connect Full time

    Unlock Your Potential as a Data Engineer at Primus ConnectWe are seeking a highly skilled Data Engineer to join our talented 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 designing and maintaining our Azure SQL / Synapse meta data framework, developing...