IAM IGA Data Engineer, Assistant Vice President

State Street

Data Engineer at State Street responsible for designing and implementing scalable data models. Collaborating with AI teams to deliver secure and high-performance data solutions in a hybrid environment.

Posted 6/26/2026full-timePrinceton • Connecticut, Massachusetts, New Jersey • 🇺🇸 United StatesLead💰 $100,000 - $167,500 per yearWebsite

Tech Stack

Tools & technologies

AirflowAWSETLMySQLPostgresPySparkPythonSDLCSQL

About the role

Key responsibilities & impact

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

What you’ll need

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

Benefits

Comp & perks

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)
Eligibility for certain tax advantaged savings plans

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data modelingETLELTSQLschema designgraph modelingPythonPySparkembeddingsvector search

Soft Skills

analytical skillsinterpersonal skillscommunication skillspresentation skillsteam playerself-drivengoal orientedresults orientedmentoringcustomer satisfaction

Certifications

Master’s Degree in Computer ScienceBachelor’s Degree in Computer Science