Data and AI Engineer

About the role

Job Description:

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!

Job Description:

This job is responsible for driving efforts to develop and deliver complex data solutions to accomplish technology and business goals. Key responsibilities include leading code design and delivery tasks with the integration, cleaning, transformation and control of data in operational and analytical data systems. Job expectations include liaising with vendors and working with stakeholders and Product and Software Engineering teams to implement data requirements, analyzing performance, and researching and troubleshooting issues within system engineering domains.

Overview:

We are seeking a Data and AI Engineer with 7+ years of experience in Oracle and SQL Server database development, data engineering, and ETL solutions. The ideal candidate combines a strong traditional data engineering foundation with the ability to work across Python, backend APIs, retrieval and search technologies, and AI integration. This role will design, develop, optimize, and support enterprise-scale data platforms while collaborating with Business Analysts, UI teams, and Production Support teams. The position requires expertise in Oracle, SQL Server, Python, SSIS, Autosys, database architecture, performance tuning, and AI-assisted development tools such as Microsoft Copilot and GitHub Copilot.

Responsibilities:

Leads story refinement and delivery of requirements through the delivery lifecycle and assists team members in resolving technical complexities

Codes complex solutions to integrate, clean, transform, and control data, builds processes supporting data transformation, data structures, metadata, data quality controls, dependency, and workload management, assembles complex data sets, and communicates required information for deployment

Leads documentation of system requirements, collaborates with development teams to understand data requirements and feasibility, and leverages architectural components to develop client requirements

Leads testing teams to develop test plans, contributes to existing test suites including integration, regression, and performance, analyzes test reports, identifies test issues and errors, and leads triage of underlying causes

Leads work efforts with technology partners and stakeholders to close gaps in data management standards adherence, negotiates paths forward by thinking outside the box to identify and communicate solutions to complex problems, and leverages knowledge of information systems, techniques, and processes

Leads complex information technology projects to ensure on-time delivery and adherence to release processes and risk management and defines and builds data pipelines to enable data-informed decision making

Mentors Data Engineers to enable continuous development and monitors key performance indicators and internal controls

Design, develop, and maintain Oracle and SQL Server database solutions

Create and optimize database objects including tables, indexes, views, stored procedures, functions, and triggers

Develop complex SQL, PL/SQL, and T-SQL queries for reporting, analytics, and operational workloads

Design and implement ETL processes using SSIS, Python, and related technologies

Build Python-based backend services and APIs, ideally using FastAPI or a similar framework, to support data and AI integrations

Design and integrate retrieval solutions using LLMs, retrieval-augmented generation (RAG), embeddings, vector stores, vector search, and hybrid search

Understand how embeddings are generated, stored, indexed, and retrieved across platforms such as Elasticsearch or similar search technologies

Contribute to agentic workflows and orchestration patterns using frameworks such as LangChain and LangGraph, where applicable

Help productionize AI solutions through effective testing, observability, security, governance, deployment, and operational support practices

Automate and schedule data processing jobs using Autosys and other workflow orchestration tools

Required Qualifications:

7+ years of experience in Oracle and SQL Server database development

Strong expertise in SQL, PL/SQL, and T-SQL

Experience with database architecture and logical and physical data modeling

Hands-on experience with SSIS and ETL development

Strong Python development skills, including automation and backend/API development; FastAPI or similar framework experience is highly desirable

Hands-on understanding of LLMs, RAG, embeddings, vector stores and search, and hybrid search

Understanding of how embeddings are generated, stored, indexed, and retrieved for AI-enabled data solutions

Working knowledge of AI productionization practices, including testing, observability, security, governance, and operational readiness

Experience with Autosys job scheduling and workflow management

Expertise in database design, schema creation, stored procedures, functions, views, and indexing

Strong experience in SQL query optimization, performance tuning, and troubleshooting

Experience supporting production deployments and application releases

Excellent communication, problem-solving, and documentation skills

Experience working in Agile/Scrum environments

Desired Qualifications:

Exposure to agentic workflows and frameworks such as LangChain and LangGraph

Experience with Elasticsearch or another platform supporting vector and hybrid search patterns

Experience with Apache Airflow for workflow orchestration and data pipeline scheduling

Knowledge of MongoDB or other NoSQL databases

Experience with CI/CD tools such as Jenkins

Experience with Git, Bitbucket, JIRA, and Confluence

Experience with cloud-based data platforms and modern data engineering practices

Experience in financial services or large enterprise environments

Skills:

Analytical Thinking

Application Development

Data Management

DevOps Practices

Solution Design

Agile Practices

Collaboration

Decision Making

Risk Management

Test Engineering

Architecture

Business Acumen

Data Quality Management

Financial Management

Solution Delivery Process

Shift:

1st shift (United States of America)

Hours Per Week:

40

Pay Transparency details

US - NJ - Pennington - 1300 American Blvd - Hopewell Bldg 3 (NJ2130)

Pay and benefits information

Pay range

$104,000.00 - $157,700.00 annualized salary, offers to be determined based on experience, education and skill set.

Discretionary incentive eligible

This role is eligible to participate in the annual discretionary plan. Employees are eligible for an annual discretionary award based on their overall individual performance results and behaviors, the performance and contributions of their line of business and/or group; and the overall success of the Company.

Benefits

This role is currently benefits eligible. We provide industry-leading benefits, access to paid time off, resources and support to our employees so they can make a genuine impact and contribute to the sustainable growth of our business and the communities we serve.