Data Engineer

This job has now expired please search on the home page to find live IT Jobs.

The Data and Business Intelligence team within RSSB is a centre of excellence, tasked with servicing the growing need for data driven insights, both for internal customers within RSSB, as well as customers in the wider rail industry.

The Data Engineer will support project delivery, working as part of an Agile delivery team. This will cover updates to the data model of one of RSSB's industry systems, modelling logical data structures, developing related data flows and data structures in a reporting data warehouse, and developing data integrations with other systems.

The role will ensure that our data pipelines are reliable and perform optimally, and that data surfaced in analytics layers is reliable, accessible, and in the appropriate format.

Responsabilities

Develop and maintain the structure of the reporting database and related data flows and transformations.

Combine data from multiple sources for delivering business intelligence.

Design, code, verify, test, document, amend and refactor complex scripts and data integration services to support the delivery of business intelligence and analytics capabilities.

Develop, maintain and enhance database reporting views and semantic layers.

Ensure technical solutions support the accessibility, retrievability, security, quality, retention and ethical handling of specific sets of data.

Examine data requirements, and apply data analysis, design, modelling and quality assurance techniques to modify or maintain data structures and associated data transformation components.

Plan and deliver small to medium data engineering projects and manage the business change associated with the delivery of these projects.

Create and manage data models in all their forms, including conceptual models and relational database designs. Maintain specialist knowledge of data warehouse concepts.

Assist with trouble shooting data issues, validating result sets, recommending and implementing process improvements.

Influence the information strategy through working with internal business and external stakeholders.

Investigate ways to extract additional value from existing information assets, including the application of new tools and techniques to make data insights more accessible.

Develop an effective working relationship with members the wider RSSB team and RSSB system suppliers, ensuring efficient support of business requirements and data issues, acting as the escalation point for data engineering issues.

Ensure that agreed standards and tools to are applied achieve well-engineered outcomes, including incorporating monitoring and logging functionality into all aspects of the data platform.

Participate in reviews of own work and leads reviews of colleagues' work to ensure these components are reliable and maintainable. Optimise code to ensure processes perform optimally and reliably.

Work in areas including data architecture and business intelligence development; both supporting others and working independently on agreed tasks.

Maintain a good understanding of the overall RSSB data platform, and wider data ecosystem.

Take steps to ensure security in their work, and across the organisations data and information assets.

Advise other team members on details and usage of data structures and models.

Qualifications

Essential criteria

Experience of working with a diverse range of systems and applying complex data engineering techniques to resolve complex technical problems.

Experience designing, coding, testing and correcting complex SQL models and Python scripts.

System/Data integration experience, including application programming interface design, and familiarity with web-oriented architecture techniques.

Experience taking responsibility for driving own development, maintaining an awareness of developing data engineering practices and their application.

Ability to clearly communicate complex technical information to both technical and non-technical audiences.

A positive disposition towards problem solving.

Experience and knowledge of data analysis, data modelling and quality assurance techniques.

Knowledge of relational database concepts.

Experience influencing customers, supplier and peers on data and business intelligence development and processes.

Experience of building good customer relationships, at both user and management levels.

Good organisational skills and the ability to work independently and with others.

Desirable criteria

Degree in a scientific or computer science discipline.

Experience working with the Postgres database platform.

Experience working with the Azure cloud platform.

Experience of Enterprise Architect, or equivalent data modelling software.

Experience working under an Agile methodology with a small-scale development team to deliver solutions.

Early applications are encouraged, as we may close this vacancy before the advertised deadline if sufficient numbers of applications are received.

This role is available on a fixed-term contract and we are therefore unable to consider day rate contractors for this vacancy.

Closing date: 25/04/2021