Sr. Data Modeler

Visa status: U.S. Citizens and those authorized to work in the U.S. are encouraged to apply.
Tax Terms: W2, 1099
Corp-Corp or 3rd Parties: Yes

Sr. Data Modeler (With Azure and Snowflake experience)
Location: Columbus, OH (Work from home in Eastern time zone allowed)
Duration: Long term


Responsible for building Relational and Dimensional Models for Integration Layer, Semantic Layer & Audit Layer. Design and Build Conceptual, Logical, Physical Data Models and Create Physical Data Structures (DDLs). Create Source to Target Data Mapping rules with the business transformation rules by discussing with business users. Extensive experience in Solution design, Data architecture, Data modeling, Data integration and Business Analytics design and development.

Role:

• Build Relational and Dimensional Models for Integration Layer, Semantic Layer & Audit Layer
• Design and Build Conceptual, Logical, Physical Data Models and Create Physical Data Structures (DDLs).
• Create Source to Target Data Mapping rules with the business transformation rules by discussing with business users.
• Extensive experience in managing cross functional teams, leading the development, gathering Business Requirements, Analysis, Design, and Implementations of various functionalities of Data Warehouse, Business Intelligence, ERP applications and Big Data- Hadoop Solutions.
• Expert in Agile Data Warehouse, Enterprise Architecture using Industry model Framework Methodology, Data Modeling using E/R and Dimension Models, Conceptual, Logical and Physical Models for large scale DW and DL implementations.
• Expertise in the design of the Conceptual, Subject area Logical and Physical Data Models using Erwin and/or ER Studio Suite.
• Experience in Data model design frameworks and techniques pioneered by Ralph Kimball and Bill Inman.
• Experience in Master Data management, Metadata Management solutions and Data Governess Policies and Procedures.
• Azure experience required.
• Snowflake / Data bricks experience is a plus
• Build different design patterns, data architecture, Cloud technology stack (AWS/Azure)

Experience

• 8+ years IT experience, with focus on Data Modeling, Data solutioning.
• 8+ years' experience with SQL (ability to read/write/manipulate queries)
• Star-schemas, cubes, dimensional modeling
• Database platform layouts and configurations
• Strong database fundamentals including SQL, performance, and schema design.