Sr. Data Modeler
Location : New Jersey - Day 1 Onsite
Long Term
Must have : Primary skills: P&C Insurance (Property and Casualty), Data Modelling, SQL, Data warehousing, ER tools
About the job
We are seeking a highly skilled Senior Data Modeller with expertise in Azure Services to play a pivotal role in designing and developing data solutions within our organization. The Data Modeler position works with the data management and data architecture teams to define design choices within databases. The Data Modeler will have responsibility to model data for relational and/or dimensional models depending on the context of the project assigned. This role needs to be proficient in data Modeling and query analysis, and SQL.
Responsibilities
· Design and implement data modeling solutions using relational and/or dimensional databases based on need.
· Work closely with Data Architects to design databases or data warehouses using a mixture of conceptual, logical and physical data models.
· Assist with the development and maturing of data modeling standards, guidelines, processes, and procedure.
· Conduct evaluations of existing project data systems, including constructing as-is data models (reverse engineer) and identifying foundational data model. Make recommendations for how data should be modeled based on the results of completed evaluations.
· Lead offshore team with source to target mappings based on data model design.
· Maintain basic understanding of all ACORD standards and responsible for engineering DDL.
· Strong Data Modeling experience using ER diagrams, using tools like Erwin.
· Strong proficiency and experience in Data modeling (Conceptual, Logical, Physical, 3nF, Dimensional) at enterprise level.
· Gathering and translating business requirements into technical designs and development of the physical aspects of a specified design.
· Experience in Database Design, Normalization, Conceptual, Logical and Physical data modeling using Erwin.
· Collaborate with Information Architecture and Business Analysis teams in the formulation of requirements for data across all product lines
· Have strong analytical skills with the ability to collect, organize, analyse and collect amounts of information with attention to detail and accuracy.
· Understand Business reporting data needs (Aggregated & Hierarchical data & etc …) and support reporting team needs.
· Review with Data architect, DBA to align on physical design
· Make sure Data Model changes are designed as per the Enterprise Data Standard with appropriate Naming standards.
· Effective communication and collaboration skills, with the ability to effectively interact with stakeholders at all levels.
...Business has changed - and so should consulting. We are strategists, technologists, engineers, and designers who bridge the gap between... ...the Year. What You'll Do Ignyte is looking for AppianTechnology Consultantsto join our team and helpbuild a new type of consulting...
...Vesta is seeking talented Junior Designers / Project Managers to join our growing team in San Francisco, Los Angeles and NYC. This is... ...schedules, and design documentation. Assist in selecting furniture, lighting, fabrics, and accessories that align with the project...
...party vendor for contingent work. Location: Morris Plains, NJ Summary: Provides advanced professional input to complex Business Analytics assignments/projects. Works in collaboration with business partners to provide analyses and reports to aide decision...
...unmatched opportunities to harness your expertise. With each unique school and student, we stand united in our mission to make a lasting... ...education together. Join us today. Position Details:School Nurse, RN/LPN Title: School Nurse, RN/LPN Location:...
...Operations**Job Description Summary:**Position Summary:Promotes a safe environment by coordinating with local, state and regional safety groups and agencies. Identifies safety and health concerns by surveying the operation, investigates violations and recommends...