Senior Data Engineer (2 Year FTC)

Platform Housing Group; Coleshill Heath; Remote; GBP 58.000 - 65.000; Vollzeit

Benefits dieser Stelle

28 days annual leave

Family friendly policies

Medicash

Health Cash Plan

Pension scheme

Learning and Development

EV salary sacrifice

Employee rewards

Zusammenfassung

Platform Housing Group is seeking a Senior Data Engineer (2 Year FTC) to manage cloud and on‑prem data stores, architecture and migrations from our Information & Data Architecture Team. The role is remote with occasional travel to Solihull/Worcester offices and Birmingham area sites.

You will lead data extraction, transformation and integration, build dashboards and reports, and ensure data quality and performance across enterprise systems, including housing data sources and Microsoft Fabric

Qualifikationen

• Extensive experience in a similar Data Engineering role with full development lifecycle.
• Strong knowledge of dashboard and visualisation design to deliver high quality business solutions.
• Experienced with Kimball data modelling and data warehouse design (SCDs, conformed and junk dimensions).
• Experience analyzing and documenting requirements and proposing solutions.
• Experience resolving technical incidents and monitoring data solutions.
• Understanding of cloud data technologies, preferably Microsoft Azure.

Aufgaben

• Collaborate with stakeholders to establish requirements and agree solutions.
• Create ETL routines, dashboards, visualisations, analyses and reports.
• Define, plan and undertake extraction, manipulation and integration of enterprise data.
• Ensure ETL infrastructure runs efficiently and reliably.
• Coordinate testing (unit, UAT) and communicate risks and actions.
• Support and monitor data solutions and SQL databases in a business environment.

Kenntnisse

Azure

Data architecture

ETL

Data modelling

SQL

SSIS

Data warehouse

Kimball

UAT testing

Tools

Microsoft Fabric

Azure

SQL Server

SSRS

SSAS

Power BI

Jobbeschreibung

Senior Data Engineer (2 Year FTC)

Home based with occasional travel to Solihull/Worcester office

£58,382 - £64,869 per annum (depending on experience)

Are you a Data Engineering expert with experience in Microsoft Azure and cloud data architecture, and would love to use your skills to really make a difference and help change people's lives?

We currently have an exciting opportunity for a creative and forward-thinking Senior Data Engineer to join our brilliant Information & Data Architecture Team and manage the ongoing evolution and innovation of the group's cloud and on-premises data stores, analysis tools, data modelling and other technological capabilities in line with organisational policy and regulatory guidelines.

This is a great time to join the team as you will also play a key role in system consolidation and data migration as we adopt a more modern approach to data via Microsoft Fabric and Azure.

As our Senior Data Engineer, you'll:

• Collaborate with stakeholders to establish requirements and agree solutions
• Be innovative and creative, looking for solutions and capabilities which improve and extend the use of data within the organisation.
• Define, plan and undertake the extraction, manipulation and integration of enterprise data to support data and analysis related solutions
• Create ETL routines, dashboards, visualisations, analysis and reports
• Perform data analysis to verify the integrity and usage of data
• Communicate any blocks, risks, assumptions, issues, decisions via the agreed method and to the relevant person/s.
• Conduct unit and co-ordinate technical testing where appropriate.
• Work with stakeholders to conduct and coordinate technical and UAT testing
• Ensure scheduled outputs, batch jobs and ETL infrastructure run efficiently and reliably
• Proactively ensure the data environments are optimally tuned to ensure efficient operation
• Report ongoing issues or trends, analyse, identify, communicate and implement any remedial action

Some of the things we are looking for:

• Extensive experience in a similar Data Engineering role with full development lifecycle.
• Ability to demonstrate knowledge of good dashboard and visualisation design to deliver an effective high quality business solution.
• Strong experience with Kimball data modelling and data warehouse design. Ability to demonstrate understanding of complex data warehouse constructs, such as slowly changing dimensions SCD, conformed dimensions, junk dimensions etc.
• Experience analysing and documenting requirements and suggesting solutions.
• Experience of resolving technical incidents in a professional fashion.
• Experience supporting and monitoring Data solutions and SQL databases in a business environment, including monitoring and performance tuning SQL databases.
• Ability to demonstrate understanding of complex data warehouse constructs, such as slowly changing dimensions SCD, conformed dimensions, junk dimensions etc.
• Experience of coordinating and executing user testing.
• Good understanding of cloud data technologies, preferably Microsoft Azure

• Experience with Microsoft Fabric would be advantageous
• Understanding of relational databases, database design.
• Good experience with Microsoft SQL Server 2008R2 or above. With good T-SQL, stored procedures and performance tuning techniques. Ideally some basic DBA knowledge. Other RDBMS may be considered.
• Strong Microsoft SSIS experience. Ideally data warehouse ETL processing.
• Experience of working with data from multiple sources, ideally Housing Systems.
• Extensive experience with Reporting Services (SSRS) and data visualisation tools including Excel, with SSAS MOLAP Cubes.

• Experience within a social housing environment, ideally with Microsoft Dynamics 365, Capita Open Housing or similar systems and data is desirable
• Have a strong customer focus, and the ability to communicate to both technical and non-technical audiences

While this role is home based, you should have the ability to occasionally travel to Group offices and other locations as required. Our Group offices are located at Birmingham Business Park and Central Park, Worcester.

Some of our great benefits include:

• 28 days annual leave (plus bank holidays) with the opportunity to buy and sell leave
• Family friendly policiesincluding generous Paternity, Maternity, Shared Parental and Adoption leave plus 3 days paid Urgent Domestic Leave
• Medicash membership for all employees which includes access to an employee assistanceprogramme, discounted gym membership and exclusive discounts
• Health Cash Plan worth up to £1700 p/a with cashback for dental, optical, physio and complementary therapiesand more
• Pension scheme with minimum employee contributions of up 3% and Platform will contribute up to 12% (inclusive of life assurance and dependent on employee contributions)
• Learning and Development opportunities
• Salary sacrifice electric vehicle scheme

• Employee reward and recognition scheme with wellbeing hub and discount from a wide range of retailers

We aim to hold 1st stage interviews via Microsoft Teams w/c 2nd November, and 2nd stage interviews at our Birmingham Business Park office w/c 9th November and will contact shortlisted candidates to arrange a suitable time.

Early applications are encouraged, as we may close the advert ahead of the advertised closing date if we receive a high volume of interest.

We do not require recruitment agency support at this time - all speculative CV's will be treated as a direct application.