Database Architect - Burlington, United States - State Street

State Street Burlington, United States

4 weeks ago

OTHER

Description

Who we are looking for
Leading technical contributor to the enhancement and maintenance of one or more Charles River IMS modules or components of an agile scrum team. Provide engineering troubleshooting assistance to customer support teams and other development teams within Charles River.

Why this role is important to us
The team you will be joining is a part of Charles River Development (or CRD), that became a part of State Street in 2018. CRD helps create enterprise investment management software solutions for large institutions in the areas of institutional investment, wealth management and hedge funds. Together we have created the first open front-to-back platform - State Street Alpha that was launched in 2019.
Join us if delivering next generation infrastructure, using emerging technologies like AI and Blockchain sounds like a challenge you are up for.

What you will be responsible for

• Database Design and Architecture
o Develop and design database architecture to support Charles River applications, ensuring system scalability, security, performance and reliability
o Design strategies for distributed database platforms, including Data Warehouse, Data Mart, Data Lake and Operational Data Storage (ODS) that support cloud architecture and microservices
o Collaborate with system and software architects to set standards for operations, programming, security and deployment of the databases

• Data Modeling
o Create and maintain comprehensive documentation of database design, data models, configurations, and processes
o Establish standard processes to ensure data model consistency and accuracy across business applications

• Database Security and Disaster Recovery
o Establish and enforce database security best practices, including access controls, encryption, and data masking that ensure compliance with data protection regulations
o Collaborate with production DBA to conduct capacity planning that address future and long-term data storage and performance requirements
o Design and develop high availability, robust disaster recovery, and data purging and backup strategies

• Database Performance
o Optimize performance through indexing, SQL query optimization, and other database tuning techniques
o Monitor database performance metrics, analyze and identify bottlenecks, and recommend short-term and long-term solutions
o Collaborate with engineering teams to define performance test strategy, and develop toolsets to generate synthetic datasets for effective and repeatable performance tests

• Collaboration and Leadership
o Provide technical guidance and support to engineering, SaaS Operation, support and Implementation teams
o Collaborate with cross-functional teams, including engineering, SaaS Operation, support, and implementation, to ensure seamless integration of database systems
o Provide technical leadership and mentorship to database engineers

What we value

• Extensive hands-on experience in RDBMS and distributed data platforms as a database architect

• Strong analytical and problem-solving skills with ability to troubleshoot and resolve database related issues

• Proficiency in SQL and database design principles

• Experience with cloud database services such as Azure SQL Database or AWS RDS

• Experience in NoSQL databases is preferred

• Programming experience in Java, C++, C#, JDBC, Sprint boot, and Microservices is a plus

• Experience with developing applications for the financial markets is a plus (Fixed Income, Trading, FX, Risk, Portfolio/Wealth Management, Market Data, FIX, etc.)

Education & Preferred Qualifications

• 7 to 10+ years of experience as a Database Architect or in a similar role supporting enterprise applications backed with RDBMS databases or Snowflake

• Bachelor's degree in computer science, Information Technology, or a related field. Master's degree is a plus

• Proven experience with major relational databases such as MS SQL Server or Oracle, hardware sizing and configuration, operating systems, scripting, and database technologies

• Strong understanding of database security best practices and data protection regulations

• Ability to provide technical leadership and collaborate effectively with cross functional and organizational teams

• Excellent communication skills (verbal and written) with the ability to convey complex technical concepts to both technical and non-technical stakeholders

• A minimum of 7 years working with an Agile development methodology strongly desired

About State Street
What we do. State Street is one of the largest custodian banks, asset managers and asset intelligence companies in the world. From technology to product innovation we're making our mark on the financial services industry. For more than two centuries, we've been helping our clients safeguard and steward the investments of millions of people. We provide investment servicing, data & analytics, investments research & trading and investment management to institutional clients.
Work, Live and Grow. We make all efforts to create a great work environment. Our benefits packages are competitive and comprehensive. Details vary in locations, but you may expect generous medical care, insurance and savings plans among other perks. You'll have access to flexible Work Program to help match your needs. And our wealth of development programs and educational support will help you reach your full potential.
Inclusion, Diversity and Social Responsibility. We truly believe our employees' diverse backgrounds, experience and perspective are a powerful contributor to creating an inclusive environment where everyone can thrive and reach their maximum potential while adding value to both our organization and our clients. We warmly welcome the candidates of diverse origin, background, ability, age, sexual orientation, gender identity and personality. Another fundamental value at State Street is active engagement with our communities around the world, both as a partner and a leader. You will have tools to help balance your professional and personal life, paid volunteer days, matching gift program and access to employee networks that help you stay connected to what matters to you.

State Street is an equal opportunity and affirmative action employer.

Salary Range:

$110,000 - $185,000 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.

Data Engineer

1 week ago

OnLogic South Burlington, United States

We are seeking a talented and motivated Data Engineer that will play a critical role in designing, building, and maintaining the data infrastructure supporting our business intelligence, reporting and AI initiatives. You will work closely with data scientists, machine learning en ...
Principal Software Developer

3 days ago

Oracle Burlington, United States Regular Employee

Job Description · 5+ years of experience. · Programming experience with at least one language such as Java or Python · Understanding data design and modeling (dimensions and data mining). · Familiarity with technologies and design concepts such as: ETL, structured data, data c ...
Database Engineering Manager

3 weeks ago

State Street Corporation Burlington, United States Full time

