Senior Data Engineer
Everything we do at the Scottish Funding Council (SFC) aims to create the right environment for colleges and universities to thrive individually and collectively.
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.
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.
Skills, Knowledge and ExpertiseIt is important through your CV / Cover Letter that you give evidence of proven experience of each of the following essential criteria:
Significant experience in SQL or similar standard data processing languages and development experience in at least one scripting language (Python, etc.).
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.
Degree level education (SCQF level 9) or equivalent experience, ideally in a technical field such as Computer Science, Mathematics or Physics.
Azure Data Engineer Associate certification or higher OR Azure AI Engineer Associate certification or higher.