GraphDB Architect

EXL; India; On-site; INR 300,000 - 520,000; Full time

Job summary

EXL is seeking a senior data engineer focused on building and optimizing an entity graph. The role involves implementing a graph schema, projecting relational data into graph structures, and developing scalable loading pipelines.

You will model complex relationships including ownership and affiliations, and craft efficient multi-hop traversals with GQL/Cypher-like queries. Experience with PySpark, SQL, and GraphRAG concepts is preferred.

Qualifications

• 7+ years data engineering experience with 3+ years hands-on graph database development.
• Proven experience modelling and loading a production graph from relational sources.
• Strong graph query language proficiency (GQL, Cypher or Gremlin).
• Solid PySpark and SQL engineering skills.
• Experience with hierarchical/ownership data structures and recursive relationships.

Responsibilities

• Graph schema implementation as defined by the architect: node types, edge types, properties, keys and constraints.
• Relational-to-graph projection: convert canonical relational entity tables into graph nodes and edges with source attribution.
• Graph loading & pipelines: develop and optimise load processes; implement incremental re-projection triggered by CDC.
• Relationship modelling: implement entity-to-entity, ownership, officer/director and affiliation relationships including bitemporal handling.
• Traversal & query engineering: write and optimise graph queries (GQL/Cypher-style) for multi-hop traversal like family trees and affiliations.
• Performance optimisation: tune graph queries and load performance; profile traversal cost; address scale bottlenecks.
• Graph quality validation: automated checks on node/edge counts, orphan detection, relationship integrity and source traceability.
• Consumption support: expose graph data via API and SQL endpoints; collaborate on GraphRAG indexing over projections.

Skills

Data engineering

Graph database

GQL/Cypher/Gremlin

PySpark

SQL

Hierarchical data

Tools

Microsoft Fabric Graph

Job description

Build the Entity Graph. This role converts the resolved, canonical entity data into a production graph implementing node and edge projections, loading and optimising the graph, enabling multi-hop traversal, and validating that the graph faithfully represents entity, ownership and affiliation relationships back to source.

Key Responsibilities

• Graph schema implementation implement the graph schema defined by the architect: node types, edge types, properties, keys and constraints.
• Relational-to-graph projection build and operate the projection logic that converts canonical relational entity tables into graph nodes and edges, with full source attribution.
• Graph loading & pipelines — develop and optimise graph load processes; implement incremental re-projection triggered by change data capture.
• Relationship modelling — implement entity-to-entity, ownership (parent/subsidiary), officer/director and affiliation relationships, including bitemporal handling where required.
• Traversal & query engineering — write and optimise graph queries (GQL/Cypher-style) supporting multi-hop traversal scenarios such as corporate family trees and shared-agent affiliations.
• Performance optimisation — tune graph queries and load performance; profile traversal cost; address scale bottlenecks.
• Graph quality validation — implement automated checks on node/edge counts, orphan detection, relationship integrity and source traceability.
• Consumption support — support exposure of graph data through API and SQL endpoints, and collaborate on GraphRAG indexing over graph projections.

Must-Have Qualifications

• 7+ years data engineering with 3+ years hands-on graph database development
• Proven experience modelling and loading a production graph from relational sources
• Strong graph query language proficiency (GQL, Cypher or Gremlin)
• Solid PySpark and SQL engineering skills
• Experience with hierarchical/ownership data structures and recursive relationships

Nice-to-Have

• Microsoft Fabric Graph experience (native LPG on OneLake)
• Exposure to GraphRAG or graph-based retrieval
• Experience in corporate entity, KYC, fraud-network or supply-chain graph domains
• Graph algorithms (community detection, centrality, shortest path)
• Implemented graph schema and node/edge projection logic
• Baseline entity graph populated in Fabric
• Incremental re-projection on CDC
• Graph quality validation checks and performance tuning results