Who we are looking for · Leading technical contributor to the enhancement and maintenance of one or more Charles River IMS modules or components of an agile scrum team. Provide engineering troubleshooting assistance to customer support teams and other development teams within Ch ...
Solution Architect

2 hours ago

Galen Healthcare Solutions Burlington, United States

Galen Healthcare Solutions, an RLDatix company, is a healthcare IT organization that provides award-winning information solutions and services for the largest healthcare organizations in the United States. · As a company, we are honored to be repeatedly ranked #1 in KLAS by our ...
Data Engineer

1 week ago

OnLogic South Burlington, United States

We are seeking a talented and motivated Data Engineer that will play a critical role in designing, building, and maintaining the data infrastructure supporting our business intelligence, reporting and AI initiatives. You will work closely with data scientists, machine learning en ...
Data Engineer

1 week ago

OnLogic South Burlington, United States

Job Description · Job DescriptionWe are seeking a talented and motivated Data Engineer that will play a critical role in designing, building, and maintaining the data infrastructure supporting our business intelligence, reporting and AI initiatives. You will work closely with dat ...
Data Engineer

1 week ago

OnLogic South Burlington, United States

Job Description · Job DescriptionWe are seeking a talented and motivated Data Engineer that will play a critical role in designing, building, and maintaining the data infrastructure supporting our business intelligence, reporting and AI initiatives. You will work closely with dat ...
Senior Software Engineer

2 weeks ago

GCR Technical Staffing Burlington, United States

Job Description · Job DescriptionThis position requires US Citizenship. · Our client is using cutting edge technology to secure and protect all personally identifiable information and adhere to the highest standards and best practices for security. We are always looking for indiv ...
Staff Backend/DevOps Engineer

3 weeks ago

Ready Education, Inc. Burlington, United States

Job Description · Job DescriptionSalary: · Who We Are · Ready Education is the leading mobile student engagement platform on a mission to improve student success in higher education worldwide. Our products connect students with their peers and faculty, allow easy management of c ...
Engineering Analyst

2 weeks ago

Vermont Energy Investment Winooski, United States

Overview: · VEIC is a sustainable energy company on a mission to generate the energy solutions the world needs. For more than 30 years, VEIC has worked with governments, utilities, foundations, and businesses across North America to design and deploy clean-energy services spanni ...
Engineering Analyst

1 week ago

Vermont Energy Investment Winooski, United States

Overview: · VEIC is a sustainable energy company on a mission to generate the energy solutions the world needs. For more than 30 years, VEIC has worked with governments, utilities, foundations, and businesses across North America to design and deploy clean-energy services spannin ...
Development Manager Data Services: API Management

4 days ago

Labcorp Burlington, United States Full time

Labcorp is recruiting a Development Manager Data Services: API Management & Integration for a dynamic team in either RTP, NC or Burlington, NC. · Corporate IT is actively searching for an experienced Manager with a background in Healthcare, for a Data Engineering Development team ...
Development Manager Data Services: API Management

1 week ago

Labcorp Burlington, United States Full time

Labcorp is recruiting a Development Manager Data Services: API Management & Integration for a dynamic team in either RTP, NC or Burlington, NC. · Corporate IT is actively searching for an experienced Manager with a background in Healthcare, for a Data Engineering Development team ...
Principal Software Engineer and Manager

1 week ago

NuHarbor Security Inc Colchester, United States

Job Summary We are looking for a principal software engineer/manager to help us with the leadership, design, development, deployment and operation of our emergent service delivery platform. Reporting directly to the VP of Software Engineering and Technology, this is a principal r ...
Lead Cloud Data Engineer Senior

3 weeks ago

Elevance Health St Albans, United States

Lead Cloud Data Engineer Senior · Location: · This position will work a hybrid model (remote and office). The Ideal candidate will live within 50 miles of one of our Elevance Health PulsePoint locations. · A proud member of the Elevance Health family of companies, Carelon Medica ...
Cloud Solutions Engineer

2 weeks ago

Elevance Health St Albans, United States

Cloud Solutions Engineer · Location: · This position will work a hybrid model (remote and office). The Ideal candidate will live within 50 miles of one of our Elevance Health PulsePoint locations. Ideally located in: Atlanta, GA; Richmond, VA; Mason, OH or Dallas, TX. · The · C ...
Senior Management Analyst

1 week ago

Chenega Corporation St Albans, United States

Summary · Come join a company that strives for · Extraordinary People and Exceptional Performance · Chenega Services & Federal Solutions, LLC, · a · Chenega Professional Services · ' company, is looking for a · Senior Management Analyst · to · support the Centers for Dis ...
Senior Engineer Operations Technology

3 weeks ago

Bank of America Addison, United States

Senior Engineer Operations Technology page is loaded · Senior Engineer Operations Technology · Apply · locations · Addison · time type · Full time · posted on · Posted 2 Days Ago · job requisition id · Job Description: · At Bank of America, we are guided by a common pur ...
Technical Solutions Engineer

3 weeks ago

MediaMonks St Albans, United States

Media.Monks is a digital-first marketing, advertising and technology services company connecting the dots across content, data & digital media and technology services. Inspired by the connectivity and flexibility of technology APIs, Media.Monks' single-P&L model offers brands sea ...
Senior Manager: Data Engineering Leader

1 week ago

Equifax St Albans, United States

Seeking a thought leader and organizational change agent for Equifax's Data Fabric platform. This individual will be passionate about end-user experience and best in class engineering excellence to lead the data operations and support function. As a leader in Data Operations, you ...