DB2 Data Modeler III (Market Risk)

Quest Oracle Community; Jersey City (NJ); On-site; USD 104,000 - 158,000; Full time

Benefits offered by this job

Benefits eligible

Discretionary incentive plan

Job summary

Bank of America in Jersey City seeks a senior data modeler to translate business data requirements into data models and architectures. You will own data dictionaries, data flows, and pipelines across Global Market Risk and Counterparty Credit Risk tech teams, enabling data-informed decisions.

The role collaborates with developers and stakeholders to ensure data quality, security, and scalable data platforms while driving strategic and regulatory projects.

Qualifications

• 10+ years of applicable experience.
• Data modeling using Power Designer.
• Relational and unstructured data knowledge; DB2, Oracle, Sybase, Impala, Kudu, Iceberg.

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.
• Strategic projects, Regulatory projects in global markets risk area would require senior data modeler with data modeling, data architecture and data engineering skills.

Skills

Analytical Thinking

Data Management

DevOps Practices

Solution Design

Agile Practices

Collaboration

Risk Management

Architecture

Business Acumen

Data Quality

Tools

Power Designer

Hadoop

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!

Position Summary

A series of strategic projects and regulatory projects (examples, Strategic Risk and PnL [SRPL], Fundamental Review of the Trading Book [FRTB]) in global markets risk area would require senior data modeler with data modeling, data dictionary, data analysis skills. This experienced data professional should be able to interpret business requirements, high level data flows and convert into data elements and data models. The person should be a self starter and passionate about business data modeling. The risk data modeler would work in a data horizontal team that are responsible for database architecture, database platforms, data models, performance engineering and database platform related security vulnerabilities across Global Market Risk Technology (GMRT) and Counterparty Credit Risk Technology (CCRT). The risk data modeler would work closely with the application development teams, business stakeholders, technology infrastructure database administrators to execute projects that are critical to the LOBs and technology partners.

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
• Strategic projects, Regulatory projects in global markets risk area would require senior data modeler with data modeling, data architecture and data engineering skills.

Required Qualifications

• 10+ years of applicable experience
• Data modeling. Familiarity with data modeling tools like Power Designer
• Database knowledge on relational and unstructured data is required. Preferably with RDBMS and Hadoop technologies are - db2, oracle, Sybase, impala, kudu, iceberg etc.
• Data architecture skills like overall data flow management, authoritative data source management, data discovery, data dictionary, data lineage.
• Data engineering skills - building data pipeline, data ingestion / retrieval, building distributed data systems

Desired Qualifications

• Database, SQL, performance tuning, scripting, coding in python / shell / Perl.
• Messaging like kafka
• Domain knowledge in finance and risk is preferred.
• Apache spark

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)

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.