Data Modeler : Location: Las Vegas, Nevada (Hybrid)

Data Modeler

Location: Las Vegas, Nevada

Duration – Long Term Project 

Job Description:

• 10+ years of experience in Data Modeling & Data Analyst 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 data sources / tools such as Hive, S3, Icimo, 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 big data 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 on a daily basis 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.
• Need to have at least 2 hours overlap with Pacific Timings to interact with Onsite team and to attend daily standup meetings.
• Nice to have knowledge of SSIS ETL packages / Need to analyze and troubleshooting these packages.
• Analyze legacy ETL packages built in SSIS and convert them to ELT logic.
• Handling of various sources like RDBMS, Files like Flatfile, Json, Realtime Kafka messages.

Email