An experienced data engineer is required to accelerate the development of Registers of Scotland's Data Warehouse and associated products and services. The focus of the work will be the collaborative development of internal casework profiling solutions using data extraction & processing techniques applied to semi structured and unstructured documents and forms. The candidate will also be expected to deliver robust and resilient data integration solutions and automation of data products and services to ensure that the Data Warehouse is fit-for-purpose.

Main Objectives:

• Implement data extraction and cleansing pipelines to prepare data for automatically classifying legal casework from structured and unstructured sources
• Fine-tune OCR process for extracting text from legal documents and forms
• Develop and implement rules to automatically classify legal casework

Additional Services

• Ensure technical resiliency of all data integration solutions and services
• Support the delivery of ongoing data engineering activities
• Enhance and support existing data product outputs for both internal and external customers.
• Collaborate with technical colleagues across the organisation to design robust data integration solutions
• Demonstrate excellent, sustainable and collaborative software development practice that's focused on delivering highly readable, maintainable and appropriate artefacts.
• Actively participate in all team events, leading where specialist knowledge is required and supporting the team to improve their process through inspection and adaptation.
• Troubleshooting and fixing development and production problems across multiple environments and operating platforms.
• Engage with the wider RoS communities of practice and interest to share knowledge, technique and experience
• Ensures high quality of developed solutions through development and maintenance of unit tests - with appropriate code coverage - and code analysis using code quality tools,
• Ensure that developed software complies with non-functional software requirements such as accessibility, security, UI/UX, performance, maintainability and deployability,
• Routinely use collaborative development practices such as pairing and mobbing techniques in programming, code reviews, system design and requirements analysis, etc.
• Support and deliver the disaster recover assurance of digital services, striving towards a sustainable Recovery Time Objective of 2hrs and Recovery Point objective of zero. This will be assured at 6 weekend points over the course of a FY year

Essential Skills

• Python
• PostgreSQL
• REST APIs
• Modern DevOps and CI/CD practices and tooling including Docker, GitLab CI, AWS CodePipeline, AWS CDK and AWS CloudFormation
• Expertise in SQL, data transformation and analysis
• Delivering high quality software collaboratively in high-performing, cross-functional development teams.
• Experience implementing data ETLs, data streaming systems and data integration solutions
• Experience working in the Agile delivery models - such as Scrum and/or Kanban frameworks

Desirable Skills

• Data warehousing
• Hybrid on-premises/cloud solutions
• AWS Glue, Lambda functions, S3, RDS, Comprehend, SageMaker, Data Migration Service
• Experience implementing ML/AI-based solutions, especially in the NLP domain
• Spark
• Using testing tools for unit testing, including system test automation frameworks
• Openshift
• PostGIS for PostgreSQL
• Designing and implementing solutions using service and event-based architectures
• Monitoring, alerting, intelligence tools and processes, including Grafana
• Human-centred, research-driven, inclusive design practices
• Developing within Digital First or GDS quality standards
• TDD

Talent International UK Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this opportunity, you accept the T&C's, Privacy Policy and Disclaimers which can be found on the website.