Lead Data Engineer - Assistant Vice President
State Street
An application made for this job — a tailored resume and cover letter that speak straight to the posting.
Job summary
State Street seeks a Senior Data Engineer / SME to join the SSIM Business Architecture vertical in a hands-on IC role. Leverage Databricks, Python, PySpark, AWS, and SQL to design and scale production-grade data pipelines and cloud data solutions. Snowflake experience is desirable.
Role located in Bengaluru with hybrid work (4 days in office) and flexible hours to align with US stakeholders. Strong ownership and engineering best practices are required.
Qualifications
- Strong hands-on experience in data engineering and building production-grade pipelines.
- Deep expertise with Databricks, Python, PySpark, AWS and SQL in cloud environments.
- Proven ability to own complex data solutions from design to production.
- Experience in enterprise-grade data integration and data lakehouse architectures.
- Familiarity with CI/CD and modern engineering practices.
Responsibilities
- Design, develop, and maintain scalable ETL/ELT pipelines.
- Build and optimize data processing using Python and PySpark.
- Develop and support production-grade workloads on Databricks.
- Design and implement cloud-native data solutions on AWS.
- Collaborate with architecture, security, and business teams to deliver enterprise data solutions.
- Drive automation, standardization, and continuous improvement across the data landscape.
- Provide technical guidance, design reviews, and code reviews.
Skills
Education
Tools
Job description
We are seeking a Senior Data Engineer / SME to join the SSIM Business Architecture vertical in a hands-on Individual Contributor (IC) role. The role requires strong expertise in Databricks, Python, PySpark, AWS, and SQL to design, build, and support scalable, production-grade data pipelines and cloud data solutions. Snowflake and enterprise data integration experience are desired. The successful candidate will demonstrate strong technical ownership, problem-solving skills, and engineering best practices across the data ecosystem.
Role location : Bangalore
- Business Architecture: The role sits within the SSIM Business Architecture vertical and requires close collaboration with Architecture, Security, engineering, platform, and business technology stakeholders.
- Hybrid working: The role requires 4 days per week working from the office, in line with the applicable workplace expectations.
- Working hours: The primary working window will be 12:00 PM to 9:00 PM India time, providing alignment with US stakeholders and teams.
- Flexibility: Given the enterprise and production nature of the role, the individual must be flexible to work outside standard hours and, where required, over weekends to support critical deliveries, production issues, releases,DR or other business needs.
- Design, develop, and maintain scalable ETL/ELT, data ingestion, and transformation pipelines.
- Build and optimize data processing solutions using Python and PySpark.
- Develop and support production-grade workloads and pipelines on Databricks.
- Design and implement cloud-native data engineering solutions on AWS.
- Work with large-scale structured and unstructured datasets.
- Optimize Spark and Databricks workloads for performance, scalability, reliability, and cost efficiency.
- Develop reusable data engineering components, frameworks, and engineering patterns.
- Implement data quality, validation, reconciliation, and monitoring controls.
- Troubleshoot complex production issues, perform root cause analysis, and implement sustainable fixes.
- Support CI/CD, testing, deployment, monitoring, and operational reliability.
- Act as a Data Engineering SME, providing technical guidance, design reviews, and code reviews.
- Collaborate with architecture, application, cloud, platform, and business teams to deliver enterprise data solutions.
- Drive automation, standardization, and continuous improvement across the data engineering landscape.
- Strong hands-on experience in Data Engineering.
- Strong hands-on experience with Databricks.
- Advanced programming skills in Python and PySpark.
- Strong experience with AWS cloud-based data engineering.
- Strong proficiency in SQL.
- Experience designing and supporting enterprise ETL/ELT and data pipelines.
- Strong understanding of Apache Spark and distributed data processing.
- Experience with data lake and lakehouse architecture.
- Strong understanding of data modeling, data integration, and data quality principles.
- Experience with CI/CD and modern engineering practices.
- Experience supporting business-critical production data platforms.
- Strong troubleshooting, debugging, and root cause analysis skills.
- Strong communication and stakeholder-management capabilities.
- Experience with Snowflake data engineering and integration.
- Knowledge of Snowflake databases, schemas, warehouses, security, and performance optimization.
- Experience integrating Databricks/AWS data pipelines with Snowflake.
- Experience with GoldenGate, AWS DMS, or similar data replication technologies.
- Knowledge of data governance, lineage, metadata management, and auditing.
- Experience with data quality and reconciliation frameworks.
- Exposure to enterprise monitoring and observability solutions.
- Experience working in financial services or other regulated environments.
- 10+ years of overall experience in software engineering, data engineering, or related technology roles.
- 8+ years of hands-on data engineering & Devops experience.
- 7+ years of relevant experience across Databricks, PySpark/Spark, and cloud-based data engineering preferred.
- Proven experience designing, developing, and supporting enterprise-scale production data pipelines and platforms.
- Demonstrated ability to operate as a hands-on technical SME in complex enterprise environments.
- Bachelor’s degree in Computer Science, Information Technology, Engineering, Data Science, or a related technical discipline.
- Master’s degree in a relevant discipline is desirable.
Databricks | Python | PySpark | AWS | SQL | Apache Spark | ETL/ELT | Data Pipelines | Data Lake/Lakehouse
Snowflake | GoldenGate | AWS DMS | Data Governance | Data Lineage | Data Quality | Observability
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 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
Job ID: R-799057
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
