Data Engineer (Databricks), Assistant Vice President

State Street is seeking an experienced Data Engineer to help design, build, and support a Legal Data Lakehouse platform on AWS and Databricks for legal operations and compliance analytics. In this onsite role in Quincy, MA, you will focus on scalable data pipelines, governance, and trusted data capabilities that enable reporting and AI/ML use cases.

You will operate across the full lakehouse lifecycle, from ingestion and orchestration to performance tuning, monitoring, and audit readiness, while partnering with Legal, Security, Compliance, and Enterprise Data teams. The work includes implementing data access controls, supporting data privacy and regulatory standards, and translating business requirements into engineering designs.

What you’ll do

• Design, build, and maintain scalable data pipelines using PySpark, Python, and Spark SQL
• Develop and optimize ETL/ELT workflows on Databricks using Delta Lake
• Implement lakehouse architecture using Bronze/Silver/Gold layers for enterprise data platforms
• Build and manage Databricks Jobs, Workflows, and Notebooks for batch and streaming workloads
• Create reusable frameworks for data ingestion, processing, and orchestration
• Containerize data workloads with Docker and automate processes via scripting
• Integrate Databricks pipelines with Power Platform solutions including Power Apps and Power Automate
• Expose data for business users through APIs, connectors, and curated datasets
• Integrate data from SQL Server, Oracle, and other enterprise source systems
• Apply advanced data modeling techniques such as dimensional modeling, partitioning, and optimization
• Work with structured and semi-structured data including JSON and Parquet
• Tune performance using caching, indexing, and Spark optimization techniques
• Publish curated datasets for consumption in Power BI dashboards and Power Apps / Power Automate workflows
• Ensure data quality using unit testing, validation frameworks, and automated checks
• Monitor and troubleshoot distributed Spark workloads and pipelines, analyzing logs to resolve production issues across Databricks and cloud environments
• Maintain data lineage, consistency, and audit readiness
• Support data governance using Databricks Unity Catalog and AWS controls such as IAM and KMS
• Ensure adherence to data privacy and regulatory requirements (including GDPR) and internal security and audit standards
• Design and maintain data access controls and data classification and handling standards
• Collaborate with IAM and security teams to enable secure data access
• Design and maintain CI/CD pipelines using Harness, Azure DevOps, or GitHub
• Automate deployment of Databricks assets using Databricks Repos and Databricks CLI
• Maintain clear documentation including architecture, data flows, and runbooks
• Continuously improve performance, scalability, and cost efficiency

Key technologies

• Databricks, AWS, PySpark, Python, Spark SQL
• ETL/ELT, Delta Lake, Lakehouse architecture (Bronze/Silver/Gold layers)
• Databricks Jobs, Databricks Workflows, Notebooks
• Docker, Power Platform (Power Apps, Power Automate), APIs, Connectors, Power BI
• SQL Server, Oracle, JSON, Parquet
• Unit testing, Validation frameworks, Databricks Unity Catalog
• IAM, KMS, GDPR
• CI/CD pipelines with Harness, Azure DevOps, or GitHub; Databricks Repos; Databricks CLI
• S3, Glue, Lambda

What you bring

• 8+ years of experience in Data Engineering or data platform development
• Strong hands-on experience with Databricks and Apache Spark
• Proficiency in PySpark, Python, and SQL
• Experience with AWS data platform services including S3, Glue, Lambda, and IAM
• Experience with Delta Lake and lakehouse architecture
• Solid understanding of distributed data processing and ETL/ELT frameworks
• Solid understanding of data modeling techniques

Education

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

Compensation and location

• Location: Quincy, MA (onsite)
• Salary: USD 110,000 - 177,500 per year

Benefits

• 401(k) 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 the Employee Assistance Program
• Incentive compensation eligibility for annual performance-based awards (excluding certain sales roles subject to sales incentive plans)
• Eligibility for certain tax-advantaged savings plans