Data Architect

National Black MBA Association; Jersey City (NJ); On-site; USD 120,000 - 136,000; Full time

Benefits offered by this job

Discretionary incentive eligible

Benefits

Job summary

Bank of America in Jersey City is seeking a Database Migration Specialist / Database Architect to lead end-to-end DB2 Sailfish to Cloud Rack migrations, validate environments, run tests and ensure security/compliance.

You will collaborate with application, infrastructure, IBM, and security teams, develop runbooks, and support cutover and post-migration stability, in a 1st shift, 40-hour work week.

Qualifications

• 10+ years of overall experience in data/architecture roles.
• 5+ years of relevant technology experience.
• Experience with DB2, Oracle, Sybase and related DBMS.
• Knowledge of data modeling, STAR/Snowflake schemas.
• ETL with Informatica and data integration.
• ADS management, data lineage and governance.
• Strong communication and stakeholder management.

Responsibilities

• Establishes data solutions and architecture for large, complex initiatives that align with the enterprise data architecture strategy.
• Provides clear and concise responses regarding the enterprise data architecture strategy.
• Contributes to multiple priorities in a matrixed environment with attention to detail.
• Communicates effectively to influence agreement between partners and escalates items as needed to stay on track.
• Ensures all relevant risk, financial, and compliance policies and standards are met.
• Creates an inclusive and healthy working environment to resolve impediments and blockers.
• Shares enterprise data architectural principles, processes, and routines.
• Executes DB2 Sailfish to DB2 Cloud Rack migrations including environment and configuration validation.
• Validate infrastructure, database configuration, network connectivity, and access controls.
• Perform functionality, performance, stress, scalability, and failover testing.
• Work closely with application, infrastructure, IBM, and security teams to resolve issues.
• Develop migration runbooks, validation reports, and sign-off documentation.
• Support cutover execution and post-migration stabilization.

Skills

Architecture

Business Analytics

Critical Thinking

Data Management

Data Visualization

Consulting

Data Modeling

Process Design

Regulatory Compliance

Risk Management

Cloud Solutions

Collaboration

Data Governance

Solution Delivery Process

Technical Strategy Development

Education

Bachelors degree in Computer Science or equivalent Engineering

Job description

Job Description

At Bank of America, 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.
Bank of America 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 Bank of America, you can build a successful career with opportunities to learn, grow, and make an impact. Join us!

Job Description

This job is responsible for the development of data architectural solutions for complex initiatives within one or more lines of business and control functions. Key responsibilities include assisting solution-driven discussions, supporting adherence to the enterprise data management policy and standards, and supporting architecture design reviews to ensure integration of data architecture principles in technology solutions. Job expectations include understanding enterprise data architectural principles and data management processes and routines.

Position Summary

The Database Migration Specialist / Database Architect will execute end-to-end DB2 Sailfish to Cloud Rack migration activities, including environment validation, data migration, intensive testing, and security/compliance assurance.

Responsibilities

• Establishes data solutions and architecture for large, complex initiatives that align with the enterprise data architecture strategy and technology and platform decisions
• Provides clear and concise responses to questions regarding the enterprise data architecture strategy
• Contributes to multiple priorities in a matrixed environment with attention to detail and accuracy
• Communicates effectively to influence agreement between partners and escalates items, as needed, to ensure execution activities remain on track
• Ensures all relevant risk, financial, and compliance policies and standards are met
• Creates an inclusive and healthy working environment to resolve organizational impediments and blockers
• Shares enterprise data architectural principles, processes, and routines
• Execute DB2 Sailfish to DB2 Cloud Rack migrations including environment and configuration validation.
• Validate infrastructure, database configuration, network connectivity, and access controls.
• Perform functionality, performance, stress, scalability, and failover testing.
• Execute data migration, reconciliation, and integrity validation.
• Work closely with application, infrastructure, IBM, and security teams to resolve issues.
• Develop migration of runbooks, validation reports, and sign-off documentation.
• Support cutover execution and post-migration stabilization.

Required Qualifications

• 10+ years of overall experience
• 5+ years of relevant technology experience listed below
• Database Skills:
  • RDBMS; specifically Oracle, DB2, Sybase mandatory
  • NoSQL knowledge like Hadoop, Impala, Iceberg optional
  • Maintaining / supporting very large database platform working with other stakeholders
• Data Modeling:
  • Knowledge in data modeling, STAR / Snowflake schema, normalized and denormalized data models
  • Prior knowledge in data modeling tools like Power Designer and Erwin preferred but not mandatory
• Database Application Development Skills:
  • Writing views and Stored procedures
  • Strong concepts in creating end to end data pipelines
  • Scripting in shell, Python
• ETL:
  • Informatica mapping creation; using maps to move data from one platform to another.
• ADS Management:
  • Foundational knowledge on data domain and ADS management
  • Data lineage
  • Data analysis
• Soft Skills:
  • Strong communication skills
  • Strong stakeholder management skills

Skills

• Architecture
• Business Analytics
• Critical Thinking
• Data Management
• Data Visualization
• Consulting
• Data Modeling
• Process Design
• Regulatory Compliance
• Risk Management
• Cloud Solutions
• Collaboration
• Data Governance
• Solution Delivery Process
• Technical Strategy Development

Bachelors degree in Computer Science or equivalent Engineering

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 - NJ - Pennington - 1500 American Blvd - Hopewell Bldg 5 (NJ2150)

Pay and benefits information

• Pay range$120,000.00 - $136,100.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.