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. • 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.