Data Modeler C2C jobs in Houston, Tx/New York/Wisconsin

Data Modeler

Location : Houston TX , Newyork and Wisconsin Any one of the location onsite

 

“Key Responsibilities

              Design logical and physical models for enterprise data warehouses and data marts using dimensional modeling and Data Vault techniques

               Develop optimized schemas based on data usage patterns query requirements and Snowflake architecture to reduce compute costs and improve execution speed

              Collaborate with business users and stakeholders to understand data needs identify key metrics and translate them into data models suitable for Snowflake

              Design and document data models using industry best practices including creating conceptual logical and physical data models within the Snowflake environment

              Develop optimized data schemas star snowflake dimensional based on data usage patterns and query requirements considering data volume and performance considerations

              Define data cleansing and transformation rules to ensure data quality and consistency before loading it into Snowflake

Analyze query performance and identify bottlenecks optimizing data models and indexing strategies to improve query execution speed

              Implement data governance practices to ensure data quality security and compliance with relevant regulations

              Create detailed data model documentation and provide training to data engineers and analysts on data structures and access methods

              Enforce data quality frameworks metadata management and compliance standards within the Snowflake environment

              Create data dictionaries and detailed model documentation provide training to analysts on accessing data structures

              Enforce data quality frameworks metadata management and compliance standards within the Snowflake environment

 

Required Skills

              10 years of experience in data warehousing and data modeling with a minimum of  5  years specifically dedicated to Snowflake environments

              Deep understanding of Snowflake architecture features query language SQL and data modeling capabilities

              Strong ability to diagnose bottlenecks and tune SQL queries for performance

              Extensive experience in designing and implementing relational dimensional and star schema data models

              Ability to analyze data usage patterns and identify potential data quality issues

              Strong communication skills to effectively collaborate with crossfunctional teams including business stakeholders data engineers and data analysts

Proficiency with data modeling tools like ER diagramming software eg Erwin ERStudio Erwin Data Modeler ERStudio or Lucidchart

              Understanding of data integration principles and tools

              Familiarity with integrating Snowflake with underlying cloud providers like AWS Azure or GCP”

 

 

 

Neha Chaudhary Team Lead – Recruitment e: neha.chaudhary@compunnel.com  o: (+1) 609-606-9010 ext.2469 m: (+1) 732-743-9949  HQ: 4390 Route 1 North, Suite 302, Princeton, NJ 08540, USA.