Database Engineer

pavago; Pakistan; Remote; PKR 16,939,000 - 22,587,000; Full time

Job summary

A leading data analytics company is seeking a Database Engineer specializing in Neo4j to develop and manage complex graph data models. This role involves optimizing Cypher queries, building reliable data ingestion pipelines, and ensuring data integrity. Ideal candidates will have over 3 years of Neo4j experience and strong Python skills. The position is full-time and remote, aligning with U.S. business hours.

Qualifications

• 3+ years hands-on experience with Neo4j (modeling and querying).
• Expert-level knowledge of Cypher for advanced database operations.
• Strong Python skills for data ingestion and automation.

Responsibilities

• Design and maintain Neo4j data schemas and graph models.
• Optimize Cypher queries for better performance.
• Build Python-based data ingestion pipelines.

Skills

Neo4j expertise

SQL/NoSQL design

Cypher querying

Data modeling

Python programming

Tools

Neo4j

Python

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

#LI-AG1