Hybrid Data Migration Analyst - SQL/Python

Netcompany; Greater London; Hybrid; GBP 65,000 - 90,000; Full time

Benefits offered by this job

Hybrid working model

Private Medical Health care via Vital

Pension contribution

Life Assurance

Professional certifications supported

Retail discounts for lifestyle

Employee Resource Groups

Job summary

Netcompany is seeking a data migration analyst to investigate unfamiliar datasets, profile data quality and validate complete, faithful migration. You will design checks, write SQL and Python scripts, and communicate findings to both technical and non-technical stakeholders.

Join a collaborative team using Azure Databricks, Git and dbt, delivering governance and quality across multi-organisation migrations with a strong emphasis on ethics and privacy.

Qualifications

• Experience profiling unfamiliar datasets and tracing data quality issues to their root cause in a migration context.
• Strong SQL skills for complex joins, window functions, anomaly detection and source-to-target reconciliation.
• Working knowledge of Python, Azure Databricks or Spark SQL, and familiarity with Git and dbt.
• Ability to present evidence, scale and business impact clearly to technical and non-technical stakeholders.
• A responsible approach to data management, ethics and privacy.

Responsibilities

• Investigate unfamiliar datasets to understand their structure, content, relationships and variation across organisations.
• Identify and explain data quality issues, trace them to source records, mappings or transformations, and quantify their impact on migration.
• Design repeatable comparisons and reconciliation checks to validate that migrated data is complete, consistent and faithful.
• Write reusable SQL and Python scripts for profiling, exception detection and validation, using Azure Databricks, Git and dbt where relevant.
• Communicate findings clearly to technical and non-technical audiences, using Excel and Power BI or Tableau to present evidence and track issues.

Skills

Data profiling

SQL (complex joins)

Python

Azure Databricks

Spark SQL

Git

dbt

Data presentation

Tools

Azure Databricks

Spark SQL

Git

dbt

Job description

Netcompany is seeking a data migration analyst to investigate unfamiliar datasets, profile data quality and validate complete, faithful migration. You will design checks, write SQL and Python scripts, and communicate findings to both technical and non-technical stakeholders.

Join a collaborative team using Azure Databricks, Git and dbt, delivering governance and quality across multi-organisation migrations with a strong emphasis on ethics and privacy.