Data Modeler - Banking Domain

Emperen Technologies; United States; Remote; USD 100,000 - 130,000; Full time

Job summary

Emperen Technologies is seeking a seasoned Data Modeler with over 7 years of experience to design and develop data models that support effective business intelligence solutions in the Banking domain. The ideal candidate will have strong expertise in Erwin/Erwin Studio, Dimensional Modelling, and proficiency in Snowflake and SQL, ensuring data integrity and quality in a remote environment.

Qualifications

• 7+ years of experience in Data Modelling and Data Analysis.
• Strong expertise in Erwin or Erwin Studio.
• Experience with Dimensional Modelling and Data Warehousing concepts.

Responsibilities

• Design and develop data models for business intelligence.
• Implement Dimensional Modelling techniques for data warehousing.
• Collaborate with stakeholders to gather data requirements.

Skills

Data Modelling

Data Analysis

Snowflake

SQL

Analytical Skills

Problem Solving

Communication Skills

Tools

Erwin

Erwin Studio

Job description

Key Responsibilities :

• Design and develop data models to support business intelligence and analytics solutions.
• Work with Erwin or Erwin Studio to create, manage, and optimize conceptual, logical, and physical data models.
• Implement Dimensional Modelling techniques for data warehousing and reporting.
• Collaborate with business analysts, data engineers, and stakeholders to gather and understand data requirements.
• Ensure data integrity, consistency, and compliance with Banking domain standards.
• Work with Snowflake to develop and optimize cloud-based data models.
• Write and execute complex SQL queries for data analysis and validation.
• Identify and resolve data quality issues and inconsistencies.

Required Skills & Qualifications :

• 7+ years of experience in Data Modelling and Data Analysis.
• Strong expertise in Erwin or Erwin Studio for data modeling.
• Experience with Dimensional Modelling and Data Warehousing (DWH) concepts.
• Proficiency in Snowflake and SQL for data management and querying.
• Previous experience in the Banking domain is mandatory.
• Strong analytical and problem-solving skills.
• Ability to work independently in a remote environment.
• Excellent verbal and written communication skills.