Senior Data Architect and Engineer

$110,000 - $185,000/Yr

State Street Corporation - Quincy, MA

Full-time - Senior

Quincy, MA

Securities, Commodity Contracts, and Other Financial Investments and Related Activities

About the position

The Senior Data Architect and Engineer will be responsible for defining, planning, and implementing technology solutions to enhance Bilateral Business Services. This role involves collaborating with business and technology teams globally to execute complex projects, focusing on developing a comprehensive collateral management platform and client-facing technology solutions. The position requires a strong emphasis on data infrastructure, analytics initiatives, and ensuring data integrity, scalability, and security.

Responsibilities

• Define, plan, and implement technology solutions for Bilateral Business Services.
• Develop and implement a comprehensive collateral management platform.
• Collaborate with stakeholders to design and maintain robust data pipelines.
• Establish data quality standards and implement data governance processes.
• Create visual representations of data for better understanding of complex information.
• Work closely with infrastructure and DevOps teams to ensure data infrastructure reliability.
• Monitor and troubleshoot issues in production environments.
• Drive continuous improvement initiatives for application performance and reliability.
• Mentor and coach team members on best practices and development methodologies.
• Evaluate new technologies and frameworks to improve data processing capabilities.

Requirements

• 10+ years of experience in data architecture and engineering.
• Strong hands-on experience in Scala/Python, particularly with Spark Scala/PySpark and Spark SQL.
• Experience with SQL, PL/SQL, Unix Shell Scripting, and tools like Autosys/Airflow.
• Proficiency in relational databases (Oracle, PostgreSQL) and NoSQL databases.
• Knowledge of data integration techniques and tools, including APIs and data streaming.
• Strong analytical and problem-solving skills.
• Experience with Agile software development methodology and version control systems like GitHub.
• Expertise in Data Modeling and database design with performance tuning skills.
• Good communication skills and ability to collaborate with various teams.

Nice-to-haves

• Experience with Azure cloud platform and data services.
• Knowledge of Spark-based data engineering solutions using Databricks and Unity Catalog.
• Familiarity with containerization and orchestration technologies like Docker and Kubernetes.
• Experience in the Banking Domain.

Benefits

• Generous medical care and insurance plans.
• Savings plans and flexible work programs.
• Development programs and educational support.
• Paid volunteer days and matching gift programs.