IAM IGA Data Engineer, Assistant Vice President

Jobtailor; Connecticut; On-site; USD 130,000 - 190,000; Full time

Job summary

Jobtailor is seeking a senior data engineer to design and implement scalable data models across relational, graph, and lakehouse platforms. You will work with AWS Neptune, RDS, and Databricks to build analytics-ready warehouses and support AI/ML use cases.

Collaborate with data scientists and AI engineers to advance knowledge graph initiatives, embeddings, and hybrid retrieval pipelines. You will mentor teammates and help govern data architecture and SDLC practices.

Qualifications

• Master’s or Bachelor’s Degree in Computer Science or engineering
• 7–10 years of experience delivering scalable, enterprise-grade data solutions
• Experience in leading and mentoring team members
• Excellent analytical and interpersonal skills
• Strong verbal, written communication and presentation skills
• Experience implementing large incident and change management processes
• Experience managing diverse, geographically located teams and championing customer satisfaction
• Experience in IAM products
• Experience in SDLC engagements from requirements to deployment and support
• 3–5 years of data engineering or similar roles
• Strong SQL and schema design for AWS RDS (PostgreSQL/MySQL)
• Hands-on experience with AWS Neptune (Gremlin/SPARQL) and graph modeling
• Proficiency in Databricks, PySpark, and Delta Lake
• Familiarity with GraphRAG concepts, embeddings, and vector search
• Python for data pipelines and API integration

Responsibilities

• Design and implement data models across relational, graph, and lakehouse systems using AWS RDS, AWS Neptune, and Databricks
• Develop warehouse/lakehouse schemas in Databricks Delta Lake for analytics and ML
• Implement graph-based retrieval and integrate with vector search for AI use cases
• Generate embeddings and manage hybrid retrieval pipelines (graph + vector)
• Build ETL/ELT workflows using Databricks (PySpark), Airflow, or AWS Glue
• Ensure data quality, consistency, and freshness across systems
• Tune queries and optimize storage for Neptune, RDS, and Delta Lake
• Work with data scientists and AI engineers to support knowledge graph and RAG workflows
• Document data models and maintain governance standards

Skills

data modeling

ETL

ELT

SQL

schema design

graph modeling

Python

PySpark

embeddings

vector search

communication skills

presentation skills

Education

Master’s Degree in Computer Science

Bachelor’s Degree in Computer Science

Tools

AWS Neptune (Gremlin/SPARQL)

Databricks

Delta Lake

PySpark

Python

Airflow

AWS Glue

Job description

Responsibilities

• Design and implement data models across relational, graph, and lakehouse systems using AWS RDS, AWS Neptune, and Databricks
• Develop warehouse/lakehouse schemas in Databricks Delta Lake for analytics and ML
• Implement graph-based retrieval and integrate with vector search for AI use cases
• Generate embeddings and manage hybrid retrieval pipelines (graph + vector)
• Build ETL/ELT workflows using Databricks (PySpark), Airflow, or AWS Glue
• Ensure data quality, consistency, and freshness across systems
• Tune queries and optimize storage for Neptune, RDS, and Delta Lake
• Work with data scientists and AI engineers to support knowledge graph and RAG workflows
• Document data models and maintain governance standards

Requirements

• Master’s or Bachelor’s Degree in Computer Science or engineering
• 7–10 years of experience in data analysis, data model design, and implementation to deliver scalable, enterprise-grade data solutions in a fast-paced environment
• Manage/mentor team members, and provide training as required
• Excellent analytical and interpersonal skills
• Excellent verbal, written communication and presentation skills
• Very strong practical experience in implementing large mature incident and change management processes
• Team player, Ethical, Self-driven and self‑motivated, goal and results oriented
• Experience in building, managing diverse geographically located teams and championing customer satisfaction
• Experience in support or implementation of IAM products
• Experience in implementing SDLC engagements projects, that must include activities such as requirements gathering, analysis, design, development, testing, deployment and application support
• 3–5 years of experience in data engineering or similar roles
• Strong SQL and schema design for AWS RDS (PostgreSQL/MySQL)
• Hands‑on experience with AWS Neptune (Gremlin/SPARQL) and graph modeling
• Proficiency in Databricks, PySpark, and Delta Lake
• Familiarity with GraphRAG concepts, embeddings, and vector search
• Programming in Python for data pipelines and API integration

Certifications & Qualifications

• Master’s Degree in Computer Science
• Bachelor’s Degree in Computer Science

Hard Skills

• data modeling
• ETL
• ELT
• SQL
• schema design
• graph modeling
• Python
• PySpark
• embeddings
• vector search

Soft Skills

• analytical skills
• interpersonal skills
• communication skills
• presentation skills
• team player
• self‑driven
• goal oriented
• results oriented
• mentoring
• customer satisfaction