Senior Data Engineer-Onsite
State Street
- Quincy, Massachusetts, United States
- Quincy, Massachusetts, United States
À propos
Why this role is important to us This role focuses on delivering cloud-native data warehouse (DW) solutions for Fund Accounting clients, supporting both batch and near real‑time data processing needs. This is a critical workstream for State Street servicing all Back‑Office business data requirements.
What You Will Be Responsible For
Design, build and test end‑to‑end data pipeline including data ingestion (streaming, events, and batch), data integration, data curation
Design, develop, and deploy scalable data pipelines and ETL processes on cloud‑based infrastructure using Azure, Snowflake, DBT, Airflow, Cosmos DB
Define and implement automation of jobs and testing
Optimize the data pipeline to support workloads and use cases
Support mission‑critical applications and near real‑time data needs from the data platform
Address data issues, environment issues, performing impact analysis, root‑cause analysis, corrective, adaptive and perfective maintenance
Implement data models, transformations, and schema designs to support analytical and reporting needs
Optimize and tune Snowflake performance, including query optimization, resource management, and scaling strategies
What We Value
Experience in micro‑services architecture and understanding of Cloud Computing is highly desirable
Experience with MicroServices – API/Event‑Driven Architecture/Development
Strong hands‑on experience in troubleshooting DevOps pipelines and Azure services
Experience with DBT (Data Build Tool) for data modelling and transformation and Apache Airflow for workflow orchestration and scheduling
Experience in Snowflake utilities including SnowSQL, Snowpipe, Snowlight for handling Streaming data is a plus
Expertise in Snowflake advanced concepts such as setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero‑copy clone, time travel and understand how to use these features
Experience in re‑clustering Snowflake data with good understanding of Micro‑Partition within Snowflake
Expertise in deploying Snowflake features such as data sharing, events and lake‑house patterns
Experience in handling semi‑structured data (JSON, XML) in Snowflake
Education & Preferred Qualifications
Bachelor’s Degree level qualification in a computer or IT related subject
7+ years of experience in professional database and data warehouse development
7+ years of development experience writing SQL queries/Stored Procedures for any other Relational Databases like Oracle, SQL Server
4+ years of experience on Snowflake development including Snowpipes, Snowshare, Task, Streams, UDFs and Procedures
4+ years of experience on cloud‑based development including Azure Services, Azure DevOps, Kubernetes, Docker
Additional Requirements
Any development experience on Databricks or Scala is a plus
Exposure to working in financial services; front‑ or middle‑office, or fund management business areas ideal
Experience dealing with users or clients from either a technical or business area
Desire to work in client‑facing environment
Ability to communicate effectively and in a professional manner both written and orally
Be a team player with a positive attitude, enthusiasm, initiative, and self‑motivation
Ability to multi‑task, meet aggressive timelines and have strong work ethics
Experience of working in the financial industry
Experience with agile development methodology
Work Requirement
Onsite 4 days a week in office and one day remote
Standard business hours aligned to project and stakeholder needs (8am to 5pm)
Salary Range $90,000 – $157,500 Annual.
The range quoted above applies to the role in the primary location specified. If the candidate would ultimately work outside of the primary location above, the applicable range could differ.
Benefits Employees are eligible to participate in State Street’s comprehensive benefits program, which includes a retirement savings plan (401K) with company match; insurance coverage covering basic life, medical, dental, vision, long‑term disability, and other optional additional coverages; paid‑time off including vacation, sick leave, short‑term disability, and family care responsibilities; access to our Employee Assistance Program; incentive compensation including eligibility for annual performance‑based awards; and, eligibility for certain tax‑advantaged savings plans.
Equal Opportunity Employer 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.
Job Application Disclosure It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.
#J-18808-Ljbffr
Compétences linguistiques
- English
Avis aux utilisateurs
Cette offre provient d’une plateforme partenaire de TieTalent. Cliquez sur « Postuler maintenant » pour soumettre votre candidature directement sur leur site.