Data Modeler with Data Vault Engineer

Overview

On Site
Full Time

Skills

Data Analysis
Marketing Analysis
Big Data
Database Modeling
Oracle
DB2
Deployment
Data Mapping
MS SQL Server
ETL
Data Quality
Data Sources
Data Governance
Leadership Skills
Data Warehouses
Data Warehousing
Data Modeling
Erwin
Applications Development
Master Data Management
Hive
Data Profiling
Data Lineage
Datawarehouse

Job Details

Position: Data Modeler with Data Vault Engineer

Location: Las Vegas, NV(Onsite)

Duration: Fulltime

Job Description

Must Have Technical/Functional Skills

  • 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 knowledge of SSIS ETL packages and need to analyze existing business logic and convert them into modern ELT approach.
  • 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 .

Roles & Responsibilities

  • Should have strong understanding of cloud Datawarehouse like SnowFlake and Data modelling skill using Data Vault 2.0 .
  • Should have knowledge of SSIS ETL packages and need to analyze existing business logic and convert them into modern ELT approach.
  • 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).
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.