Job Description

Job Title:

Database Engineer

Position Type:

Full-Time, Remote

Working Hours:

U.S. Business Hours (CST)

About the Role:

Our client builds advanced data intelligence systems that map complex ownership, legal, and property relationships using graph technology. Neo4j powers their knowledge graph and enables highly connected data to be represented with accuracy, speed, and traceability.



We are seeking a Neo4j Database Engineer who will own the graph data model, optimize Cypher queries, and build strong data ingestion pipelines. This role is mission-critical in defining how the system structures, connects, and analyzes data across people, properties, documents, transactions, and events.

Key Responsibilities:

1. Graph Data Modeling & Architecture

Design, refine, and maintain Neo4j data schemas Ensure entity relationships are consistent, normalized, and high-performing Implement schema updates aligned with business and technical needs

2. Ownership & Relationship Computation

Implement logic to compute/update ownership changes over time Maintain transitions, transfers, and events through optimized structures

3. Cypher Query Design & Optimization

Build, test, and optimize Cypher queries for traversal, lineage, and aggregations Develop Cypher scripts for migrations and large-scale operations Use PROFILE/EXPLAIN and best practices to improve performance

4. Integration & Data Ingestion

Build reliable Python-based ingestion pipelines (neo4j-driver, py2neo) Integrate Neo4j with APIs, SQL databases, and analytical systems Collaborate with teams to onboard new data sources

5. Governance & Validation

Implement validation rules, constraints, and QA checks Ensure auditability, version control, and schema compliance

Required Skills & Experience:

1. Core Expertise

3+ years hands-on with Neo4j (modeling + querying) Strong SQL/NoSQL database design background

2. Querying

Expert-level Cypher (path queries, pattern comprehension, aggregations)

3. Data Modeling

Graph normalization, temporal modeling, event-sourced architectures

4. Programming

Strong Python skills for ingestion, automation, and processing

5. Nice to Have

Experience with Dockerized Neo4j, APOC, pipeline automation

What You'll Do:

Serve as the primary graph architect Build scalable graph logic to compute complex real-world relationships Contribute to an AI-driven intelligence platform foundation

Key Performance Indicators (KPIs):

1. Query Optimization

20-30% reduction in Cypher execution time Effective profiling and refactoring of traversals and aggregations

2. Data Model Quality

Zero critical integrity issues On-time schema updates within sprint cycles Efficient addition of new entity types

3. Pipeline Reliability

99% success rate for Python-based ingestion Minimal downtime or ingestion failures Clean integration with external sources

4. Overall Delivery

Meeting milestones (ownership computation, migrations, validations) Strong sprint velocity and low bug rates

5. Data Governance

Validation errors under 1% Full compliance with constraints and auditability

Interview Process:

Initial Phone Screen Technical Interview with Pavago Recruiter Practical Task (schema design or query optimization) Final Client Interview * Offer & Background Verification