Databricks Data Engineering & Analytics, Co-Op-Intern

This opportunity is ideal for individuals interested in contributing to our team as a Databricks Data Engineering & Analytics Intern within State Street’s Global Technology Services organization. Our technology function, Global Technology Services (GTS), is vital to State Street and is the key enabler for our business to deliver data and insights to our clients. We’re driving the company’s digital transformation and expanding business capabilities using industry best practices and advanced technologies. The ideal candidate leads with integrity, embraces creativity, and invests in personal growth. This role requires a collaborative mindset, a passion for innovation, and the ability to inspire others.  

What You Will Do:    

In this role, you will perform the following day-to-day activities:  

Assist in developing and maintaining data pipelines using Databricks and Datastage, leveraging Python and SQL for data manipulation, transformation, and querying. 

Support the implementation of medallion architecture (bronze, silver, gold layers) for audit analytics use cases, and participate in data modeling, transformation, and enrichment tasks. 

Assist in integrating REST APIs for data ingestion and external system connectivity, with experience in automation and workflow orchestration using tools like Apache Airflow or Azure Data Factory. 

Work with Databricks Apps and Serverless compute environments on AWS and Azure to optimize performance and cost, including storage and data services. 

Collaborate with audit and data teams to ensure data quality, governance, and compliance, with awareness of data privacy, access controls, and cataloging tools. 

Create dashboards and visualizations using Databricks SQL, Power BI, or Tableau, applying SQL optimization techniques such as query performance tuning and indexing. 

Document workflows, architecture components, and technical decisions to support transparency and knowledge sharing. 

Support CI/CD processes for data pipeline deployment using tools like GitHub, with a basic understanding of version control and automated deployment practices. 

Monitor and troubleshoot data pipeline performance and failures using logging and observability tools, and apply performance tuning techniques. 

Explore and prototype new features or enhancements to improve audit analytics capabilities, while working in an Agile methodology and collaborating effectively across cross-functional teams. 

In this role, you will have: 

Engagement in meaningful daily work: You'll take ownership of specific tasks and projects, gaining hands-on experience and building confidence through real contributions.  

A supportive learning environment: You'll exercise your judgment in a guided setting, with mentorship and supervision to help you grow.  

Focused skill development: This role is designed to help you deepen your expertise in a specific area.  

Clear structure and expectations: You'll work within well-defined parameters, giving you the clarity and focus to succeed.  

Independent contributions: You'll have the opportunity to make an impact through your individual contributions while collaborating with a supportive team.  

Focus on growth: While there are no people management responsibilities with this role, it is a great stepping stone for future leadership opportunities.  

A collaborative team culture: You'll build strong working relationships with your peers and supervisor, gaining valuable experience in a professional environment.  

Education and Preferred Qualifications:  

Candidates should be:  

Final-year undergraduate or graduate students pursuing degrees in Computer Science, Data Science, Data Engineering, or related technical disciplines who are interested in converting to a full-time role post-graduation. Strong interest in data analytics, cloud computing, and modern data platforms. 

Enthusiastic about building a long-term career in a dynamic, technology-driven organization 

Effective communicators with the ability to collaborate in a team-oriented environment 

Open to feedback and committed to continuous learning and improvement 

Motivated by real-world problem solving and eager to contribute innovative ideas