Senior Data Engineer
| Posting date: | 19 April 2024 |
|---|---|
| Hours: | Full time |
| Closing date: | 19 May 2024 |
| Location: | Edinburgh, EH12 5HD |
| Company: | Reed Talent Solutions |
| Job type: | Permanent |
| Job reference: | RPO03119-294230 |
Summary
Senior Data Engineer
Permanent
Edinburgh/Hybrid
£45,942 to £53,478 + £5,000 RRA bonus (Grade E3)
Everything we do at the Scottish Funding Council (SFC) aims to create the right environment for colleges and universities to thrive.
The Scottish Funding Council is Scotland’s tertiary education and research authority. Our ambition is to make Scotland an outstanding place to learn, educate, research, and innovate – now and for the future. So, naturally, we have a clear focus on recruiting the best people and developing them throughout their career. We invest around £2 billion every year, and our funding enables colleges and universities to provide life-changing opportunities for over half a million people.
We’re not only looking for the best people to come and work for us, but also people who will connect with our guiding principles which include working in partnership, championing diversity, and supporting sustainability for future generations.
By fostering our guiding principles, we are very proud of the inclusive working environment that we have created. We are committed to attracting people of all backgrounds: we want our colleague base to reflect the people and communities that we serve.
Job Summary
We are seeking an experienced Senior Data Engineer who will deliver robust data products and services for all SFC, in support of its priorities and needs of our partners.
Key Responsibilities:
- Translate business requirements into technical specifications, roadmaps and deliverable data solutions, including data streams, integrations, transformations, databases, data warehouses, and business intelligence, reporting and analytical platforms.
- Define the data architecture framework, standards and principles, including modelling, metadata, security and data virtualisation.
- Support the Head of Data Engineering to develop and enhance standards and policies/guidelines whilst driving adoption of standards.
- Define data flows and data lineage, visualising which parts of the organization generate data, which require data to function, how data flows are managed, and how data changes in transition.
- Provide technical guidance and advice to help in the design and development of data solutions for data modelling and warehousing, data integration, and analytics.
- Provide direction and support to a team of data engineers and provide technical guidance on the data products.
- Develop roadmaps for both product related DE work as well as overall data maturity roadmap.
- Drive the design, building, and launching of new data models and data pipelines in production.
- Perform peer reviews, audits, standards compliance checks and due diligence as required.
- Report delivery progress and status to both internal and external stakeholders.
Person specification
It is important through your CV / Cover Letter that you give evidence of proven experience of each of the following essential criteria:
Essential Requirements:
- Working experience in Python or similar standard data processing languages and development experience in at least one scripting language
- Extensive and demonstrable Data Modelling / architecting in Data Warehouses and BI Solutions.
- Deep technical expertise gained from extensive hands-on experience.
- Effective analytical skills with ability to undertake data profiling and source system analysis, and to present clear insights to support the end use of the data.
- Effective oral and written communication skills.
- Evidence of leadership experience, with experience initiating and driving projects.
Desirable Requirements:
- Degree level education (SCQF level 9) or equivalent experience, ideally in a technical field such as Computer Science, Mathematics or Physics.
- Azure Data Fundamentals or higher
- Working experience with SQL
Additional information
Location:
SFC offers hybrid working for its employees. This means that whilst the role is based at our Edinburgh office, there is substantial opportunity to work from home most of the time. As a rule of thumb SFC expects that a minimum of three days a month in the office (on average) will achieve the benefits of its hybrid approach, however it is for the employee and their line manager to agree the balance between home and workplace working - determined primarily by business need. Please be aware that this role can only be worked from within the UK and not overseas. Relocation expenses are not available.
Key Rewards and Benefits:
- Normal full-time hours of work are 35 per week. We will consider flexible working arrangements. A flexi-time system is in operation.
- Annual leave entitlement of 26.5 days pro-rata, rising to 30 days pro-rata after 4 years’ continuous service. Public and privilege holiday entitlement of 11.5 days pro-rata.
- A flexible approach to hybrid working, giving you flexibility to work from home for some of the time while also maintaining regular in-person contact with colleagues.
- Annual pay review: approved within the framework of the Scottish Government’s Public Sector Pay Policy and negotiated with our recognised trade union, Unite. Salaries are reviewed annually in April for employees who commence employment prior to 1 October in the preceding year.
- Eligibility to join the Civil Service Pension Scheme. With its low member contribution rates and generous employer contributions, this gives you a secure, inflation-proof pension for life with no investment uncertainty. Details of contribution rates together with further details of the pension benefits are available on the Civil Service Pensions website. There is also the option of a Partnership pension account.
- Support for continuous professional development.
- Support for health and wellbeing, including generous occupational sick pay, free access to confidential advice and support through our 24/7 Employee Assistance Programme, Special Leave (paid and unpaid), a contribution to learning outside work through our Lifelong Learning Fund, free winter flu vaccination, and access to occupational health support.
- Support for travel to and from work, including a salary sacrifice cycle loan scheme, cycle storage and shower facilities, an interest-free loan for bus or rail season tickets and free office car parking for employees on a first-come basis.
The Selection Process
How to Apply
To apply, please send your CV and cover letter. The selection panel will use this evidence to assess your application against the selection criteria in the Person Specification section above. It is not mandatory to provide a cover letter but it can be beneficial to provide further evidence of your suitability against the essential skills. In your CV please also set out your educational and professional qualifications, and career history, with key responsibilities, dates and achievements. Please provide reasons for any gaps.
Expected Timeline:
Your application will be reviewed by a Reed Recruitment Specialist who may invite you to an initial telephone screening call. The call will last up to 30 minutes, giving you an opportunity to discuss your relevant experience, the role and The Scottish Funding Council in more detail.
Should you application be progressed, the selection panel will assess your application by considering the evidence you have provided in your CV / Cover Letter. Please ensure your application demonstrates how you meet the criteria in the Person Specification for the role. The selection panel will then select the shortlist of candidates to take forward to interview stage.
Pre-Employment Checks
As part of our pre-employment process, we will ask you to provide relevant documentation to show that you are eligible to work in the UK and a Basic Disclosure Scotland certificate. You must be eligible to work in the UK to apply for this role; we do not offer sponsorships. We also take up references as part of this process. Expenses will be reimbursed for Basic Disclosure check. This will only be requested if you are appointed into the role.
Disability Confident
If you need any adjustments to support your application, such as information in alternative formats, please contact us and we’ll do everything we can to help. If you’re eligible under the Disability Confident Scheme please give details when prompted at the appropriate stage in the online application process.
Proud member of the Disability Confident employer scheme