Job Role: Data Modeler

Location: Las Vegas NV

Job Description:

• 5+ years of experience in Data Modeling & Data Analysis with excellent communication and leadership skills. Financial Domain knowledge is a plus.
• Strong understanding of cloud Data Warehouse technologies like SnowFlake and data modeling skills using Data Vault 2.0.
• In-depth understanding or execution of new concepts like Data Lakehouse; experience with Big Data sources/tools such as Hive, S3, Trino, HUE, etc.
• Experience with complex Data Modeling programs (100+ entities/tables) in both on-prem and cloud environments.
• Experience in designing normalized, denormalized, relational, dimensional, star, and snowflake schemas for cloud and on-prem databases using data modeling tools (Erwin, ER/Studio, Toad Data Modeler, etc.).
• Extensive Data Modeling experience with big data and cloud databases such as Hive, Redshift, Snowflake, as well as on-prem databases like Oracle, SQL Server, and DB2.
• Experience collaborating with product managers, project managers, business users, application development teams, DBA teams, and Data Governance teams to analyze requirements and design technical solutions.
• Implemented Bill Inman and Ralph Kimball methodologies for data warehouse design; in-depth understanding of Data Warehousing, Data Analysis, Data Profiling, Master Data Management (MDM), Data Quality, Data Lineage, Data Dictionary, Data Mapping, Data Policy, and Data Governance.
• Availability for at least 2 hours overlap with Pacific Time for interaction with the onsite team and participation in daily standup meetings.