Software Engineer III-SI&DS Design

Bank of America
Newark, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Newark, United States of America

Tech stack

Agile Methodologies
Software Applications
Architectural Patterns
Unit Testing
CA Workload Automation Ae
Batch Processing
Big Data
Databases
Continuous Integration
Data Architecture
Data Infrastructure
ETL
IBM DB2
Relational Databases
IBM InfoSphere DataStage
DevOps
Distributed Systems
Python
Operational Data Store
Oracle Applications
Performance Tuning
Systems Development Life Cycle
Query Optimization
Release Management
Shell Script
Software Engineering
SQL Stored Procedures
SQL Databases
Data Streaming
Strategies of Testing
Enterprise Data Management
Data Logging
GitHub Copilot
Database Optimization
Backend
Event Driven Architecture
Information Technology
Deployment Automation
Real Time Data
Kafka
Data Management
Database Replication
Splunk
Software Version Control
Data Pipelines
MemSQL
Dynatrace

Job description

We're looking for a highly skilled Lead Database Engineer / Design Lead to join our team and drive the next generation of enterprise data platforms supporting Consumer and Small Business Card, Deposit products.

In this role, you will lead the design, development, and support of mission-critical Operational Data Store (ODS) systems that power high-volume, real-time data access across digital and non-digital banking channels.

You'll work on platforms that process and deliver millions of transactions daily. This is an opportunity to combine deep technical expertise with hands-on technical leadership , working with a team of engineers, contributing to large-scale data systems development

in a fast-paced, highly visible environment. This job is responsible for developing and delivering complex requirements to accomplish business goals. Key responsibilities of the job include ensuring that software is developed to meet functional, non-functional and compliance requirements, and solutions are well designed with maintainability/ease of integration and testing built-in from the outset. Job expectations include a strong knowledge of development and testing practices common to the industry and design and architectural patterns., * Codes solutions and unit test to deliver a requirement/story per the defined acceptance criteria and compliance requirements

  • Designs, develops, and modifies architecture components, application interfaces, and solution enablers while ensuring principal architecture integrity is maintained
  • Mentors other software engineers and coach team on Continuous Integration and Continuous Development (CI-CD) practices and automating tool stack
  • Executes story refinement, definition of requirements, and estimating work necessary to realize a story through the delivery lifecycle
  • Performs spike/proof of concept as necessary to mitigate risk or implement new ideas
  • Automates manual release activities
  • Designs, develops, and maintains automated test suites (integration, regression, performance)
  • Lead architecture, design, and development of large-scale database and data platform solutions
  • Own end-to-end delivery across technologies including Oracle, MemSQL(SingleStore), Cockroach DB, DB2, ETL (IBM DataStage), and Autosys
  • Build and optimize high-performance data pipelines supporting real-time and batch processing
  • Provide technical leadership across development and support
  • Ensure solutions meet performance, scalability, security, and regulatory requirements
  • Collaborate with product owners and stakeholders to define, refine, and deliver business requirements
  • Drive best practices in CI/CD, release management, and production support
  • Troubleshoot and resolve complex data and system issues as needed.
  • Contribute to testing strategies and continuous improvement initiatives, Bank of America and its affiliates consider for employment and hire qualified candidates without regard to race, religious creed, religion, color, sex, sexual orientation, genetic information, gender, gender identity, gender expression, age, national origin, ancestry, citizenship, protected veteran or disability status or any factor prohibited by law, and as such affirms in policy and practice to support and promote the concept of equal employment opportunity, in accordance with all applicable federal, state, provincial and municipal laws. The company also prohibits discrimination on other bases such as medical condition, marital status or any other factor that is irrelevant to the performance of our teammates.

View your "Know your Rights (https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12.pdf) " poster.

