Senior Data Engineer – Data Migration & Lineage Lead

Quest Oracle Community; Jersey City, Northern (NJ, KY); Hybrid; USD 104,000 - 158,000; Full time

Job summary

Bank of America is seeking a Data Management/Database Specialist to drive complex data solutions, lead data integration and migration efforts, and ensure regulatory data lineage across projects. The role collaborates with vendors, stakeholders, and software engineering teams to implement data requirements, analyze performance, and troubleshoot issues within data systems.

The position emphasizes data migration, testing, and security/compliance assurance, with responsibilities spanning design,

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, 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.

Job description

Bank of America is seeking a Data Management/Database Specialist to drive complex data solutions, lead data integration and migration efforts, and ensure regulatory data lineage across projects. The role collaborates with vendors, stakeholders, and software engineering teams to implement data requirements, analyze performance, and troubleshoot issues within data systems.

The position emphasizes data migration, testing, and security/compliance assurance, with responsibilities spanning design,