Software Engineer III - Backend/Data Engineer

Bank of America•Charlotte, NC

About The Position

Bank of America’s Business Finance Technology (BFO Tech) team is seeking an experienced Software Engineer to design, develop, modernize, and support database-driven applications, Oracle database components, ETL processes, and data integrations for enterprise financial management, reporting, and business operations. The role is hands-on and primarily focused on Oracle Exadata, SQL, PL/SQL, database development, ETL, data processing, and performance optimization. The position develops complex software requirements and delivers solutions that meet functional, non-functional, and compliance requirements. Solutions are expected to be designed with maintainability, ease of integration, and testing built in. The role also involves backend data services and interfaces, automated testing, deployment practices, and collaboration and coaching across the engineering team.

Requirements

At least 7 years of software engineering experience focused on backend development, database development, ETL, and data integration.
Strong experience with Oracle Exadata, Oracle Database, SQL, PL/SQL, stored procedures, packages, performance tuning, and query optimization.
Experience designing, developing, and supporting ETL processes using Informatica and/or DataStage.
Experience designing and supporting batch and near-real-time data integrations and processing workflows.
Experience with data modeling, data quality controls, reconciliation, and troubleshooting complex data issues.
Experience with Unix/Linux shell scripting and automation.
Experience with enterprise workload scheduling tools such as AutoSys or comparable technologies.
Experience with source control, automated testing, CI/CD pipelines, and application deployment practices.

Nice To Haves

Working knowledge of APIs and front-end technologies such as Angular, TypeScript, JavaScript, HTML, and CSS.
Experience developing distributed data-processing solutions using Python, PySpark, Apache Spark, or Hadoop.
Experience with cloud-based data storage and processing technologies, including Amazon S3 or comparable platforms.
Familiarity with modern workflow-orchestration technologies such as Airflow.
Knowledge of data governance, metadata, lineage, application security, and technology-risk practices.
Experience developing financial services, financial management, or enterprise reporting applications.

Responsibilities

Code solutions and unit tests to deliver requirements or stories in accordance with acceptance criteria and compliance requirements.
Design, develop, and modify architecture components, application interfaces, and solution enablers while maintaining principal architecture integrity.
Mentor software engineers and coach the team on CI/CD practices and automating the tool stack.
Refine stories, define requirements, and estimate work across the delivery lifecycle.
Perform spikes or proofs of concept as needed to mitigate risk or implement new ideas.
Automate manual release activities.
Design, develop, and maintain automated integration, regression, and performance test suites.
Design, develop, and support Oracle database components, tables, views, stored procedures, packages, ETL processes, and data integrations using SQL, PL/SQL, and enterprise ETL tools such as Informatica or DataStage.
Analyze complex database, data, and application issues; perform SQL and database performance tuning; identify root causes; and implement reliable solutions.
Develop and integrate backend data services and interfaces to support end-to-end application functionality.