Senior Data Modeler

• Primary job function entails gathering and assessing business and technical requirements to create/update database objects. • Delivery items include using ERwin Data Modeler to create and maintain entity relationship diagrams, DDL, and supporting documentation as needed. • Additional job functions include identifying solution design options, advanced data profiling and subject matter expertise. • This role works closely with all development resources including Business Systems Analysts, Developers and Project Managers. • The Senior Data Modeler works independently with minimal guidance and acts as a resource for colleagues with less experience. • A solid understanding of the following is required: • Agile Methodology • Logical and Physical data modeling • Levels of Normalization • Abstraction and Generalization • Subtyping and Classification • Relational model design • Dimensional model design (Star Schemas, Snowflake designs) • Inmon & Kimball methodologies • Master Data Management (MDM) • Data Profiling • Metadata Management • Data security and protecting information • ETL processes, BI processes • Cloud Platforms, especially Google Cloud Platform • Requirements:7+ years of proven experience in Data Modeling • 5+ years of experience with advanced SQL query techniques • Highly skilled in Erwin, including but not limited to: Diagraming, Complete Compare, Reverse Engineering, Forward Engineering • Strong multi-tasking capability, with adaptability to work simultaneously in multiple environments with differing procedures, SME support and level of accountability • Ability to estimate scope of effort, to prioritize and/or fast track requirements, and to provide multiple options for data-driven solution design • Demonstrated ability to recognize, elicit and/or decompose complex business requirements • Demonstrated ability to perceive patterns and relationships in data • Demonstrated ability to design models which integrate data from disparate sources • Demonstrated ability to design data models for complex and ragged hierarchies • Demonstrated ability to design data models for complicated historical perspectives • Understanding of data warehousing and decision support tools and techniques • Strong ability to multi-task with several concurrent issues and projects • Demonstrated ability to interact effectively with all levels of the organization • Strong interpersonal, written and verbal communication skills • Experience advising or mentoring staff regarding data administration, data modeling, and data mapping • Desired: Experience creating data models for BigQuery, SQL Server, Oracle and MySQL databases • Experience in Healthcare Insurance or related field strongly preferred