Deloitte

Senior Consultant - Data Modeler

Deloitte  •  Luxembourg, LU (Onsite)  •  13 days ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

Your future team

Join our team as Data Modeler to design, develop, and maintain high-quality data models for leading financial institutions that support enterprise data warehousing, business intelligence, analytics, and regulatory reporting. The Data Modeler will be responsible for creating conceptual and logical, and support in the creation of technical data models, ensuring alignment with business requirements, data governance standards, and enterprise architecture.

The ideal candidate will possess strong expertise in banking data domains and be familiar with regulatory reporting frameworks, including AnaCredit, FINREP, and COREP, as well as broader regulatory expectations such as BCBS 239. The Data Modeler will collaborate closely with business stakeholders, regulatory reporting teams, data architects, and IT delivery teams to ensure that data structures accurately reflect business concepts and support high-quality, auditable reporting.

The advantages of joining us

  • Career growth, your way
    Access top-notch training and career development, with a clear progression path to help you level up at your own pace.
  • Global impact, local connections
    Work on international projects and collaborate with diverse teams, all while making an impact locally.
  • Innovative work that matters
    Tackle cutting-edge projects and utilize the latest tech, with all the tools you need to stay ahead.
  • Inclusive, flexible culture
    Embrace a culture where your voice matters, with flexible hours to balance work and life seamlessly.
  • Purpose-driven work
    Get involved in sustainability initiatives and community service, making a real difference while growing your career.

How you’ll contribute to our success

  • Conceptual Data Modeling
    • Develop enterprise-level conceptual data models representing key banking domains, including Customers and counterparties, Credit facilities and exposures, Deposits and accounts, Financial instruments and securities, Collateral and guarantees, Risk and capital metrics, General ledger and accounting, etc.
    • Facilitate workshops with business stakeholders to capture business concepts, definitions, and relationships.
    • Align conceptual models with the enterprise data strategy and business glossary.
    • Ensure consistency of terminology across Risk, Finance, and Regulatory functions.
  • Logical Data Modeling
    • Translate conceptual models into detailed logical data models
    • Ensure traceability from business requirements to logical structures.
    • Align models with regulatory data dictionaries and industry standards, such as the Banks’ Integrated Reporting Dictionary (BIRD).
  • Physical Data Modeling Support
    • Provide guidance and validation for physical data models implemented in Enterprise Data Warehouses or lakehouse environments.
    • Collaborate with data architects and engineers to define table structures and storage strategies, indexing and partitioning, data lineage and auditability.
    • Support implementation across different technologies
  • Regulatory Reporting Enablement
    • Design data structures supporting regulatory reporting (e.g.: AnaCredit, FINREP, COREP, etc.)
    • Ensure alignment with EBA/ECB taxonomies.
    • Collaborate with Risk and Finance teams to interpret regulatory requirements and translate them into data model specifications.
    • Support data reconciliation between finance, risk, and regulatory datasets.
    • Contribute to compliance with BCBS 239 principles, ensuring data accuracy, completeness, consistency, and traceability.
  • Data Warehouse & Analytics Modeling
    • Design data models for Enterprise Data Warehouses and data marts supporting risk, finance, and customer analytics.
    • Apply appropriate modeling methodologies
    • Ensure models support historization, auditability, and regulatory traceability.
  • Data Governance & Quality
    • Align data models with data governance frameworks and metadata management practices.
    • Define and document critical data elements (CDEs) and support data quality rule definition.
    • Ensure compliance with data privacy and security regulations, including GDPR.
    • Contribute to data lineage and impact analysis documentation.
  • Stakeholder Engagement
    • Collaborate with business teams including Risk and Finance departments, Regulatory reporting teams, data architects and engineers, Data governance and quality teams, and other business analysts and subject matter experts.
    • Lead data modeling workshops and present models to both technical and non-technical stakeholders.
    • Provide expert advisory on banking data structures and regulatory implications.
  • Documentation & Standards
    • Produce and maintain comprehensive documentation, including:
      • Conceptual, logical, and physical data models
      • Data dictionaries and metadata
      • Source-to-target mappings
      • Lineage and impact assessments
    • Establish and enforce data modeling standards, naming conventions, and best practices.

Your Profile

  • Master’s degree in Computer Science, Information Systems, Finance, Data Management, or a related field.
  • 4+ years of experience in data modeling within the banking or financial services industry.
  • Proven experience designing or supporting in the design of Enterprise Data Warehouse models.
  • Demonstrated expertise in regulatory reporting, including AnaCredit, FINREP, COREP
  • Experience working on BCBS 239 or similar regulatory compliance initiatives.
  • Good understanding of different Data Modeling Methodologies (Entity-Relationship (ER) modeling, Third Normal Form (3NF), Dimensional Modeling (Star/Snowflake), etc.)
  • Solid understanding of key banking domains
  • Proficiency with data modeling tools such as: Erwin, ER/Studio, PowerDesigner, etc.
  • Strong SQL skills and experience with relational databases.
  • Understanding of ETL/ELT processes and data integration.
  • Familiarity with data catalog and governance tools (e.g., Collibra, Alation, Informatica).
  • Excellent analytical and problem-solving skills.
  • Strong communication and stakeholder management abilities.
  • Ability to translate complex regulatory requirements into structured data models.
  • High attention to detail and data accuracy.
  • Capability to work effectively in cross-functional and international teams.
  • Solution-oriented mindset.
  • Eager to learn, you maintain positive attitude and resilience
  • Fluency in English and French

Interested? Please submit your resume in English

Get to know more about Deloitte on our LinkedIn page (#DeloitteLU), Instagram page, YouTube page or website

With more than 2,600 employees and 98 nationalities, Deloitte Luxembourg is one of the Grand Duchy's largest, strongest and oldest professional services firms. For more than 75 years, our talented teams have been serving clients in various industries delivering high added-value offerings to national and international clients in audit and assurance, consulting, financial advisory, risk advisory, tax, and related services. Deloitte Luxembourg is part of the global Deloitte network.

Deloitte provides leading professional services to nearly 90% of the Fortune Global 500® and thousands of private companies. Our people deliver measurable and lasting results that help reinforce public trust in capital markets and enable clients to transform and thrive. Building on its 180+-year history, Deloitte spans more than 150 countries and territories. Learn how Deloitte’s over 470,000 people worldwide work together every day to make an impact that matters at www.deloitte.com.

Deloitte

About Deloitte

Deloitte drives progress. Our firms around the world help clients become leaders wherever they choose to compete. Deloitte invests in outstanding people of diverse talents and backgrounds and empowers them to achieve more than they could elsewhere. Our work combines advice with action and integrity. We believe that when our clients and society are stronger, so are we.

Deloitte refers to one or more of Deloitte Touche Tohmatsu Limited (“DTTL”), its global network of member firms, and their related entities. DTTL (also referred to as “Deloitte Global”) and each of its member firms are legally separate and independent entities. DTTL does not provide services to clients. Please see www.deloitte.com/about to learn more.

The content on this page contains general information only, and none of Deloitte Touche Tohmatsu Limited, its member firms, or their related entities (collectively the “Deloitte Network”) is, by means of this publication, rendering professional advice or services. Before making any decision or taking any action that may affect your finances or your business, you should consult a qualified professional adviser. No entity in the Deloitte Network shall be responsible for any loss whatsoever sustained by any person who relies on content from this page.

Industry
Consulting & Advisory
Company Size
10,000+ employees
Headquarters
Worldwide, OO
Year Founded
1845
Social Media