Join Our Team as a Senior Software Engineer

State Street is excited to seek a talented Senior Software Engineer to join our dynamic team. The ideal candidate will significantly influence the quality and reliability of our software products, focusing on developing T-SQL and MSBI-based applications and data warehouses.

Role Summary & Responsibilities

The successful candidate will:

• Design and create tables, views, triggers, partitions, complex stored procedures, functions, indexes, and other database objects.
• Import, export data, bulk insert, BCP, and handle performance tuning, profiling, and monitoring of SQL.
• Design and create SSIS packages to migrate data from multiple sources to various destinations and data warehouses.
• Design complex reports in SSRS, handle DML operations, and manage report deployments.
• Communicate effectively with business users to understand and analyze requirements and use cases.
• Showcase proven problem-solving, communication, interpersonal, and analytical skills.
• Work effectively in both independent and team environments.

Core Skills

• Strong experience with complex stored procedures, functions, indexes, dynamic SQL, and performance tuning.
• Extensive experience creating complex SSIS packages with data flow tasks and complex transformations.
• Proficiency in creating complex parameter-driven reports in SSRS.
• Experience with the onshore-offshore delivery model and Agile methodology.
• Excellent verbal and written communication skills.

Preferred Skills

• Experience in shell scripting and Autosys scheduling.
• Strong understanding of data warehousing concepts.

Work Schedule

The role offers flexibility with on-premise or hybrid working arrangements.

Key Skills and Keywords

MSBI (SSIS, SSRS), T-SQL, Data Warehouse, Performance Tuning, Agile, Shell Scripting, Autosys Scheduling

Why This Role is Important to Us

At Global Technology Services (GTS), our technology function is critical to our mission at State Street. We enable our business by delivering data and insights to clients, pushing digital transformation, and expanding business capabilities using cloud, artificial intelligence, and robotic process automation.

Join us to develop your skills, solve industry challenges, and make an impact in the financial services sector.

About State Street

State Street is among the world's largest custodian banks, asset managers, and asset intelligence companies. We continually innovate in technology and product development, protecting and managing investments for millions of people over two centuries. We provide a wide range of services, including investment servicing, data analytics, investment research, trading, and investment management to institutional clients.

Work, Live and Grow

We foster a supportive work environment with competitive, comprehensive benefits packages, flexible work programs, and excellent development programs. Our educational support will help you achieve your full potential.

Inclusion, Diversity, and Social Responsibility

We value diversity and inclusiveness, believing they enrich our workplace and drive our success. We warmly welcome candidates of all backgrounds, abilities, ages, sexual orientations, gender identities, and personalities. We are also committed to actively engaging with our communities around the world and offer tools and programs to balance professional and personal lives.

State Street is an equal opportunity and affirmative action employer.

Apply Now!

Position: Microsoft Business Intelligence Developer - Assistant Manager

Company: State Street