State Street
State Street

Systems Operations & Admin, Sr Associate

RoleData Engineering
LevelSenior
LocationToronto, Canada
WorkOn-site
TypeFull-time
Posted1 week ago
Apply now

About the role

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. Data Stage, 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

Required skills

ETL

data pipelines

data quality

reconciliation

analysis

About State Street

Dublin 2; Toronto

Headquarters