Senior Data ModelerInterview: Video Visa: USC, GC, GC EAD, H4, L2 This is hybrid from day-1 (Local candidates highly preferred)About the job: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 MethodologyLogical and Physical data modelingLevels of NormalizationAbstraction and GeneralizationSubtyping and ClassificationRelational model designDimensional model design (Star Schemas, Snowflake designs)Inmon & Kimball methodologiesMaster Data Management (MDM)Data ProfilingMetadata ManagementData security and protecting informationETL processes, BI processesCloud Platforms, especially Google Cloud PlatformRequirements:7+ years of proven experience in Data Modeling5+ years of experience with advanced SQL query techniquesHighly skilled in Erwin, including but not limited to: Diagraming, Complete Compare, Reverse Engineering, Forward EngineeringStrong multi-tasking capability, with adaptability to work simultaneously in multiple environments with differing procedures, SME support and level of accountabilityAbility to estimate scope of effort, to prioritize and/or fast track requirements, and to provide multiple options for data-driven solution designDemonstrated ability to recognize, elicit and/or decompose complex business requirementsDemonstrated ability to perceive patterns and relationships in dataDemonstrated ability to design models which integrate data from disparate sourcesDemonstrated ability to design data models for complex and ragged hierarchiesDemonstrated ability to design data models for complicated historical perspectivesUnderstanding of data warehousing and decision support tools and techniquesStrong ability to multi-task with several concurrent issues and projectsDemonstrated ability to interact effectively with all levels of the organizationStrong interpersonal, written and verbal communication skillsExperience advising or mentoring staff regarding data administration, data modeling, and data mappingDesired Experience:Creating data models for BigQuery, SQL Server, Oracle and MySQL databasesExperience in Healthcare Insurance or related field strongly preferred