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.