Blend
Website:
blend360.com
Job details:
Blend is a premier AI services provider, committed to creating meaningful impact for its clients through the power of data science, AI, technology, and people. We help organisations solve complex business challenges by combining deep domain understanding with modern data and AI capabilities. Our teams work across strategy, analytics, engineering, and product delivery to create scalable, high-value solutions that improve decision-making, efficiency, and growth.
Job Description
We are looking for an experienced Data Engineer to support the delivery of a large-scale enterprise systems integration programme for a leading facilities management client. Working alongside .NET Integration Engineers, you will be responsible for the data layer of the integration, connecting to source systems, profiling and transforming data, and ensuring clean, well-structured payloads flow through the event-driven Azure Integration Hub.
In addition to adapter-level data work, you will build batch ingestion pipelines into the client's Databricks-based data platform and help establish the data interfaces required for the enterprise MDM implementation. The ideal candidate combines strong hands-on data engineering skills with practical experience connecting to complex enterprise application landscapes and working within structured delivery programmes.
Responsibilities
Source Connectivity & Data Profiling
Establish and validate connections to in-scope enterprise source systems spanning HR, payroll, recruitment, ERP, CRM, procurement, CAFM, field service, fleet, and QHSE platforms, covering a range of connectivity patterns including REST APIs, SOAP/XML, database connectors, and file-based extracts
Conduct data profiling across source systems to assess data quality, volumes, formats, and structures, documenting findings and working with business stakeholders to define and implement automated data quality tests
Adapter Data Layer & Transformation
Design and implement the data transformation logic within integration adapters, including field-level mappings, canonical format conversions, data type handling, and enrichment rules as defined in approved Integration Design Documents
Implement data validation rules within adapters to enforce mandatory field checks, referential integrity, and format compliance before payloads are published to the Service Bus, supporting robust error handling and exception workflows
Batch Ingestion into the Data Platform
Build and maintain batch ingestion pipelines from in-scope source systems into the client's Databricks-based data platform, covering Bronze (raw), Silver (cleansed and standardised), and Gold (business-ready) layers as required
Configure pipeline orchestration, scheduling, incremental load patterns, and error handling to ensure reliable, repeatable data delivery into the lakehouse environment
MDM Data Interfaces
Design and implement data feeds between source systems and the enterprise MDM platform, supporting the ingestion of master data records for domains including Customer, Supplier, Employee, Site, and Project
Work with the MDM workstream and data stewards to align source data structures with MDM domain models, supporting match and merge configuration, survivorship rule testing, and the propagation of mastered data back to consuming systems
Support the reference data wave by preparing and loading initial reference datasets into the MDM platform, ensuring data is cleansed, mapped, and validated prior to ingestion
Collaboration & Governance
Contribute to CI/CD pipelines, source control, and documentation standards, ensuring all data engineering artefacts are production-grade and handed over to the client team with appropriate runbooks and operational guides
Qualifications
Strong experience connecting to enterprise application APIs and databases, including REST, SOAP/XML, JDBC/ODBC, and file-based extraction patterns
Experience with dbt (Core or Cloud) for SQL-based transformation and data modelling within a lakehouse environment
Understanding of data mapping, canonical data modelling, and transformation design for multi-system integration landscapes
Experience working to build-ready technical specifications and contributing to formal design and testing processes within a structured delivery programme
Strong communication skills and ability to engage with both technical and business stakeholders on data quality and mapping decisions
Additional Information
Click on Apply to know more.