Senior Data Modeler

CRISIL Limited

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

Qualifications

  • 5-7 years of enterprise data modeling experience with focus on finance
  • Strong knowledge of banking products across multiple areas
  • Advanced SQL proficiency for complex data analysis
  • Comprehensive end-to-end data management expertise
  • Experience with modern data platforms and relevant tools
  • Excellent analytical and stakeholder management skills

Responsibilities

  • Analyze and extend existing Finance data models for new business areas
  • Design and maintain comprehensive data models covering various finance aspects
  • Understand and document data landscape for newly onboarded businesses
  • Drive data harmonization and standardization across different business areas
  • Define mappings and transformation rules for new data integration
  • Conduct detailed data analysis and profiling to validate data assumptions
  • Collaborate with cross-functional teams to ensure scalable data architecture

Benefits

  • Opportunity to work within a leading global bank
  • Involvement in key enterprise finance projects
  • Potential for impactful contributions to banking data analytics
  • Chance to collaborate with top data and finance professionals
  • Exposure to modern data management tools and practices
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: