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.