Senior Software Engineer - Data Integration, Officer

Charles River Development (CRD) is the FinTech division of State Street.  Together with State Street’s Middle and Back-office services, Charles River’s cloud-based Front Office technology forms the foundation of the State Street Alpha® Platform, the first front-to-back solution in the industry.  The Alpha Data Platform, lets you load, enrich and aggregate investment data. Leveraging this, our clients will be able to manage multi-asset class data from any service provider or data vendor for a more holistic and integrated view of their holdings. This platform reflects State Street’s years of experience servicing complex instruments for our global client base and our investments in building advanced data management technologies. As the Data Integration Developer/Sr Data Integration Developer you are responsible for overall development life cycle leading to successful delivery and support of Alpha Data Platform Services to clients.

Responsibilities:

• As a Data Integration Developer/Sr Developer, you will be hands-on ETL data pipelines, Snowflake data warehouse, CI/CD deployment Pipelines and data-readiness (data quality) design, development, implementation and address code or data issues.

• You will conduct query performance tuning/optimizations and data loads to meet the SLAs for both batch and real-time data uses cases.

• Part of your role will need you to investigate problems and work on your own to solve and innovate clear and concise solutions.

• As a global team, leverage your collaborative experience to work across regions (APAC, EMEA, and North America) to come up with design standards, high-level design solutions document, cross training and data onboarding activities.

• You will partake in the creation of artifacts to align with the global SDLC process, Governance clearance, conduct peer code reviews and Unit Test Results, be involved in Code deployments, and create Confluence Jira/Kanban stories.

• Leverage SQL query debugging and defect issue resolution processes to conduct root cause analysis while working with multiple business/IT stakeholders.

• You will partake in support activities for client implementations and deliver solutions to improve operations.

• Git code versioning and merging, release and feature branches.

Qualifications:

Education:

• B.S. degree (or foreign education equivalent) in Computer Science, Engineering, Mathematics, and Physics or other technical course of study required. MS degree strongly preferred.

Experience:

• A minimum of 10 years of experience in data integration/orchestration services

• Strong Data warehousing Concepts, ETL tools such as Talend Cloud Data Integration tool

• Strong SQL knowledge and debugging skills is a must

• Experience in service architecture and providing data driven solutions for client requirements

• Experience on Microsoft Azure cloud and Snowflake SQL, database query/performance tuning

• Exposure to the financial domain knowledge is considered a plus

• Prior experience with State Street and Charles River Development (CRD) considered a plus

• Experience with Qlik Replicate and Compose tools (Change Data Capture) tools is considered a plus

• Exposure to Third party data providers such as Bloomberg, Reuters, MSCI and other Rating agencies is a plus