Data Integration Engineer (Databricks / Python / SQL)

About Gramian

Gramian Consultancy is a boutique consultancy specializing in IT professional services and engineering talent solutions. With a strong background in software engineering and leadership, we help companies build high-performing teams by matching them with professionals who truly fit their needs.

About the Role

Our client is a Big4 Consultancy group that works with leading financial institutions on AI-driven transformation, automation, advanced analytics, and financial crime prevention . Their are building a production-grade AI-assisted KYC / Customer Due Diligence platform for an international insurance environment.

We are looking for an experienced Data / Integration Engineer to own the data flowing into and out of the platform. The role focuses on Databricks, Python / PySpark, SQL, data modelling, data contracts, APIs, legacy-system integration, and data quality , replacing mocked sources with reliable production integrations.

CONTRACT: B2B or B2C contract

COMMITMENT: Full-time, 3-4 months contract with possibility of extension or getting on new projects

LOCATIONS: Remote, EU-based candidates

START: ASAP

PROCESS: Initial qualification followed by client interviews

Responsibilities

• Inventory and map all internal and external data sources.

• Define data contracts and canonical data structures for client, screening, evidence, audit, and reporting data.

• Build connectors to external screening providers, public registers, and local data sources.

• Connect Databricks with SQL Server, legacy databases, and core enterprise systems.

• Support API, database-link, batch, file, and SFTP-based integrations.

• Design and maintain data models supporting evidence, audit trails, and reporting.

• Implement data quality checks, contract tests, and retention rules .

• Validate incoming and outgoing data flows across production services.

• Support integration troubleshooting and production-readiness activities.

• Contribute to a business-critical platform where data accuracy and reliability are essential.

Requirements

• Strong hands-on experience with Databricks , including Delta Lake and Unity Catalog.

• Strong experience with Python / PySpark .

• Advanced SQL skills.

• Experience integrating with SQL Server and legacy databases .

• Strong experience with REST APIs, DB links, batch processing, files, and SFTP integrations .

• Experience with data modelling and data-contract design .

• Experience implementing data-quality validation and integration testing.

• Fluent English and ability to work remotely within the EU.