Senior Data Modeler

Senior Data Modeler Philadelphia PA Hybrid 2-3 days a week.

• 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

Key Skills

Atl,CMMS,ABAP,Community Support,CRM,Fleet

Employment Type : Full Time

Experience : years

Vacancy : 1