8+ years of IT experience focusing on data modeling and data solutioning
8+ years of SQL experience with ability to read/write/manipulate queries; strong database fundamentals, performance, and schema design
Expertise in dimensional modeling (star schemas, cubes) and data modeling using Erwin and/or ER/Studio
Azure experience required; Snowflake and/or Databricks experience a plus; familiarity with cloud data architectures (AWS/Azure)
Requirements:
Build Relational and Dimensional Models for Integration, Semantic, and Audit layers; design and implement conceptual, logical, and physical data models and create corresponding physical data structures (DDLs)
Create source-to-target data mappings and business transformation rules in collaboration with business users
Lead cross-functional teams and gather requirements, analysis, design, and implementations of Data Warehouse, Business Intelligence, ERP, and Big Data (Hadoop) solutions using Agile methodologies
Architect large-scale DW/DL solutions using data modeling techniques (Kimball/Inmon), design Erwin/ER Studio models, and apply cloud patterns with Azure; familiarity with AWS, MDM, metadata governance
Job description
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.
