Senior Data Modeler

CRISIL Limited

$120K — $145K *
Finance & Insurance
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 5+ years of enterprise data modeling experience
  • Strong knowledge of banking and finance across diverse sectors
  • Advanced SQL proficiency for data analysis and profiling
  • Comprehensive data management skill set from sourcing to reporting
  • Experience with modern data platforms like Snowflake and Databricks
  • Exceptional analytical and stakeholder management capabilities

Responsibilities

  • Analyze and extend existing finance data models for various business areas
  • Design and maintain comprehensive data models for financial products and transactions
  • Understand and document data requirements for newly onboarded banking sectors
  • Drive harmonization and standardization of data across business units
  • Define data mapping and transformation rules for integration into existing systems
  • Perform detailed data profiling and validation using advanced SQL techniques
  • Collaborate with cross-functional teams to ensure integration and adherence to standards

Benefits

  • Opportunity to shape data architecture for a leading global bank
  • Work on a high-impact Finance Data Platform
  • Collaborative environment with finance and technology experts
  • Involvement in diverse banking sectors enhancing professional scope
  • Potential for career advancement within an established global framework
Full Job Description
Role Overview We are looking for an experienced Data Modeler / Senior Data Modeler to support the expansion of an established enterprise Finance Data Platform within a leading global bank. The existing platform has been implemented for the Markets business, with established data models, data management standards, governance frameworks, and processing capabilities. The next phase will focus on onboarding additional business areas, including Corporate Banking, Wealth Management, Private Banking, and other banking businesses, onto the common Finance Data Platform. The role will focus on understanding the data structures, products, processes, and Finance requirements of these businesses and extending, adapting, and harmonising the existing enterprise data model to support them. Key Responsibilities 1. Analyse and extend the existing Finance data model developed for the Markets business to support additional business areas, while maximising reuse of existing entities, attributes, structures, and design patterns. 2. Design and maintain conceptual, logical, and physical data models covering products, transactions, positions, balances, customers, accounts, legal entities, cash flows, valuations, accounting attributes, and reporting data. 3. Understand the data landscape and product structures of newly onboarded businesses, including Corporate Banking, Wealth Management, Private Banking, Lending, Deposits, Treasury, and Investment Products, and identify common and business-specific data requirements. 4. Drive data harmonisation and standardisation across business areas by defining common business concepts, enterprise entities, attributes, hierarchies, taxonomies, reference data, and consistent data definitions. 5. Define source-to-target mappings, transformation rules, derivations, enrichment logic, and model extensions required to integrate new business data into the existing Finance Data Platform. 6. Perform detailed data analysis and profiling using advanced SQL to validate data structures, relationships, cardinality, business rules, data quality, and assumptions underpinning the target data model. 7. Ensure the data model supports downstream Finance requirements, including Financial Accounting, Product Control, FP&A, Financial Reporting, Regulatory Reporting, Management Reporting, reconciliation, and analytics. 8. Work with Finance SMEs, Data Analysts, Data Architects, Data Engineers, Governance, and Technology teams to ensure scalable implementation, appropriate metadata and lineage, adherence to modelling standards, and alignment with the broader Finance data architecture. Required Skills and Competencies 1. Strong enterprise data modelling experience, including conceptual, logical, and physical data modelling, with proven experience extending or harmonising existing enterprise data models. 2. Strong banking and Finance domain knowledge, with experience across multiple business areas such as Markets, Corporate Banking, Commercial Banking, Wealth Management, Private Banking, Lending, Deposits, or Treasury. 3. Advanced hands-on SQL skills for data profiling, structural and relationship analysis, reconciliation, source-to-target validation, exception analysis, and investigation of large and complex datasets. 4. Strong end-to-end data management experience, covering data sourcing, profiling, harmonisation, modelling, transformation, validation, reconciliation, data quality, metadata, lineage, governance, and reporting. 5. Experience working with large-scale modern data platforms and data management tools, including technologies such as Databricks, Snowflake, Hadoop, Spark, data lakes or lakehouses, and modelling or governance tools such as ERwin, PowerDesigner, Informatica, Collibra, or equivalent. 6. Strong analytical, consulting, stakeholder management, and communication skills, with the ability to engage Finance, Business, Architecture, Engineering, Governance, and Technology stakeholders and translate complex business requirements into scalable enterprise data models.

Similar Jobs

More Jobs at CRISIL Limited

More Finance & Insurance Jobs

Find similar Senior Data Modeler jobs: