Lead Data Engineer

We are One Housing and we create places for people to call home and support them to live well. With a breadth of services and expertise to help people whatever their housing, care, or support needs.

Our IT team is friendly and we love what we do. We are passionate about the high-quality support we provide.

We offer our colleagues a friendly, collaborative workplace and the chance to build a rewarding career with a not-

for-profit organisation that is proud to make a genuine difference to people’s lives, each and every day.

Join our I.T. Team as a Lead Data Engineer

Smooth-running, dependable systems are essential to any modern and flexible organisation. This is particularly so for One Housing. With our various departments, locations and diverse services, our I.T. specialists encounter a broad range of changing requirements and fresh challenges.

We offer the opportunity to put your problem-solving skills and technical knowledge to fantastic use, in support of an organisation with a social purpose and strong values.

We keep our promises; we do a great job; we value diversity; we work together; and we look for ways to improve. These are what make us such a great team, working together as one to achieve our vision.

The Role

We have a fantastic opportunity for someone to join us in the position of Lead Data Engineer.

This position will help provide work allocation, will act as a facilitator and a senior developer, while eliciting and analysing requirements, including verifying, and validating them. The role is to support the Data and BI team and provide assurances that the existing BI reporting arrangements continue to deliver the business reports. The job holder will help the Data and BI team to make sure Enterprise Data Warehouse (EDW), Data Lake and Power BI Models are functional

Your responsibilities will include:

• Managing a team of Database developers & BI Developers plus training and mentoring of team members, business partners and stakeholders on related domain expertise
• Build a strong culture in the Data and BI team around engineering excellence and predictable agile delivery. You’ll ensure key agile ceremonies are performed and the team is aligned around business objectives.
• Work closely with the key business leads, senior management teams and ICT to raise the profile and effectiveness of business intelligence & performance management

• To advise and work with Senior Management and colleagues across OH to develop and implement a consistent, strong approach to business intelligence
• Delivering high performance Data and BI function for the organisation by coaching, mentoring and other disciplines to enhance an organisation ability to successfully accomplish deliverables.
• Responsible for planning and execution of activities such as data cleansing, data migration, ETL, data modelling & mapping and orchestrations.
• Lead the work of integrating new data sources from various key systems (UX, Keystone, D365) and other new system to the existing EDW to enable uninterrupted MI and BI reporting
• Ensure that the physical designs for the data warehouse and its data structures align with OH IT strategies, OH architecture frameworks and logical data models.
• Focus on driving adoption & user engagement regarding BI tooling, decentralising BI and shrinking the gap between engineering and insight
• Facilitate and support the Data & BI team in delivering Data sets and Data analysis results in timely manner to meet internal and external reporting requests
• Responsible for management of technical design documentation and information in structured and organised manner

What you will need to succeed

We are looking for someone who believes in working together as part of a team, who shares our values and who demonstrates a friendly, positive demeanour. We are looking for a talented individual who has real focus on excellent stakeholder management and documentation handling.  The successful candidate will:

• Collaborative leader, focused on developing a high-performing team and bringing together multiple disciplines
• Excellent interpersonal, relationship building and influencing skills
• Experience as a Data and BI Developer or equivalent position with a strong focus on analytics.
• Degree educated in business administration, computer science, and finance or information systems or equivalent
• Experience of working at a senior level in a complex environment; utilising skills in capturing different perspectives, applying systems thinking and taking a cross-organisational perspective.
• Experience of data warehousing, data cleansing, data migration, ETL, data modelling & mapping and orchestrations
• Proven experience with Microsoft SQL Server Integration Services (2008, 2012 and 2014)
• Proven experience working on database technology used for business intelligence and/or analytics (SSIS, SSAS, SSRS and Power BI)
• Experience with SQL, Python, R programming and Power BI, or equivalent data analysis tools is desirable
• Extensive experience in creating data dictionaries for technical architects, business glossaries for business users and creating relationship between the two

The Offer

Our Life@One benefits offer you an array of perks designed with your wellbeing in mind.

• Salary: £62,000 - £68,000
• Your holidays are important to us. Take up to 28 days annual leave plus bank
• Lean travel. Spread the cost of your commute with a season ticket loans and our Cycle2Work scheme, open to

all colleagues

• Looking forward to your big bucket list trip? You can buy or sell up to five days annual leave each [not for statutory employees]
• Get paid to do good. We offer you two days off on full pay each year to volunteer in our
• Look after your loved ones. Our healthcare cash back plan allows you to claim back cash for you and your

family’s healthcare.

• Well done! With our colleague recognition programme you will know when you’ve done a #greatjob
• Learning never One Academy, our innovative, in-house learning and development offering is designed to help you take your career to the next level.
• We’re here for you. Our employee assistance programme offers counselling and support for you and your family

24/7.

• Stay book-smart. Take up to five paid days off per year to study toward a relevant qualification.

Experience new things. We offer you a career break after 3 years’ continuous service

About us

As an organisation with a strong social purpose, One Housing works in some of the most diverse communities in the UK and their workforce reflects that. We understand the strength we gain from having and supporting our diverse teams. The different skills and experiences that our colleagues from different backgrounds bring to us allow us to make better decisions, consider different views and be an altogether more interesting and cohesive place to work.

We welcome applications from everyone.