Technical Systems Data Analyst

Precise Placements; Greater London; Hybrid; GBP 67,000 - 88,000; Full time

Job summary

Precise Placements in London is seeking a Technical Systems Data Analyst to reverse-engineer a complex legacy application and its databases. The role focuses on detailed technical documentation rather than BI or analytics, producing a current-state pack for architects and migration teams.

The ideal candidate has hands-on experience reverse-engineering poorly documented systems, using advanced SQL, and delivering data dictionaries, ERDs and data lineage that support modernization programs.

Qualifications

• Recent hands-on reverse-engineering of a complex legacy app and databases.
• Proficient in advanced SQL to interrogate schemas and data structures.
• Ability to produce formal current-state data manuals and ERDs.
• Experience documenting tables, keys, indexes and dependencies.
• Ability to trace data flows across apps, DBs and APIs.
• Ability to validate findings with technical teams.

Responsibilities

• Analyse current app and data environment to map operation and data structure.
• Produce a comprehensive current-state documentation pack.
• Document source-to-target mappings and transformation rules.
• Work with architects, developers and migration teams.
• Present findings to technical and non-technical stakeholders.
• Ensure governance and sign-off processes are followed.

Skills

Reverse engineering

Advanced SQL

Data documentation

ERDs

Relational databases

Stakeholder communication

Tools

SQL Server

Oracle

PostgreSQL

NoSQL databases

Job description

Technical Systems Data Analyst - Legacy Application Reverse Engineering

£420 per day - Outside IR35

Initial six-month contract

London - two days per week onsite

We are recruiting a Technical Systems Data Analyst to investigate and formally document a complex, tightly integrated Legacy application and its underlying databases.

This is not a BI, reporting, dashboarding or commercial analytics position. We require someone who has personally reverse-engineered poorly documented applications and databases and produced detailed technical data manuals for use by architects, developers and migration teams.

The assignment

You will analyse the current application and data environment to establish exactly how it operates, how its data is structured and how its different components interact.

Your principal deliverable will be a comprehensive current-state documentation pack covering:

• Database schemas, tables, columns and data types.
• Primary and foreign keys, relationships and constraints.
• Indexes, views, stored procedures, functions and triggers.
• Business rules Embedded within databases, applications and established processes.
• Application-to-database interactions and access patterns.
• APIs, interfaces, integrations and external dependencies.
• End-to-end data flows and data lineage.
• Source-to-target mappings.
• Transformation, cleansing and validation requirements.
• Data-quality issues, risks, assumptions and unresolved gaps.
• Data dictionaries, entity-relationship diagrams and supporting technical documentation.

You will work with technical teams, system owners and business subject-matter experts to validate your findings and ensure the documentation is sufficiently accurate and detailed to support application modernisation, migration and target-solution design.

Essential experience

Applicants must be able to demonstrate recent, hands-on experience of:

• Reverse-engineering a complex or poorly documented Legacy application and its underlying databases.
• Using advanced SQL to interrogate schemas, data structures, relationships and Embedded logic.
• Producing formal current-state data manuals, data dictionaries, ERDs or equivalent documentation packs.
• Documenting tables, columns, keys, indexes, constraints, relationships and dependencies.
• Discovering and documenting business rules rather than simply receiving completed requirements.
• Tracing data across applications, databases, APIs, interfaces and integrations.
• Creating source-to-target mappings and documenting transformation rules.
• Working with relational databases such as SQL Server, Oracle or PostgreSQL.
• Supporting application-modernisation or data-migration programmes.
• Presenting technical findings clearly to architects, developers and non-technical stakeholders.
• Working within structured enterprise governance, traceability and sign-off processes.

Highly desirable

• Migration from a relational database to a document-based or NoSQL platform.
• MongoDB, Azure Cosmos DB, Couchbase or equivalent NoSQL experience.
• Azure data services.
• ETL/ELT and data-transformation experience.
• Data lineage, metadata management and data-governance experience.
• Experience analysing custom-built enterprise applications.

Please note before applying

This role is unlikely to suit candidates whose experience is primarily focused on:

• Power BI, Tableau or dashboard development.
• Reporting and management information.
• Statistical, customer or commercial analysis.
• Data science or machine learning.
• Building cloud data pipelines without Legacy-system investigation.
• Database administration without systems-analysis and documentation ownership.
• Migration delivery where mappings and business rules were supplied by another team.

To be considered, your CV must include a clear example of an application or database that you personally reverse-engineered and the technical documentation or data manuals you produced from that investigation.