Senior Data Systems & Automation Specialist - Forensic Data
Overview
Provides advanced functional and technical support to forensic data systems and tools, focusing on data management and operational requirements for specific projects. Translates requirements into technical solutions, develops queries and scripts, and supports data structuring and migration.
Key Responsibilities
- Provides advanced functional and technical support for forensic data systems.
- Develops advanced SQL queries and scripts to investigate, extract, update, reconcile and manage complex relational data.
- Supports the Responsible Handover of Missing Persons Data project.
- Analyses source and target data structures and supports data mapping, transformation, extraction, preparation, reconciliation and migration.
- Develops advanced SQL scripts, automations and bulk-processing solutions.
- Designs and implements bulk imports, updates, transformations, corrections and automated or semi-automated data-processing workflows.
- Develops technical controls for data quality, validation, reconciliation, logging and exception handling.
- Produces and maintains technical documentation for scripts, automations, mappings, configurations and migration processes.
- Ensures technical solutions are properly handed over with required documentation.
Required Experience
Minimum of 8 years of substantial hands-on professional coding experience as a core part of the role, including advanced scripting, automation, bulk data processing and work with complex relational data systems. Demonstrated day-to-day coding experience is essential. Advanced practical SQL development and scripting expertise, together with strong experience supporting and troubleshooting complex relational data environments.
Qualifications
Bachelor’s degree in Computer Engineering, Software Engineering, Data Engineering, Computer Science, or another closely related technical discipline.