Data Engineer (Databricks), Assistant Vice President

Data Engineer (Databricks), Assistant Vice President

Corporate Functions Technology (Legal & Security)

Who We Are Looking For

We are seeking aData Engineer to design, build, and support a modern Legal Data Lakehouse platform on AWS and Databricks. This role will focus on developing scalable, high‑performance data pipelines and enabling trusted, governed data capabilities supporting legal operations, compliance analytics, reporting, and AI/ML use cases.

The ideal candidate brings strong hands-on experience in Databricks, AWS data platforms, and enterprise data engineering practices, with experience delivering solutions in regulated environments aligned to security, compliance, and audit requirements.

Why This Role Is Important to Us

State Street's Legal, Security, and Compliance functions operate across contracts, matters, regulatory obligations, documents, and workflows distributed across multiple systems. Building robust data pipelines ensures data is accessible, reliable, and usable for analytics and decision-making.

This role is critical to enabling a scalable and governed data foundation supporting legal analytics and operational reporting while strengthening data quality, auditability, and consistency.

What You Will Be Responsible For

Software Development

• Design, build, and maintain scalabledata pipelines usingPySpark, Python, and Spark SQL
• Develop and optimizeETL/ELT workflows onDatabricks using Delta Lake
• ImplementLakehouse architecture (Bronze/Silver/Gold layers) for enterprise data platforms
• Build and manageDatabricks Jobs, Workflows, and Notebooks for batch and streaming workloads
• Develop reusable frameworks fordata ingestion, processing, and orchestration
• Containerize data workloads usingDocker and automate processes via scripting
• Integrate Databricks data pipelines withPower Platform solutions (Power Apps, Power Automate)
• Enable data exposure for business users viaAPIs, connectors, and curated datasets

Data Platform & Database Management

• Design and optimizedata lakehouse architectures using Databricks
• Integrate data fromSQL Server, Oracle, and other enterprise source systems
• Apply advanceddata modeling techniques (dimensional modeling, partitioning, optimization)
• Work with structured and semi-structured data (e.g., JSON, Parquet)
• Tune performance using caching, indexing, and Spark optimization techniques
• Publish curated datasets for consumption inPower BI dashboards/ Power Apps / Power Automate workflows

Testing & Troubleshooting

• Ensure data quality usingunit testing, validation frameworks, and automated checks
• Monitor and troubleshootdistributed Spark workloads and pipelines
• Analyze logs and resolve production issues acrossDatabricks and cloud environments
• Maintain data lineage, consistency, and audit readiness

Ownership & Collaboration

• Collaborate withLegal, Security, Compliance, and Enterprise Data teams to deliver scalable solutions
• Translate business requirements intorobust data engineering designs
• Act as aSubject Matter Expert (SME) in Databricks and Lakehouse architecture
• Lead initiatives with minimal supervision and take full ownership of deliverables

Governance, Security & Compliance

• Support implementation ofdata governance frameworks usingDatabricks Unity Catalog and AWS controls (IAM, KMS)
• Ensure adherence to:
  • Data privacy and regulatory requirements (e.g., GDPR)
  • Internal security and audit standards
• Implement and maintain:
  • Data access controls
  • Data classification and handling standards
• Collaborate with IAM and security teams to ensure secure data access

Delivery & Documentation

• Design and maintainCI/CD pipelines using Harness, Azure DevOps, or GitHub
• Automate deployment of Databricks assets usingDatabricks Repos and CLI
• Monitor, schedule, and optimize workflows usingDatabricks orchestration tools
• Maintain clear documentation includingarchitecture, data flows, and runbooks
• Continuously improve performance, scalability, and cost efficiency

What We Value

The skills that will help you succeed in this role include:

• Strong analytical thinking andproblem-solving skills
• Hands-on expertise indata engineering and distributed data processing
• Ability to work in afast-paced, enterprise environment
• Effective communication and collaboration with cross-functional teams
• Ownership mindset with focus onquality, scalability, and performance

Education & Preferred Qualifications

Education

• Bachelor's or Master's degree in computer science, Data Engineering, Information Systems, or a related technical discipline

Required Qualifications

• 8+ years of experience inData Engineering or data platform development
• Strong hands-on experience withDatabricks and Apache Spark
• Proficiency inPySpark, Python, and SQL
• Experience withAWS data platform services, including:
  • S3
  • Glue
  • Lambda
  • IAM
• Experience working withDelta Lake and lakehouse architecture
• Solid understanding of:
  • Distributed data processing
  • ETL/ELT frameworks
  • Data modeling techniques

Preferred Qualifications (Core – Databricks, AWS, Data Lakehouse)

• Hands-on experience withDatabricks platform components (Delta Lake, Workflows, Unity Catalog)
• Strong experience buildingend-to-end data pipelines (batch and streaming) using AWS and Databricks
• Familiarity withperformance optimization techniques in Spark and Delta Lake
• Experience supportinganalytics, reporting, or AI/ML use cases on a lakehouse platform
• Understanding ofdata governance, metadata management, and security controls

Nice to Have (Domain & Industry Experience)

• Experience inLegal, Compliance, Financial Services, or regulated industries
• Understanding of legal data constructs such ascontracts, clauses, obligations, and matters
• Exposure tounstructured data processing or document/NLP pipelines
• Experience withPower BI, Power Apps, or Power Platform
• Experience handlingsensitive data in audit-driven environments

Salary Range:

The range quoted above applies to the role in the primary location specified. If the candidate would ultimately work outside of the primary location above, the applicable range could differ.

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.

For a full overview, visithttps://hrportal.ehr.com/statestreet/Home.

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 atStateStreet.com/careers

Read ourCEO Statement

Job Application Disclosure:

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.