Job Description

About the Role
We are seeking a Senior Associate to join our Recon ETL (Extract, Transform, Load)
team In this pivotal role, you will be responsible for designing, developing, and
maintaining robust ETL processes that support our reconciliation operations. You will
collaborate with cross-functional teams to ensure data integrity, streamline
workflows, and drive continuous improvement in our data management practices.
Key Responsibilities
•Design, develop, and optimize ETL pipelines to support reconciliation
processes and ensure accurate data movement across systems.
•Analyze complex data sets to identify discrepancies, resolve data quality
issues, and implement solutions for improved data accuracy.
•Collaborate with business analysts, data engineers, and stakeholders to
gather requirements and translate them into technical specifications.
•Monitor and troubleshoot ETL jobs, proactively identifying and resolving
performance bottlenecks or failures.
•Document ETL processes, data flows, and business rules to ensure
transparency and knowledge sharing within the team.
•Contribute to automation initiatives to enhance efficiency and reduce manual
intervention in reconciliation workflows.
•Stay current with industry best practices and emerging technologies in ETL,
data integration, and reconciliation.
Required Qualifications
•Bachelor’s degree in Computer Science, Information Systems, Engineering,
or a related field.
•3+ years of experience in ETL development, data integration, or a similar role.

Proficiency with ETL tools e.g. DataStage, or similar.

Strong SQL skills and experience working with relational databases.
•Solid understanding of data warehousing concepts and data modeling.
•Experience with reconciliation processes or financial data management is
highly desirable.
•Excellent problem-solving skills and attention to detail.
•Strong communication and collaboration abilities to work effectively with
technical and non-technical stakeholders.
Preferred Skills
•Experience with cloud-based ETL solutions e.g. AWS Glue, Azure Data
Factory.
•Familiarity with Shell scripting, or other programming languages for data
processing and automation.
•Knowledge of data governance, data quality frameworks, and regulatory
requirements in financial services.
•Exposure to Agile methodologies and project management tools.
Why Join Us?
•Collaborative team environment that values innovation and continuous
learning.
•Opportunities for professional growth and advancement within a dynamic
organization.
•Competitive compensation and benefits package.
Ready to make an impact?
Apply now to join our Recon ETL team and help shape the future of our data-driven
operations.

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

Read our CEO Statement