Data Transformation Engineer

3 months ago


Swindon, United Kingdom The Openwork Partnership Full time

The opportunity

As Data Transformation Engineer , you'll be an integral part of the multi-function Data Engineering Team. The team own the Azure Synapse service and design and develop pipelines for data transformation into the Azure Synapse Data Lake, Azure SQL Data Warehouse and out to Power BI. Additionally, this role will support legacy data processes (SSIS / SSRS) and data migrations as required.

This is a great role for someone with some Data Transformation experience, keen to develop and contribute to our future strategic ambitions. This is a hybrid role with 2 days per week in our Swindon office.  The benefits:
•Salary - up to £60,000•Bonus scheme - on target bonus - 15%
•Pension scheme - contribute up to 5% of your salary and Openwork will match you and put in an extra 5%
•Critical illness cover
•Income protection - 1x salary
•Death in service - 4x salary
•25 days holiday + bank holidays, with the opportunity to buy up to an additional 10 days
•A range of other flexible benefits to include private medical insurance, dental insurance and much more. Key Accountabilities: Support the design and maintain the Azure SQL / Synapse meta data 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

What will you need to succeed?

Qualifications/Experience/Knowledge: 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

Skills and Competencies:

Interested in Data Technologies, Microsoft Azure, and DevOps Eager to learn and expand knowledge Adaptable to change Delivery focussed and self-motivated Positive outcomes focussed attitude Attention to detail Analytical skills Ability to apply judgement to situations requiring balance between time and accuracy Good communication skills

Why us?

We're a dynamic, fast paced, and growing business with huge ambition. This is all made possible by the brilliant people who are part of The Openwork Partnership family. We're investing heavily in our colleagues, continuously striving to give them the platform to develop personally and professionally and reach their full potential.

We’re also very proud of our culture, as one of the Best 100 Large Companies to work for in 2022. The Openwork Partnership values, and respects individuality and we are committed to building an inclusive culture and environment which truly recognises and celebrates our colleague’s individual differences and identities – just like our financial advice, for us, it’s personal. We believe everyone can make a difference and your race, religion, disability, and gender will never be a barrier. At Openwork, we have a strong ethic of care for each other where you can balance a successful career with your commitments and interests outside of work. We believe that you will bring your best self to work if you are trusted to choose when, where and how you do it.



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


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


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


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


  • 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% BonusHybrid -...


  • 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% BonusHybrid -...


  • 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

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


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


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


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


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