Data Modeling

5 Star Recruitment; Las Vegas (NV); On-site; USD 120,000 - 180,000; Full time

Job summary

A staffing agency is looking for a Data Modeling expert with over 7 years of experience in Data Analysis and excellent communication skills. The role requires strong knowledge of cloud Data Warehousing tools like Snowflake, as well as expertise in designing complex Data Models in both on-prem and cloud environments. Familiarity with Data Lakehouse concepts and tools such as Hive and SQL Server is essential. Experience with Bill Inmon and Ralph Kimball methodologies is also preferred.

Qualifications

• 7+ years of experience in Data Modeling & Data Analysis with excellent communication and leadership skills.
• Strong understanding of cloud Datawarehouses like Snowflake.
• In-depth understanding of Data Lakehouse concepts and Big Data sources.

Skills

Data Modeling

Data Analysis

Cloud Data Warehousing

Communication

Leadership

Data Vault 2.0

Data Lakehouse

Hive

S3

Trino

Hue

Large-scale data modeling

Star and Snowflake schemas

On-prem and cloud databases

Data governance concepts

Tools

Snowflake

Hive

Erwin

Oracle

SQL Server

Job description

Qualifications

• 7 + years of experience in Data Modeling & Data Analysis and should have excellent communication and leadership skills.
• Financial Domain knowledge is plus.
• Should have strong understanding of cloud Datawarehouse like Snowflake and Data modelling skill using Data Vault 2.0.
• Should have in depth understanding or executed new concepts like Data Lakehouse and should have worked on Big Data sources / tools such as Hive , S3 , Trino , HUE, etc.
• Should have done complex (100+ entities/tables) Data Modeling programs in both on-prem and cloud environments.
• Experience in designing normalized, denormalized, relational, dimensional, star and snowflake schemas for cloud, big data and on prem databases using any one of these data modeling tools (Erwin, ER/Studio, Toad Data Modeler, etc.)
• Extensive Data Modeling experience in same or similar bigdata and cloud databases such as Hive, Redshift, Snowflake and on prem databases such as Oracle, SQL Server and DB2
• Should have experience in working with product managers, project managers, business users, applications development team members, DBA teams and Data Governance team daily to analyze requirements, design, development, and deployment technical solutions.
• Should have implemented Bill Inmon and Ralph Kimball methodologies to design data warehouses
• Should have in depth understanding on Data Warehousing, Data Analysis, Data Profiling, Master Data Management (MDM), Data Quality, Data Lineage, Data Dictionary, Data Mapping, Data Policy, and Data Governance.