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