What are the responsibilities and job description for the Big Data Modeler position at Resource Informatics Group?
Big Data Modeler
Las Vegas, NV (Onsite)
TOP Skills : Data Modelling, Data Analysis, Snowflake, Data Vault 2.0, Hive, (Erwin / ER / Studio / Toad Data Modeler), SQL, DB2, MDM
Job Description :
- 5 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 , 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 DataGovernance 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, DataDictionary, 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 .
