Data Modeler

Job Title: Senior Data Modeler Client Company: Inspire Brands Location: Atlanta, GA Duration: 12+ Months

W2 Only During COVID it’s REMOTE

Required Skills:

• Must have a minimum of 7 years of experience as a Data Modeler Experience with both psychical and logical modeling from scratch Very versatile with ErWin Azure experience, but open to any other cloud technology

Additional Skills: SQL DBM (cataloging) Calibra

Job Description: This role will be responsible for the design, development and maintenance of data models and standards for a big data environment to address data and analytics needs of a very fast paced multi brand organization

Job Description

• Works with Data and Analytics team of product owners, scrum masters, business analysts and enterprise data architects to understand reporting and analytics requirements of the business. • Performs data profiling or analysis activities that will help understand source and target data attributes. • Designs and develops conceptual, logical and physical data models that are scalable and optimized to meet data warehouse architecture as well as business analytics need. • Implements and maintains data models for conformed / raw and mart zones. • Develops and maintains technical documentation, metadata definition and catalog of the data structures in brand agnostic conformed layer and data mart. • Articulates data modeling principles and guidelines to ETL developers. • Collaborates with ETL developers to architect and develop ETL processes as per the defined data models. • Researches, troubleshoots, and resolves data issues impacting reports and dashboard delivery. • Understands existing data models and optimize for enhanced performance. • Collaborates with the data and analytics team to suggest efficient and innovative solutions. • Supports ongoing maintenance of data structures in the data platform.

• Demonstrated knowledge in cloud data platforms (e.g., Snowflake, Databricks Delta, Big Query etc.) • Proficiency in SQL; Ability to understand, modify and write complex SQL queries • Knowledge of ETL tools preferably Talend, SSIS or Azure Data Factory • Experience in any programming language such as Java, Python, Scala

Qualifications

• Four years of college degree, or equivalent experience. • 5+ years of experience in data modeling methodologies and techniques (Relational, Star, Snowflake and no SQL Schema) and Database Warehousing Deep understanding of conceptual, logical and physical data models • Experience with modern Data modeling tools (e.g., Erwin, ER Studio, SQL DBM etc.) and standards • Experience with information architecture concepts (Master data management, metadata management) Proficiency in data lifecycle and data architecture concepts • Good understanding of Agile and SDLC methodologies Knowledge of industry-wide technology trends and leading practices

Thanks & Regards,

Mohan Kumar B | Technical Recruiter | Wave Solutions Inc. | 314 N. Lake St, Suite 6, Aurora IL 60506 Email: kumar@wavsols.com Direct #: 630-566-9398| Fax: 630-566-9398 Main #:6305669398, EXT: 108 Website: www.wavsols.com LinkedIn: https://www.linkedin.com/in/mohan-kumar-bangaru-b424467b/