DB2 Data Modeler III (Market Risk)

Bank of America•Jersey City, NJ

24d•Onsite

About The Position

At Bank of America, the role supports strategic and regulatory projects in Global Markets Risk, including Strategic Risk and PnL (SRPL) and Fundamental Review of the Trading Book (FRTB). The Data Modeler interprets business requirements and high-level data flows and translates them into data elements and data models. The position is part of a data horizontal team responsible for database architecture, database platforms, data models, performance engineering, and database-platform security vulnerabilities across Global Market Risk Technology (GMRT) and Counterparty Credit Risk Technology (CCRT). The role works closely with application development teams, business stakeholders, and technology infrastructure database administrators on projects critical to the lines of business and technology partners. The position drives the development and delivery of complex data solutions that meet technology and business goals. It leads code design and delivery involving the integration, cleaning, transformation, and control of data in operational and analytical systems. The role also collaborates with vendors, stakeholders, Product and Software Engineering teams, and technology partners; analyzes performance; and researches and troubleshoots issues in system engineering domains. Bank of America describes its culture as inclusive and supportive of teammates' career development and physical, emotional, and financial wellness. The company states that it is committed to an in-office culture supporting collaboration, engagement, and career development, with flexibility based on role-specific responsibilities and business needs. The job is based at 101 Hudson St, Jersey City, New Jersey. It is 40 hours per week, with no travel required. The position is eligible for benefits and an annual discretionary incentive plan.

Requirements

10 or more years of applicable experience.
Experience with data modeling.
Familiarity with data modeling tools such as Power Designer.
Knowledge of relational and unstructured data.
Data architecture skills, including overall data flow management, authoritative data source management, data discovery, data dictionaries, and data lineage.
Data engineering skills, including building data pipelines, data ingestion and retrieval, and distributed data systems.

Nice To Haves

Experience with RDBMS and Hadoop technologies, preferably DB2, Oracle, Sybase, Impala, Kudu, or Iceberg.
Database, SQL, performance tuning, scripting, and coding skills in Python, shell, or Perl.
Experience with messaging technologies such as Kafka.
Finance and risk domain knowledge.
Apache Spark.

Responsibilities

Lead story refinement and delivery of requirements throughout the delivery lifecycle, and assist team members in resolving technical complexities.
Code complex solutions to integrate, clean, transform, and control data; build processes supporting data transformation, data structures, metadata, data quality controls, dependencies, and workload management; assemble complex data sets; and communicate information required for deployment.
Lead documentation of system requirements, collaborate with development teams to understand data requirements and feasibility, and use architectural components to develop client requirements.
Lead testing teams in developing test plans; contribute to integration, regression, and performance test suites; analyze test reports; identify test issues and errors; and lead triage of underlying causes.
Work with technology partners and stakeholders to close gaps in adherence to data management standards, negotiate paths forward, and identify and communicate solutions to complex problems.
Lead complex information technology projects to ensure on-time delivery and adherence to release processes and risk management.
Define and build data pipelines to enable data-informed decision-making.
Mentor Data Engineers to support their continuous development.
Monitor key performance indicators and internal controls.
Work with application development teams, business stakeholders, and technology infrastructure database administrators to execute projects.