About the Role
Bank of America is seeking a Data Engineer to build and maintain robust database-centric data pipelines, solutions, and analytics platforms. This role involves developing and maintaining Oracle, PL/SQL, Vertica, and Unix Shell/Python automation, with workload scheduling orchestrated through Autosys. The team ensures end-to-end data integrity, reliability, and performance across traditional database environments. This individual contributor role provides technical direction and oversight for technology solutions, aligning them with business objectives and ensuring adherence to coding standards.
Responsibilities
- Designs, develops, and is accountable for feature delivery.
- Applies enterprise standards for solution design, coding, and quality.
- Ensures solutions meet product acceptance criteria with minimal technical debt.
- Guides the team on work breakdown and execution.
- Works with the Product Owner to ensure product backlog/requirements are healthy with clear acceptance criteria.
- Plays a team lead role (as an individual contributor) and mentors the team.
- Guides team members with skills and practices (planning and estimation, peer reviews, and other engineering practices).
- Analyzes existing business processes and designs Oracle-centric optimizations, automation, and workflow improvements.
- Gathers and documents functional, non-functional, and technical requirements for incoming requests.
- Analyzes functional and data requirements, understanding how applications store, transform, and expose data within Vertica/Oracle.
- Assists users and development teams with application testing, data validation, and troubleshooting Oracle/Vertica database processes.
- Identifies, documents, and troubleshoots application and database-related issues (performance, data integrity, failures).
- Documents end-to-end processes, database procedures, workflow logic, and operational runbooks.
- Creates and maintains training material for end-users and support teams.
- Demonstrates exceptional analytical/problem-solving skills with strong communication and collaboration.
- Collaborates with other development teams to manage interdependencies, design test cases, debug issues, and maintain high data quality.
- Ensures software stability through documentation, peer code reviews, regression testing, unit testing, and UAT.
- Performs logical and physical data modeling, including schema design in Oracle.
- Performs in-depth data analysis, profiling, and identification of data quality issues.
- Supports story refinement, requirement elaboration, and effort estimation in Agile processes.
- Utilizes Github Copilot and other AI tools to speed up development delivery and encourages adoption as a role model.
- Presents team’s work to Business partners and leads Sr and Jr team members onshore and offshore, detailing technical complexities in Oracle development and CI/CD pipeline design and industry best practices.
- Develops a strong understanding of stakeholder needs and translates them into scalable database-based technical solutions.
Requirements
- Bachelors Degree in Engineering, Science, IT, Computer Science or job-related field required.
- 3+ years of job-related experience required.
- 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 help 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 how to integrate 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).
- Financial industry/Banking Experience Preferred.
- Demonstrate exceptional analytical skills and problem-solving skills; excellent organizational, communication skills.
- Experience with JIRA tool and infrastructure.
- An individual with a demonstrated ability to get things done and make things happen; a person who is resourceful, seizes opportunities and is an innovator.
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
- Oracle SQL
- PL/SQL
- Unix Shell Scripting
- Python
- Autosys
- ETL transformations
- Github Copilot
Location
- Jersey City, NJ
- New York, NY
Work Type
- Onsite
- Full-time
Experience Level
- 3+ years of job-related experience
Education Level
- Bachelors Degree in Engineering, Science, IT, Computer Science or job-related field
Salary/Compensations
- $106,500.00 - $173,700.00 annualized salary
Benefits
- Industry-leading benefits
- Access to paid time off
- Resources and support
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 drive Responsible Growth and deliver for our clients, teammates, communities, and shareholders every day.
- Being a Great Place to Work is core to how we drive Responsible Growth.
- This includes our commitment to being an inclusive workplace, attracting and developing exceptional talent, supporting our teammates’ physical, emotional, and financial wellness, recognizing and rewarding performance, and how we make an impact in the communities we serve.
- 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.
- At Bank of America, you can build a successful career with opportunities to learn, grow, and make an impact. Join us!
