Data and AI Engineer

Bank of America•Charlotte, NC

21h•$104,000 - $157,700•Onsite

About The Position

At Bank of America, the Data and AI Engineer drives the development and delivery of complex data solutions that support technology and business goals. The role leads code design and delivery involving data integration, cleaning, transformation, and controls in operational and analytical systems, and works with vendors, stakeholders, Product teams, and Software Engineering teams to implement data requirements and troubleshoot system engineering issues. The position requires 7+ years of experience in Oracle and SQL Server database development, data engineering, and ETL solutions. It combines traditional data engineering with Python, backend APIs, retrieval and search technologies, and AI integration. The engineer designs, develops, optimizes, and supports enterprise-scale data platforms and collaborates with Business Analysts, UI teams, and Production Support teams. The role designs and maintains Oracle and SQL Server databases and database objects; develops complex SQL, PL/SQL, and T-SQL; and builds ETL processes with SSIS and Python. It also develops Python backend services and APIs, supports retrieval and AI integrations involving LLMs, RAG, embeddings, vector stores, and search, and helps productionize AI solutions. Data processing jobs are automated and scheduled using Autosys and other orchestration tools. The position includes leading delivery and testing efforts, supporting production deployments and releases, and mentoring Data Engineers. The role is based at the stated Pennington, New Jersey worksite. Bank of America describes an in-office culture with role-specific flexibility based on responsibilities and business needs. The position is first shift, 40 hours per week, and offers an annual salary range of $104,000 to $157,700. It is eligible for an annual discretionary incentive plan and company benefits, including paid time off.

Requirements

At least 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.
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.

Nice To Haves

Experience with FastAPI or a similar backend framework.
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.

Responsibilities

Lead story refinement and deliver requirements through the delivery lifecycle; assist team members in resolving technical complexities.
Code solutions to integrate, clean, transform, and control data; build processes for data transformation, data structures, metadata, data quality controls, dependencies, and workload management; assemble complex data sets and communicate deployment information.
Lead documentation of system requirements, collaborate with development teams to understand data requirements and feasibility, and use architectural components to develop client requirements.
Lead test-plan development; contribute to integration, regression, and performance test suites; analyze test reports, identify issues and errors, and lead triage of underlying causes.
Work with technology partners and stakeholders to address gaps in adherence to data management standards and communicate solutions to complex problems.
Lead complex technology projects to support on-time delivery and adherence to release processes and risk management; define and build data pipelines for data-informed decision-making.
Mentor Data Engineers and monitor key performance indicators and internal controls.
Design, develop, optimize, and maintain Oracle and SQL Server database solutions and 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; optimize performance and troubleshoot issues.
Design and implement ETL processes using SSIS, Python, and related technologies.
Build Python-based backend services and APIs to support data and AI integrations.
Design and integrate retrieval solutions involving LLMs, RAG, embeddings, vector stores, vector search, and hybrid search.
Support AI solution productionization through testing, observability, security, governance, deployment, and operational support practices.
Automate and schedule data processing jobs using Autosys and other workflow orchestration tools.
Collaborate with Business Analysts, UI teams, Production Support teams, vendors, stakeholders, Product teams, and Software Engineering teams.

Benefits

Paid time off.
Access to resources and support for employees.
Annual discretionary incentive eligibility based on individual and business performance and company success.
Industry-leading benefits; the role is benefits eligible.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume