Data Engineer III

Bank of America; Jersey City (NJ); On-site; USD 104,000 - 158,000; Full time

Benefits offered by this job

Health benefits

Job summary

Bank of America in Jersey City, NJ hires a Data Management, Database Specialist to drive complex data solutions, oversee data lineage, and manage migrations with vendors and stakeholders. You will lead data integration, testing, and automation efforts to ensure regulatory compliance and robust data platforms.

You will collaborate with Product and Software Engineering teams to implement data requirements, monitor performance, and support secure, compliant data environments across finance

Qualifications

• 7-10 years of applicable experience.
• Strong hands-on experience with RDBMS on Sybase ASE, IBM DB2 LUW or Oracle database platforms.
• Data Lineage and ADS sourcing management experience.
• Experience with database migrations.
• Experience working with ETL tools especially Informatica.
• The best practices and regulated environments are preferred.

Responsibilities

• Leads story refinement and delivery of requirements through the delivery lifecycle and assists team members in resolving technical complexities.
• Codes complex solutions to integrate, clean, transform, and control data, builds processes supporting data transformation, data structures, metadata, data quality controls, dependency, and workload management.
• Leads documentation of system requirements, collaborates with development teams to understand data requirements and feasibility, and leverages architectural components to develop client requirements.
• Leads testing teams to develop test plans, contributes to existing test suites including integration, regression, and performance, analyzes test reports and triages issues.
• Leads work with technology partners and stakeholders to close gaps in data management standards adherence and communicates solutions to complex problems.
• Leads complex information technology projects to ensure on-time delivery and builds data pipelines for data-informed decisions.
• Mentors Data Engineers and monitors key performance indicators and internal controls.
• Authoritative Data Sourcing (ADS) management and regulatory data lineage.
• Create automation and scripts to perform functionality, reconciliation and data migration.
• Work closely with database architects, developers, and security teams to resolve issues.
• Execute database migration projects and support cutover execution.

Skills

Analytical Thinking

Application Development

Data Management

DevOps Practices

Solution Design

Agile Practices

Collaboration

Decision Making

Risk Management

Test Engineering

Architecture

Business Acumen

Data Quality Management

Financial Management

Solution Delivery Process

Tools

Sybase ASE

IBM DB2 LUW

Oracle

Informatica

Job description

Job Description:

At the company, we are guided by a common purpose to help make financial lives better through the power of every connection. We do this by driving Responsible Growth and delivering for our clients, teammates, communities and shareholders every day.

Being a Great Place to Work and providing a culture of caring is core to how we drive Responsible Growth. We are intentional about fostering an inclusive workplace where every teammate has the opportunity to succeed, build a career and contribute to our shared success. This includes attracting and developing exceptional talent, recognizing and rewarding performance, and supporting our teammates' physical, emotional, and financial wellness through affordable, competitive and flexible benefits.

We value the unique perspectives individuals bring from all backgrounds and career paths - whether shaped by military service, community college education, or a wide range of work and life experiences. These journeys foster resilience, leadership and innovation, strengthening our workforce and positively impact the communities we serve.

the company is committed to an in-office culture that supports collaboration, engagement, and career development. Our approach includes clear in-office expectations, while providing an appropriate level of flexibility based on role-specific responsibilities and business needs.

At the company, you can build a successful career with opportunities to learn, grow, and make an impact. Join us!

Job Description:This job is responsible for driving efforts to develop and deliver complex data solutions to accomplish technology and business goals. Key responsibilities include leading code design and delivery tasks with the integration, cleaning, transformation and control of data in operational and analytical data systems. Job expectations include liaising with vendors and working with stakeholders and Product and Software Engineering teams to implement data requirements, analyzing performance, and researching and troubleshooting issues within system engineering domains.

Position Summary:

The Data Management, Database Specialist will help execute regulatory project requiring data lineage while also driving key data platform migration initiatives. This employee will also work in projects that involve data migration, intensive testing, and security/compliance assurance related to data projects.

Responsibilities:

• Leads story refinement and delivery of requirements through the delivery lifecycle and assists team members in resolving technical complexities
• Codes complex solutions to integrate, clean, transform, and control data, builds processes supporting data transformation, data structures, metadata, data quality controls, dependency, and workload management, assembles complex data sets, and communicates required information for deployment
• Leads documentation of system requirements, collaborates with development teams to understand data requirements and feasibility, and leverages architectural components to develop client requirements
• Leads testing teams to develop test plans, contributes to existing test suites including integration, regression, and performance, analyzes test reports, identifies test issues and errors, and leads triage of underlying causes
• Leads work efforts with technology partners and stakeholders to close gaps in data management standards adherence, negotiates paths forward by thinking outside the box to identify and communicate solutions to complex problems, and leverages knowledge of information systems, techniques, and processes
• Leads complex information technology projects to ensure on-time delivery and adherence to release processes and risk management and defines and builds data pipelines to enable data-informed decision making
• Mentors Data Engineers to enable continuous development and monitors key performance indicators and internal controls
• Authoritative Data Sourcing (ADS) management.
• Regulatory reporting data lineage
• Create automation, write scripts to perform functionality, reconciliation.
• Create automation, write scripts to facilitate data migration, reconciliation, and integrity validation.
• Work closely with database architects, database developers, application and security teams to resolve issues.
• Execute database migration projects.
• Support cutover execution and post-migration stabilization.

Required Qualifications:

• 7-10 years of applicable experience
• Strong hands-on experience with RDBMS, on Sybase ASE, IBM DB2 (LUW) or Oracle database platforms.
• Data Lineage and ADS sourcing management experience
• Experience with database migrations.
• Experience working with ETL tools especially Informatica.
• The best practices and regulated environments are preferred.

Desired Qualifications:

• Database migration experience
• Strong knowledge and skills in database technologies
• Data Migration and Reconciliation knowledge
• Performance engineering
• performance and volume testing
• Working in a large team environment with various skills and stakeholders

Skills:

• Analytical Thinking
• Application Development
• Data Management
• DevOps Practices
• Solution Design
• Agile Practices
• Collaboration
• Decision Making
• Risk Management
• Test Engineering
• Architecture
• Business Acumen
• Data Quality Management
• Financial Management
• Solution Delivery Process

Shift:1st shift (United States of America)

Hours Per Week:40

Pay Transparency details

US - NJ - Jersey City - 101 Hudson St - 101 Hudson (NJ2101), US - NY - New York - 1100 Ave Of The Americas - Two Bryant Park (NY1540)

Pay and benefits information

Pay range

$104,000.00 - $157,700.00 annualized salary, offers to be determined based on experience, education and skill set.

Discretionary incentive eligible

This role is eligible to participate in the annual discretionary plan. Employees are eligible for an annual discretionary award based on their overall individual performance results and behaviors, the performance and contributions of their line of business and/or group; and the overall success of the Company.

Benefits

This role is currently benefits eligible. We provide industry-leading benefits, access to paid time off, resources and support to our employees so they can make a genuine impact and contribute to the sustainable growth of our business and the communities we serve.