Openwork

Junior Data Engineer

Job description

The opportunity

As the Junior Data Engineer, you will work as part of the multi-function Data Engineering Team that own the Azure Synapse service and support the design and develop pipelines for data transformation into the Azure Synapse Data Lake, Azure SQL Data Warehouse and out to Power BI.

You will also support legacy data processes (SSIS /SSRS) and data migrations as required.

This is a hybrid position is based in our Swindon office.

The benefits

  • Salary - £40,000 - £45,000
  • Bonus scheme - on target bonus – 7.5%
  • 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.

Your responsibilities will include:

  • Support the design and maintenance of the Azure SQL / Synapse meta data framework for Data Engineering.
  • Support the development of 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.
  • Support the development of Azure Synapse pipelines for audit capture, error, and exception handling.
  • Automate Azure Synapse pipelines and Report Layer jobs using scheduling tool(s).
  • Participate in ensuring best practise is adhered to in the handling and management of data by the team.
  • Create and maintain Technical Specifications.
  • Support the data office and other data consumers within the organisation.
  • Migration of data and processes from legacy systems to Azure Synapse.
  • Identifying improvements to existing processes and helping to migrate data and modelling into Azure Synapse.

What will you need to succeed?

  • Experience with SQL Server (TSQL).
  • Data modelling fundamentals.
  • Data Warehouse and Report Layer design.
  • Knowledge of Agile working and Azure DevOps.
  • Experience of data testing.
  • Interested in Data Technologies, Microsoft Azure, and DevOps.
  • You'll be eager to learn and expand knowledge, adaptable to change.
  • Delivery focused and self-motivated.
  • Have strong attention to detail.


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.

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.

Similar jobs

Browse All Jobs
Underwriting Solutions
December 3, 2024
Tylko
December 3, 2024

Junior Data Analyst

NCC Group
December 3, 2024