View the LA County Fair Chance Ordinance (https://dcba.lacounty.gov/wp-content/uploads/2024/08/FCOE-Official-Notice-Eng-Final-8.30.2024.pdf) .

Requirements

  • 12+ years of hands-on experience in database engineering, large-scale data platforms, or backend systems development
  • Bachelor's degree in Computer Science, Engineering, IT, Computer Application or job related field required.
  • Deep expertise in relational database design and performance engineering , including Oracle, MemSQL, or comparable enterprise RDBMS platforms like Cockroach DB, IBM DB2
  • Advanced proficiency in SQL and PL/SQL development , including complex query optimization, stored procedures, and data modeling
  • Strong experience building and maintaining ETL pipelines using IBM DataStage (or similar tools) , including batch processing and orchestration via Autosys or equivalent schedulers
  • Solid understanding of data architecture principles , including transactional vs. analytical workloads, data partitioning, indexing strategies, and high-availability design
  • Hands-on experience with Linux/Unix environments , including automation using Python and/or shell scripting
  • Proven experience in production observability pattern , leveraging tools such as Splunk, Dynatrace , or similar for monitoring, logging, and performance tuning
  • Experience implementing and supporting CI/CD pipelines , version control workflows, and automated deployment practices in enterprise environments
  • Strong ability to analyze and troubleshoot complex system and data issues across distributed environments
  • Demonstrated experience leading technical initiatives , mentoring engineers, and driving delivery across cross-functional teams, * Experience designing or modernizing high-volume, low-latency enterprise data platforms (e.g., ODS, transactional systems)
  • Background working in financial services, payments, or other highly regulated, transaction-intensive environments
  • Hands-on experience with streaming and event-driven architectures (e.g., Kafka)
  • Familiarity with data replication and CDC technologies such as IBM IIDR or similar tools
  • Exposure to distributed SQL or cloud-native databases (e.g., Cockroach DB) and modern data platform evolution
  • Experience working in Agile delivery models using tools like Jira, including backlog refinement and sprint execution
  • Exposure to AI-assisted development tools (e.g., GitHub Copilot) to improve engineering productivity

Skills:

  • Application Development
  • Automation
  • Influence
  • Solution Design
  • Technical Strategy Development
  • Architecture
  • Business Acumen
  • DevOps Practices
  • Result Orientation
  • Solution Delivery Process
  • Analytical Thinking
  • Collaboration
  • Data Management
  • Risk Management
  • Test Engineering

About the company

At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. We do this by driving Responsible Growth and delivering for our clients, teammates, communities and shareholders every day. Being a Great Place to Work and providing a culture of caring is core to how we drive Responsible Growth. We are intentional about fostering an inclusive workplace where every teammate has the opportunity to succeed, build a career and contribute to our shared success. This includes attracting and developing exceptional talent, recognizing and rewarding performance, and supporting our teammates' physical, emotional, and financial wellness through affordable, competitive and flexible benefits. We value the unique perspectives individuals bring from all backgrounds and career paths - whether shaped by military service, community college education, or a wide range of work and life experiences. These journeys foster resilience, leadership and innovation, strengthening our workforce and positively impact the communities we serve. Bank of America is committed to an in-office culture that supports collaboration, engagement, and career development. Our approach includes clear in-office expectations, while providing an appropriate level of flexibility based on role-specific responsibilities and business needs. At Bank of America, you can build a successful career with opportunities to learn, grow, and make an impact. Join us!, Bank of America aims to create a workplace free from the dangers and resulting consequences of illegal and illicit drug use and alcohol abuse. Our Drug-Free Workplace and Alcohol Policy ("Policy") establishes requirements to prevent the presence or use of illegal or illicit drugs or unauthorized alcohol on Bank of America premises and to provide a safe work environment. Bank of America is committed to an in-office culture with specific requirements for office-based attendance and which allows for an appropriate level of flexibility for our teammates and businesses based on role-specific considerations. Should you be offered a role with Bank of America, your hiring manager will provide you with information on the in-office expectations associated with your role. These expectations are subject to change at any time and at the sole discretion of the Company. To the extent you have a disability or sincerely held religious belief for which you believe you need a reasonable accommodation from this requirement, you must seek an accommodation through the Bank's required accommodation request process before your first day of work. This communication provides information about certain Bank of America benefits. Receipt of this document does not automatically entitle you to benefits offered by Bank of America. Every effort has been made to ensure the accuracy of this communication. However, if there are discrepancies between this communication and the official plan documents, the plan documents will always govern. Bank of America retains the discretion to interpret the terms or language used in any of its communications according to the provisions contained in the plan documents. Bank of America also reserves the right to amend or terminate any benefit plan in its sole discretion at any time for any reason.

Apply for this position