Data Engineer

Data Engineer

Salary: £45,859 – £53,100 dependent on experience

Type: Permanent, Full time (35 hours per week)

Location: Ealing office base with Hybrid working

About us

We’re a UK housing association committed to a new vision – providing homes people love to live in.

With over 38,000 homes in management across London and southern England, we provide a wide range of homes for social, affordable and private rent, specialist housing services, as well as homes for sale and shared ownership.

Our 70,000 customers have diverse backgrounds and levels of income and we’re here to provide all of them with homes that are safe, high quality and sustainable. And with social housing roots going back eight decades, we continue to ensure that every penny of profit we make is reinvested into our charitable social purpose – delivering more homes and better services for customers.

We’re also members of the G15, a group of leading housing associations that work together to house one in ten Londoners and tackle the housing crisis. 

About the role

We’re searching for a Data Engineer to join our friendly and hard-working IT Department here at A2Dominion. This role is to provide the technical capabilities to support the delivery of the A2Dominion analytics platform.

Key responsibilities:

•  Support the architecture, design, development and delivery of A2Dominion’s Business Intelligence and Analytics solution based on the Microsoft Data Platform. This solution will include the Azure SQL Synapse Data Warehouse solution, based on data from Dynamics 365 F&O and CE, and other sources
• Develop ETL/ELT processes, data lake storage architecture, data warehouse, data marts, in-line with the company data management framework and enterprise data strategy
• Assist the design of the Azure Synapse Data Warehouse data model incorporating star/snowflakes schemas, and Dimensional Modelling, as appropriate
• Support data engineering activities, such as release management, environment controls, and the development of Continuous Integration / Continuous Development pipeline orchestration (i.e. through DevOps)
• Ensure the quality and integrity of data in the data warehouse
• Continually develop technical skills and gain knowledge in the latest strategies, tools, and techniques to improve the analytics capability within the organisation, keeping abreast of Microsoft’s fast changing product landscape and data capabilities
• Contribute to the Data Governance Working Group, comprising of key resources from the Data and BI team
• Provide input to the Data Warehouse and Analytics Governance Group artefacts

More about you

For this role, we’re looking for someone with the following:

•  Educated to Degree level in a computer science or related field, or equivalent knowledge based on experience
• Qualified in SQL Server Database Fundamentals
• Architectural design knowledge of data warehouse/data analytics based on MS Azure
• Demonstrable knowledge of Data Lake, Data Lake Analytics, Data Pipeline, Azure Synapse Analytics, Azure SQL DB, and Azure Purview
• Experience of SQL data warehouse design (including Star/Snowflakes schemas, and Dimensional Modelling)
• Experience in SQL Server Data Warehouse development
•  Strong working knowledge of Phyton/PySpark
• Strong and demonstrable knowledge of BI Visualisation tools, such as Power BI

Choosing us is easy

As an employee of A2Dominion, we want you to feel rewarded and have a choice of flexible benefits, salary exchange benefits, and rewards and discounts that work for you, wherever you are in your life.

We offer a wide range of staff benefits. For this role, these include:

•  25 days’ holiday (Plus Bank Holidays) increasing up to 28 days with 3 years of service
• Up to 8% contributory pension
• Flexible working
• Investment in your learning and development

In addition, all permanent and fixed-term employees receive a generous annual allowance of up to £300 to use towards health and lifestyle benefits for both you and your family.

We also operate a Cycle to Work Scheme whereby employees have access to cycling equipment throughout the year and can pay via monthly salary deductions.

Whatever the role, we want you to bring your knowledge and experience to play your part in improving people’s lives.

If you require a reasonable adjustment during the recruitment process, please contact our Talent Team to request: resourcing@a2dominion.co.uk

A2Dominion Group is a Disability Confident Employer which means that we are committed to employing disabled people and will:

•  actively look to attract and recruit disabled people
• provide a fully inclusive and accessible recruitment process
• offer an interview to disabled applicants who meet the minimum criteria for the job
• be flexible with assessing people so disabled applicants have the best opportunity to demonstrate that they can do the job
• make reasonable adjustments as required

At A2Dominion Group, we recognise the positive value of diversity, promote equality and inclusivity in our hiring processes. We always aim to recruit the person who is most suited to the job and welcome applications from people of all backgrounds – men and women, people of all ages, sexual orientations, nationalities, religions, and beliefs.

Meeting the role requirements

We recognise that some people will only apply for a role if they meet 100% of role requirements.  If this sounds like you, we’d still encourage you to apply and also to arrange a call with one of our recruitment team to discuss your application further at resourcing@a2dominion.co.uk

A2Dominion is proud to be a family friendly employer

Everyone is welcome at A2Dominion Group. We know that equality, diversity, and inclusivity make us better. We embrace the unique contributions of our people and seek to create a workplace where everyone feels like they belong. Find out why our people love working with us.”

Join us at A2Dominion, where your expertise will be integral to our recovery journey, creating lasting positive changes in the lives of our customers. If you possess the right motivation and drive to contribute to our recovery and change initiatives, we invite you to apply and be a crucial part of our team.