IAM IGA Data Engineer, Assistant Vice President

Who we are looking for

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.

What you will be responsible for

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

What we value

These skills will help you succeed in this role

• Strong communication skills to promote critical wins and new behaviors throughout the
  organization
• proven ability to manage multiple projects simultaneously
• Self-starter with a keen sense of ownership and commitment to work, and passion for
  delivering results.

Education & Preferred Qualifications

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

Required Skills.

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

Additional Preferred Experience

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

Are you the right candidate? Yes!

We truly believe in the power that comes from the diverse backgrounds and experiences our employees bring with them. Although each vacancy details what we are looking for, we don’t necessarily need you to fulfil all of them when applying. If you like change and innovation, seek to see the bigger picture, make data driven decisions and are a good team player, you could be a great fit.

Why this role is important to us

Our technology function, Global Technology Services (GTS), is vital to State Street and is the key enabler for our business to deliver data and insights to our clients. We’re driving the company’s digital transformation and expanding business capabilities using industry best practices and advanced technologies such as cloud, artificial intelligence and robotics process aut