Data Modeler

Job Title: Data Modeler

Primary skills: Data Modelling, SQL, Data warehousing, ER tools, Azure, Commercial Lines

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 modelling 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 for P&C Commercial/ Specialty line products.
• 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 with respect to P&C Commercial/ Specialty line products.

Requirements

• 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.
• Data modelling experience for P&C Commercial / Specialty line products.
• 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, analyze 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.

Good to Have:

• Experience with CI/CD pipelines.
• Strong understanding of Agile/Scrum methodologies