Data Engineer

Job Title: Data Engineer
Contract Type:  Permanent
Salary: £44,294.05 (£48,850.12 is achieved after 12 months successful performance in the role)
Working Hours: 35hrs per week
Working Pattern: Monday-Friday (Hybrid)
Location: Liverpool
For your application to be considered please ensure you attach a current CV and cover letter. 
Applications may close before the deadline, so please apply early to avoid disappointment.
Why Riverside?
At Riverside, we’re a housing association with a difference – enhancing the everyday for all our customers. For 90 years, we’ve been revitalising neighbourhoods and supporting communities by providing the homes they need to live full, fulfilling and rewarding lives. 
We have a portfolio of over 75,000 affordable residential and retirement homes across the UK. Our work ranges from homelessness services to social care, employment support to retirement living, and we need the best people on board to help us.
Working with us, you’ll enjoy:

• Competitive pay & generous pension 
• 28 days holidays plus bank holidays 
• Flexible working options available
• Investment in your learning, personal development and technology
• A wide range of benefits 

Diversity and Inclusion at Riverside:
We are inclusive. At Riverside, we value diversity in all its forms. We foster a workplace where all individuals are respected, empowered, and heard. Our commitment to inclusivity drives our success and enriches the lives of our customers and colleagues. 
Application Process:
If you share our values and are excited about making a significant impact as a Data Engineer, we encourage you to apply with your CV and cover letter. 
We encourage you to apply even if you don't meet all the criteria on the job description, at Riverside we recruit to potential not just on skills and experience.  
This role also falls under our Ethnic Diversity guaranteed interview scheme. If you are Ethnically Diverse and demonstrate you meet the minimum criteria for the role you will be guaranteed an interview
The difference you will make as a Data Engineer
The role holder will analyse, develop and construct data products and services in order to build and enhance Riverside’s strategic Enterprise Data Warehouse. The Data Engineer will work within a data squad and be responsible for the creation, maintenance, improvement and manipulation of data in the data warehouse to support the delivery of intelligent business information through a range of mechanisms, in particular self-serve tools for use by colleagues.
About you:
You will have good knowledge and experience of SQL language (preferably Microsoft SQL) and Relation Databases structures.
Job role

• Collect, collate, cleanse, synthesise and interpret data to derive meaningful and actionable insights
• Translate data into valuable insights that inform decisions.
• Involve business teams in analytics and synthesis to increase consensus and challenge assumptions.
• Develop and maintain the Enterprise Data Warehouse to underpin day-to-day operational and planning activities.
• Produce data models and understand where to use different types of data models, with an
• understanding of different tools used to compare different data models. You can reverse-engineer a data model from a live system.
• Understanding of industry-recognised data modelling patterns and standards.
• Identify and use the most appropriate analytical techniques.
• Keep up to date with advances in digital analytics tools and data manipulation products.
• Escalate issues with data accuracy or system usage to the appropriate channel to ensure prompt and satisfactory resolution.
• Work closely with colleagues in the Insight Team to maximise the use of existing self-serve tools and bring together Riverside-wide data to provide comprehensive analysis.
• Ensure that health and safety requirements are met in accordance with the Group’s policy, procedures and statutory requirements.
• Respond flexibly to any necessary changes in work priorities and undertake other duties when required to support the effective operation of the service.
• Provide bespoke analysis and technical expertise in appropriate analysis and visualisation techniques to support colleagues across the business with scrutinising data.

Knowledge, Skills and Experience
Essential:

Good knowledge and experience of SQL language (preferably Microsoft SQL) and Relation Databases structures.

Perform data profiling and source system analysis and present clear insights to colleagues to support the end use of the data.

Design, build and test data products based on feeds from multiple systems using a range of different storage technologies and/or access methods. Create repeatable and reusable products

Deliver data solutions in accordance with agreed organisational standards that ensure services are resilient, scalable and future-proof

Understand the concepts and principles of data modelling and can produce, maintain and update relevant data models for specific business needs

Work with metadata repositories to complete complex tasks such as data and systems integration impact analysis

Design, write, iterate and test code from prototype to production ready. Good understanding of security, accessibility and version control. Experience in a range of coding tools and languages.

Results focused with the ability to take ownership of tasks....