Logo for Charles River Development

IAM Data Engineer, AVP

Roles & Responsibilities

  • 7–10 years of experience in data engineering or related roles, delivering scalable, enterprise-grade data solutions in fast-paced environments.
  • Strong SQL and schema design for AWS RDS (PostgreSQL/MySQL) and hands-on graph DB modeling with AWS Neptune/Neo4J.
  • Proficiency in Databricks or Snowflake (PySpark) and Python; familiarity with GraphRAG concepts, embeddings, and vector search.
  • Master’s or Bachelor’s degree in Computer Science or Engineering; experience managing/mentoring teams and leading multiple projects; excellent analytical and communication skills.

Requirements:

  • Design relational schemas in AWS RDS and graph models in AWS Neptune/Neo4J; develop warehouse/lakehouse schemas in Databricks Delta Lake or Snowflake for analytics and ML.
  • Implement GraphRAG by building graph-based retrieval, generating embeddings, and managing hybrid retrieval pipelines (graph + vector) and integration with vector search.
  • Build ETL/ELT pipelines using Snowflake/Databricks, Airflow, and AWS Glue; ensure data quality, consistency, freshness, and performance optimization for GraphDB, RDS, and data warehousing; meet SLAs.
  • Collaborate with data scientists/AI engineers and development teams to support knowledge graph and RAG workflows; document data models and maintain governance standards.

Job description

Who we are looking for

State Street cyber architecture & engineering is looking for for a Senior Data Engineer to design and implement data models across relational, graph, and lakehouse systems using AWS RDS, AWS Neptune/Neo4J, and Databricks/Snowflake. 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 or Snowflake 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 pipelines using Snowflake/Databricks, Airflow and other AWS Service such as Glue.
    • Ensure data quality, consistency, and freshness across systems.
  • Performance & Optimization
    • Tune queries and optimize storage for GraphDB, RDS, Data warehousing.
    • Support Data Environments to ensure the SLA’s (uptime and performance) are met
  • Collaboration
    • Work with data scientists/AI engineers/Development eams 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.

  • 7–10 years of experience in data engineering or similar roles.
  • Strong SQL and schema design for AWS RDS (PostgreSQL/MySQL) to support enterprise applications.
  • Strong experience in building Enterprise Warehousing solutions
  • Hands-on experience with a GraphDB modeling and expsousre to AWS Neptune or Neo4J
  • Proficiency in Databricks or Snowlake, PySpark,
  • Familiarity with GraphRAG concepts, embeddings, and vector search.
  • Strong Programming experience 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.
  • Strong Exposure to Cloud Environment (AWS)
  • Snowflake or Databricks certifications are a plus.

About State Street

Across the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success.

We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential. As an essential partner in our shared success, you’ll benefit from inclusive development opportunities, flexible work-life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future.

As an Equal Opportunity Employer, we consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law.

Discover more information on jobs at StateStreet.com/careers

Read our CEO Statement

Data Engineer Related jobs

Other jobs at Charles River Development

We help you get seen. Not ignored.

We help you get seen faster — by the right people.

🚀

Auto-Apply

We apply for you — automatically and instantly.

Save time, skip forms, and stay on top of every opportunity. Because you can't get seen if you're not in the race.

AI Match Feedback

Know your real match before you apply.

Get a detailed AI assessment of your profile against each job posting. Because getting seen starts with passing the filters.

Upgrade to Premium. Apply smarter and get noticed.

Upgrade to Premium

Join thousands of professionals who got noticed and hired faster.