Remote Senior T-SQL to BigQuery/Dataform Migration Engineer

Adroit Cloud Consulting Limited; United Kingdom; Remote; GBP 92,250 - 129,150; Full time

Job summary

Adroit Cloud Consulting Limited is seeking a contractor for a confidential client project focused on Azure to GCP data platform migration in the UK. The role involves auditing and converting T-SQL stored procedures into BigQuery and Dataform pipelines, ensuring thorough validation and documentation.

Applicants must have proven experience with T-SQL, BigQuery, and Dataform, and be located in the UK. The engagement is fully remote with a fixed term until 30 September 2026.

Qualifications

• Deep, production T-SQL experience, including stored procedures, CTEs, cursors, dynamic SQL, and window functions.
• Hands-on experience with BigQuery SQL and Dataform.
• Experience porting procedural SQL logic to declarative models in a migration context.

Responsibilities

• Audit all 157 stored procedures categorized by complexity tier.
• Reverse-engineer and document the business logic of each procedure.
• Build all Dataform SQL models with peer review against original outputs.

Skills

T-SQL

BigQuery SQL

Dataform

Data validation

Documentation

Communication with stakeholders

SQL migration experience

Job description

Adroit Cloud Consulting Limited is seeking a contractor for a confidential client project focused on Azure to GCP data platform migration in the UK. The role involves auditing and converting T-SQL stored procedures into BigQuery and Dataform pipelines, ensuring thorough validation and documentation.

Applicants must have proven experience with T-SQL, BigQuery, and Dataform, and be located in the UK. The engagement is fully remote with a fixed term until 30 September 2026.