Senior Data & AI Engineer - Oracle/SQL, Python, LLMs

Aimlroles; Charlotte (NC); On-site; USD 104,000 - 158,000; Full time

Job summary

Bank of America is seeking a Data and AI Engineer with 7+ years of experience in Oracle and SQL Server database development, data engineering, and ETL. The role requires Python, SSIS, and AI integration capabilities to design, optimize, and support enterprise-scale data platforms.

You will collaborate with analysts, UI teams, and production support, leveraging LLMs, retrieval, and hybrid search technologies to enable data-driven decisions.

Qualifications

• 7+ years Oracle/SQL Server development.
• Proficient in SQL, PL/SQL, and T-SQL.
• ETL development with SSIS.
• Python backend/API development (FastAPI).
• Experience with LLMs, embeddings, vector stores, search.

Responsibilities

• Leads story refinement and delivers requirements through the lifecycle.
• Codes complex data integration, transformation, and data quality controls.
• Documents system requirements and collaborates on data feasibility.
• Leads test planning and triage of issues across suites.
• Partners with stakeholders to close data management gaps.
• Defines and builds data pipelines for data-informed decisions.
• Mentors Data Engineers and monitors KPIs and controls.
• Designs and maintains Oracle/SQL Server solutions.
• Develops SQL/PL-SQL/T-SQL queries for analytics and ops.
• Implements ETL using SSIS, Python, and related tech.
• Builds Python-based services/APIs for data/AI integrations.
• Integrates retrieval solutions using LLMs, embeddings, vector search.
• Produces production-ready AI with testing, security, governance.

Skills

Oracle & SQL Server

SQL/PL-SQL/T-SQL

Python

ETL development

LLMs & RAG

Autosys

Agile/Scrum

Data modeling

Data pipelines

AI productionization

Tools

SSIS

FastAPI

Elasticsearch

LangChain

LangGraph

Airflow

GitHub Copilot

Git

JIRA

Confluence

Jenkins

Job description

Bank of America is seeking a Data and AI Engineer with 7+ years of experience in Oracle and SQL Server database development, data engineering, and ETL. The role requires Python, SSIS, and AI integration capabilities to design, optimize, and support enterprise-scale data platforms.

You will collaborate with analysts, UI teams, and production support, leveraging LLMs, retrieval, and hybrid search technologies to enable data-driven decisions.