Systems Data Analyst – SQL / NoSQL / Data Migration

Systems Data Analyst – SQL / NoSQL / Data Migration

6-Month Contract

We are recruiting an experienced Systems Data Analyst to support a major application modernisation and data transformation programme within a leading international professional services organisation.

This is a highly technical analysis role focused on understanding and documenting the databases behind a complex legacy business application. You will work with Developers, Architects and business specialists to establish how the existing system operates and support its migration into modern cloud and document-based database technologies.

Key responsibilities

• Analyse legacy applications, databases and source systems.
• Reverse-engineer database structures where documentation is limited.
• Document schemas, tables, columns, relationships, indexes and constraints.
• Identify business rules, data flows, dependencies and integration points.
• Produce detailed source-to-target data mappings.
• Define data transformation and migration requirements.
• Work closely with Developers, Solution Architects, Data Architects and business SMEs.
• Support data quality, governance and application-modernisation objectives.

Essential experience

• Strong hands-on SQL and relational database experience.
• Previous database reverse-engineering or legacy system analysis.
• Detailed schema and technical database documentation.
• Source-to-target mapping and data migration experience.
• Experience migrating relational SQL databases into a document-oriented NoSQL platform such as Cosmos DB, MongoDB, DynamoDB or Couchbase.
• Strong understanding of data modelling, ETL/ELT and transformation methodologies.
• Familiarity with Microsoft Azure or comparable cloud data services.
• Strong communication and stakeholder-engagement skills.

Previous experience as a Database Analyst, Data Migration Analyst, Data Modeller, Technical Data Analyst or Database Administrator would be particularly relevant.

Please note: this is not a conventional Power BI or reporting-focused Data Analyst position. Applicants must have technical database analysis and relational-to-NoSQL migration experience.

Apply now if you have the required background and would like to contribute to a significant six-month application and data modernisation programme.