IAM IGA Data Engineer, Assistant Vice President

State Street • Quincy, MA

30d • Hybrid

About The Position

State Street cyber architecture & engineering is looking for for a Data Engineer to design and implement data models across relational, graph, and lakehouse systems using AWS RDS, AWS Neptune, and Databricks. This role will also contribute to AI enablement by building GraphRAG (Graph Retrieval-Augmented Generation) pipelines that power intelligent search and LLM-based applications. You’ll work closely with senior engineers and AI teams to deliver scalable, secure, and high-performance data solutions. This role can be performed in a hybrid model, where you can balance work from home and office to match your needs and role requirements.

Requirements

• 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.

Nice To Haves

• Experience with LangChain or LlamaIndex for RAG workflows.
• Knowledge of graph algorithms, entity linking, and semantic search.
• Exposure to OpenSearch, FAISS, or Databricks Vector Search.
• AWS/Databricks certifications are a plus.

Responsibilities

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

Benefits

• Employees are eligible to participate in State Street’s comprehensive benefits program, which includes: our retirement savings plan (401K) with company match; insurance coverage including basic life, medical, dental, vision, long-term disability, and other optional additional coverages; paid-time off including vacation, sick leave, short term disability, and family care responsibilities; access to our Employee Assistance Program; incentive compensation including eligibility for annual performance-based awards (excluding certain sales roles subject to sales incentive plans); and, eligibility for certain tax advantaged savings plans.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees