DB2 Data Modeler

This role requires hands-on DB2 data modeling experience, with the ability to translate business requirements and high-level data flows into clear data elements, dictionaries, and models. The focus is data modeling and architecture; database administration experience alone will not meet the requirements.

\n

The ideal candidate brings financial services experience, preferably in market risk, and can collaborate with business stakeholders, application developers, data engineers, and database administrators., * 10+ years of relevant experience in data modeling, data architecture, or related data disciplines. \n

• Demonstrated hands-on experience modeling data in DB2 environments. \n

• Experience developing conceptual, logical, and physical data models using tools such as SAP PowerDesigner or comparable platforms. \n

• Strong understanding of relational database design, SQL, and complex data structures. \n

• Experience with data dictionaries, metadata management, data discovery, data lineage, and authoritative data sources. \n

• Ability to interpret business requirements and translate them into practical data models and technical solutions. \n

• Experience with data pipelines, ingestion, retrieval, and distributed data systems. \n

• Strong analytical, problem-solving, communication, and stakeholder collaboration skills. \n, * Financial services or capital markets experience, especially market risk or counterparty credit risk. \n

• Familiarity with risk and P&L data, SRPL, FRTB, or related regulatory initiatives. \n

• Candidates local to New York or New Jersey. \n

• Experience with Oracle, Sybase, Impala, Kudu, Iceberg, or Hadoop-based platforms. \n

• SQL performance tuning and scripting experience using Python, Shell, or Perl. \n

• Experience with Apache Kafka and Apache Spark. \n

• Familiarity with Agile delivery, DevOps practices, testing, and technology risk controls. \n, DB2 Data Modeling * Data Architecture * SQL * PowerDesigner * Data Dictionaries * Data Lineage * Data Quality * Data Engineering * Market Risk * Solution Design * Stakeholder Collaboration

n \n

• Design and maintain conceptual, logical, and physical data models, with a specific focus on DB2. \n

• Translate business requirements and data flows into data structures, definitions, mappings, and technical specifications. \n

• Develop and maintain data dictionaries, metadata, data lineage, and authoritative source documentation. \n

• Support strategic and regulatory projects across global markets risk and counterparty credit risk technology. \n

• Collaborate with application development teams and business stakeholders to validate requirements and ensure models support operational and analytical needs. \n

• Design and support data integration, ingestion, transformation, and retrieval processes. \n

• Establish data quality controls and resolve gaps in data management standards. \n

• Analyze data structures and SQL performance, partnering with database administrators and infrastructure teams on improvements. \n

• Lead requirements refinement, technical documentation, and resolution of complex data issues throughout the delivery lifecycle. \n

• Support integration, regression, and performance testing, including troubleshooting and issue resolution. \n

• Guide data engineers and support timely delivery within established release and risk management processes. \n

\n