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

    OverviewThe Openwork Partnership is a dynamic, fast-paced business with huge ambition. We're investing heavily in our colleagues, continuously striving to give them the platform to develop personally and professionally.SalaryWe offer a competitive salary of up to £60,000 per annum, plus a bonus scheme that includes an on-target bonus of 15%.About the...


  • 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

    We are seeking a highly skilled Cloud Data Transformation Specialist to join our multi-function Data Engineering Team.This is a great opportunity for someone with experience in data transformation, keen to develop and contribute to our future strategic ambitions.The successful candidate will be responsible for designing and maintaining the Azure SQL/Synapse...


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

  • Data Tester

    5 months ago


    Swindon, United Kingdom Openwork UK Ltd Full time

    **Hybrid role based in Swindon - 2 days a week required in the office.** As an integral part of the multi-function Data Engineering Team, you will design and use Testing techniques for the development of Openwork data structures that support Warehouse and Reporting output. **The benefits** - Salary - £37,000 - £47,000 - Bonus scheme - on target bonus -...


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

    Swindon Borough CouncilWe're seeking a visionary leader to drive our ambitious digital transformation agenda, aligning technology initiatives with corporate objectives. The ideal candidate will possess a deep technical understanding and strategic mindset, with a proven track record of delivering complex digital initiatives in a local government context.About...


  • Swindon, Swindon, United Kingdom RWE AG Full time

    Unlock Your Potential in Energy TransformationRWE Technology International GmbH is seeking a talented chemical engineer to join our 18-month trainee programme. As a key member of our team, you will have the opportunity to work on various projects, collaborate with international colleagues, and gain valuable experience in the energy sector.Key...


  • Swindon, Swindon, United Kingdom RWE AG Full time

    RWE Technology International GmbHJoin a dynamic team and embark on a challenging career journeyWe are seeking a talented Civil Engineering Graduate to join our team and contribute to the success of our energy transformation projects. As a member of our team, you will have the opportunity to work on various projects, collaborate with international teams, and...


  • Swindon, Swindon, United Kingdom RWE AG Full time

    Transform the Future of EnergyAbout the ProgrammeRWE Technology International GmbH is seeking talented graduates to join our 18-month trainee programme in energy transformation chemical engineering. As a trainee, you will have the opportunity to work in various technology areas, including Hydro & Storage, Hydrogen, Biomass, and Gas, and gain insights into...

  • Data Designer

    5 months ago


    Swindon, United Kingdom Openwork UK Ltd Full time

    As an integral part of the multi-function Data Engineering Team provide data architecture, data design, and data modelling direction for Openwork’s data lake, dimensional model, reporting, and information systems. **The benefits**: - Salary - £50,000 to £65,000 - Bonus scheme - on target bonus 10% - Pension scheme - contribute up to 5% of your salary...


  • Swindon, Swindon, United Kingdom TE Connectivity Full time

    Job OverviewTE Connectivity is seeking a seasoned Operational Excellence Leader to drive the transformation of our manufacturing facility in Swindon, UK. This is an exciting opportunity to unleash your potential and create positive change within our organization.The successful candidate will lead the execution of the TE Operation's Advantage (TEOA) strategy,...


  • Swindon, Swindon, United Kingdom NERC - the Natural Environment Research Council Full time

    **Overview of the Opportunity**We invite applications for early-stage development of cutting-edge research technologies with transformative potential in the biosciences. The selected project lead must be based at a UK research organisation eligible for Biotechnology and Biological Sciences Research Council (BBSRC) funding.The estimated salary for this...


  • Swindon, Swindon, United Kingdom RWE AG Full time

    Transform the Future of EnergyAbout RWE Technology International GmbHWe are seeking a talented Civil Engineer to join our team and contribute to the long-term energy transition. As a key member of our team, you will be responsible for collaborating in the project business throughout the entire project life cycle, gaining insights into various technology...


  • Swindon, United Kingdom Ncounter Technology Recruitment Full time

    Data Strategy ConsultantStep into a pivotal role with a forward-thinking consultancy known for driving transformation and innovation in the public sector. As a Data Strategy Consultant, you'll join a seasoned team with a reputation for flexibility and impact, working on high-stakes projects across Central Government, Defence, Intelligence, and Emergency...


  • Swindon, Swindon, United Kingdom RWE AG Full time

    Unlock Your Potential in Energy TransformationRWE Technology International GmbH is seeking a talented graduate to join our 18-month trainee programme in Energy Transformation Process Engineering. As a trainee, you will have the opportunity to work in various technology areas, including Hydro & Storage, Hydrogen, Biomass, and Gas, and gain insights into other...


  • Swindon, Swindon, United Kingdom RWE AG Full time

    Transform the Future of EnergyRWE Technology International GmbH is seeking talented graduates to join our 18-month trainee programme in Energy Transformation and Industrial Engineering. As a trainee, you will have the opportunity to work in various technology areas, including Hydro & Storage, Hydrogen, Biomass, and Gas, and gain insights into other areas...


  • Swindon, Swindon, United Kingdom Primus Connect Full time

    Unlock your potential as a Data Engineering Specialist at Primus Connect, where you'll design and implement cutting-edge data solutions using Databricks and Microsoft Azure.As a key member of our team, you'll leverage your technical expertise to create robust data pipelines and analytics solutions, driving business decisions with data-driven insights.Key...