Feature Lead - Technology

At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. We drive Responsible Growth and deliver for our clients, teammates, communities, and shareholders every day. This includes our commitment to being an inclusive workplace, attracting and developing exceptional talent, supporting teammates' wellness, recognizing performance, and making an impact in the communities we serve.

About the role

The team is a Data Engineering group focused on building and maintaining robust database-centric data pipelines, database solutions, and analytics platforms across heterogeneous systems. They develop and maintain Oracle, PL/SQL packages, procedures, functions, Vertica, and Unix Shell/Python automation, with workload scheduling orchestrated through Autosys. The role ensures end-to-end data integrity, reliability, and performance across traditional database environments (Oracle, Vertica, MS SQL).

This is an individual contributor role providing leadership, technical direction, and oversight to a team delivering technology solutions. The role involves designing, implementing, and maintaining complex computer programs, aligning technical solutions to business objectives, and ensuring coding practices and quality comply with software development standards.

Responsibilities

• Design, develop, and deliver features while ensuring solutions meet product acceptance criteria with minimal technical debt.
• Apply enterprise standards for solution design, coding, and quality.
• Guide the team on work breakdown and execution, and mentor team members on engineering practices (planning, estimation, peer reviews).
• Work with the Product Owner to ensure a healthy product backlog with clear acceptance criteria.
• Analyze existing business processes and design Oracle-centric optimizations, automation, and workflow improvements.
• Gather and document functional, non-functional, and technical requirements for incoming requests.
• Analyze functional and data requirements to understand how applications store, transform, and expose data within Vertica/Oracle.
• Assist users and development teams with application testing, data validation, and troubleshooting Oracle/Vertica database processes.
• Identify, document, and troubleshoot application and database-related issues (performance, data integrity, failures).
• Document end-to-end processes, database procedures, workflow logic, and operational runbooks.
• Create and maintain training material for end-users and support teams.
• Collaborate with other development teams to manage interdependencies, design test cases, debug issues, and maintain high data quality.
• Ensure software stability through documentation, peer code reviews, regression testing, unit testing, and UAT.
• Perform logical and physical data modeling, including schema design in Oracle.
• Perform in-depth data analysis, profiling, and identification of data quality issues.
• Support story refinement, requirement elaboration, and effort estimation in Agile processes.
• Use Github Copilot and other AI tools to accelerate development and mentor developers.
• Present the team's work to business partners and lead senior and junior team members on technical complexities in Oracle development and CI/CD pipeline design.
• Develop a strong understanding of stakeholder needs and translate them into scalable database-based technical solutions.

Requirements

• Bachelor’s Degree in Engineering, Science, IT, Computer Science, or a related field.
• 3+ years of job-related experience.
• Experience with relational and non-relational databases, focusing heavily on Oracle SQL and PL/SQL.
• Strong experience designing and implementing Oracle-driven data integration pipelines using SQL, PL/SQL, and Unix shell scripting.
• Experience automating Oracle processes using job schedulers (Autosys preferred).
• Professional experience in SQL/PLSQL development, including packages, functions, procedures, triggers, and bulk processing.
• Ability to refine requirements, participate in story sizing, and drive Agile delivery.
• Ability to perform POCs/spikes to test new Oracle features or solution patterns.
• Develop, test, and deliver Oracle-based solutions that meet acceptance criteria and adhere to compliance standards.
• Strong understanding of integrating multiple architectural components (data, application, business).
• Good understanding of dimensional modeling, star/snowflake schemas, facts, dimensions, and hierarchies.
• Skilled in leading and developing complex Oracle data flows, connecting to heterogeneous databases such as Oracle and MS SQL Server.
• Hands-on experience developing complex Oracle procedures, functions, and PL/SQL packages used in APIs, reporting, and data warehousing.
• Ability to conduct both proactive and reactive Oracle performance tuning using explain plans, indexing strategies, statistics, hints, and SQL optimization best practices.
• Strong hands-on experience developing and supporting Unix shell scripts (critical skill).

Work Split: Oracle PL/SQL / Shell / Python - 70%, ETL transformations (Informatica) - 10%, Unix shell scripting, Python - 20%.

Qualifications

• Financial industry/Banking experience preferred.
• Exceptional analytical and problem-solving skills; excellent organizational and communication skills.
• Experience with JIRA and infrastructure tools.
• Demonstrated ability to get things done, seize opportunities, and innovate.

Skills

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

Pay

Pay range: $106,500.00 - $173,700.00 annualized salary. Offers are determined based on experience, education, and skill set. This role is eligible to participate in the annual discretionary incentive plan.

Benefits

This role is benefits-eligible. We provide industry-leading benefits, access to paid time off, and resources to support employees in making a genuine impact and contributing to sustainable business growth and communities.

Schedule

• 1st shift (United States of America)
• 40 hours per week