Data Migration Specialist
Data Migration Engineer - Python / SQL
The Job
As a Data Migration Platform Implementation Contractor, you will be instrumental in designing, building, and thoroughly documenting a robust data migration platform.
Your core responsibility will involve creating a seamless process for extracting and transforming data from Microsoft Dataverse and loading it into PostgreSQL. This includes designing and implementing extraction processes for regular scheduled runs, bulk historical extracts, and incremental change data.
You will be responsible for loading this extracted data into a PostgreSQL Bronze layer database and implementing a Medallion-style architecture, developing subsequent transformation layers as appropriate (e.g., Silver/Gold). Leveraging Python for orchestration and complex transformations, and SQL for set-based transformations and data modeling, you will develop critical data transformation logic. Automation for scheduled execution, error handling, logging, and ensuring repeatable, reliable pipeline execution will also fall within your remit.
Finally, you will produce clear, comprehensive technical documentation covering architecture, design decisions, data flows, extraction/transformation logic, and operational considerations for handover and ongoing support.
About you
You are an experienced data professional with strong expertise in data extraction from Microsoft Dataverse. You possess a deep understanding of PostgreSQL database design and optimisation, coupled with advanced skills in Python for data engineering and automation.
Your SQL abilities for data transformation and modeling are exceptional, and you have demonstrable experience implementing Medallion-style data architectures. A key strength is your ability to produce clear, maintainable technical documentation. You are a detail-oriented problem-solver who can deliver automated, reliable, and well-documented data solutions.
The company
You will work for a well known charity that are in the middle of a huge digital transformation. The work a 35 hour week and the work they do is literally incredible.
Why you should do this job
This is an exceptional opportunity to take ownership of a critical data initiative from conception to delivery. You will work with modern data architecture patterns (Medallion Lakehouse) and key technologies like Microsoft Dataverse, PostgreSQL, and Python. Your contributions will have a direct and significant impact on our data infrastructure, ensuring reliable and efficient data processes that drive business intelligence. It’s a chance to build a foundational platform, showcase your design and implementation skills, and leave a lasting technical legacy within a supportive and innovative environment.
You will also be helping a huge charity and 100 of thousands of volunteers.
Location
Hybrid - London
The Money
£500+/- Outside IR35
What you should do now
If you are a Data Migration Platform Implementation Contractor and would like to apply, click the link and send me your resume. If you have questions about this job please contact us at initi8 HQ.
apply now