Description

You will lead complex data modeling programs across on-prem and cloud environments.

Responsibilities

• Design normalized, denormalized, relational, dimensional, star, and snowflake schemas for big data and cloud databases.
• Execute large-scale data modeling programs involving over 100 entities and tables.
• Collaborate daily with product managers, project managers, business users, application developers, DBAs, and Data Governance teams to design and deploy technical solutions.
• Implement Bill Inmon and Ralph Kimball methodologies to build data warehouses.
• Analyze requirements through data profiling, mapping, and lineage assessment.

Required Skills

• 8+ years of experience in Data Modeling and Data Analysis.
• Expertise in Data Vault 2.0 modeling techniques.
• Hands-on experience with Snowflake cloud data warehousing.
• Proficiency with big data sources and tools including Hive, S3, Trino, and Hue.
• Experience managing data in Oracle, SQL Server, or DB2 environments.
• Practical knowledge of Data Lakehouse concepts.
• Skill in using modeling tools such as Erwin, ER/Studio, or Toad Data Modeler.
• Deep understanding of Master Data Management (MDM), Data Quality, Data Dictionary, and Data Governance.
• Ability to work within both on-prem and cloud architectures.

Preferred Skills

• Knowledge of the Financial Domain.

Key Skills

Education

Any Graduate