drjobs Data Modeler

Data Modeler

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Las Vegas - USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Data Modeler

Location: Las Vegas

12 months Contract
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 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.

Employment Type

Full Time

Company Industry

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.