IT Data Developer Coventry, England
Job description
We’re building thriving communities as one of the UK’s largest housing groups and a leading developer of affordable housing.
We believe everyone is entitled to a good home they can afford, in a place they are proud to live. More than 100,000 people live in our homes.
If you want to experience work that’s truly rewarding, join us. Because when we achieve together, customers and communities thrive.
Work for Orbit. Believe in people.
The role
As Data Developer here at Orbit you will be responsible for supporting Orbits’ strategic goals by providing group wide management information and reporting solutions.
This role is part of Corporate Services where you'll help us give colleagues the support they need to be brilliant.
What you'll achieve
You're key duties will be to:
- Create system generated reports by creating SQL Stored Procedures
- Work with the business to design and develop the business reporting tool utilising SQL Server 2008R2-2019
- Transfer data from a variety of sources and databases into a reporting repository using SQL Server 2019 Integration Services (SSIS)
- Work with the business and external Housing Associations/Local Authorities in undertaking additional housing stock into the housing systems, this includes the identification of data required, creation of data loaders and mapping of data against third party data to ensure data can be imported and then convert the data into a format or codes required for the import into the Main Housing Systems, then placing into data import files before uploading into the system, ensuring that the process and procedures are fully documented and data verified for audit purposes.
- Work with the business to develop and support its reporting requirements, including the creation of system generated reports/dashboards
What you'll bring
To be successful in the role of Data Developer you will need to have experience of Microsoft operating system and applications with a high level of report writing tools and practices.
Essential skills
- High level of Database Architecture and Design
- High level of SQL 2019 SQL Stored Procedures
- High level of SSIS and SSRS
- Ability to analyse and document complex business processes
- Experience interacting directly with end users for both projects and day to day work
Desirable skills
- Azure Data Lake, Data Factory and Synapse Technology
- Experience of Housing sector software (ActiveH)
- Experience of using Source Control tools
- Experience of Automated Deployment
- PowerBI
Why Orbit?
Choosing us means being rewarded in every sense.
Here’s what you can expect to enjoy with us.
A rewarding experience that works for you
We strive to create an inclusive experience with benefits and wellbeing programmes designed to help you, and your loved ones, to thrive. For a better work life balance, we offer flexible working opportunities for many roles.
A place to progress
From training programmes to professional qualifications, we provide opportunities to learn and develop at every stage of your career. Whether you’re a student, graduate or experienced professional we’ll support you to grow.
For leaders, our tailored development journeys are designed to stretch and strengthen your leadership skills. As well as practical training, we give you access to renowned business schools and experiential programmes for greater breadth and depth of learning.
A purpose to feel proud of
We’re proud to make a difference to people together. We’re values-driven with a commercial focus on performance - because the more profit we make, the more we can achieve for people.
What brings us together is a passionate belief in progress and people.
Read more about the values and purpose that drive us on our careers website.
How we hire
We aim to make our hiring process simple and fair:
- Online application
- Interview(s)
- Decision and offer
We put the safeguarding of our customers, colleagues and contractors at the heart of everything we do and as such, certain roles will be subject to a DBS check.
