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.