Senior Data Modeler

Key Skills

Azure, Cloud computing, Data Architecture, Data Modeling, Database, SQL

Job Description

Tiger Analytics is a fast-growing advanced analytics consulting firm. We are the trusted analytics partner for multiple Fortune 500 companies and have been recognized as a leader by various market research firms including Forrester and Gartner. 2020 marked the third consecutive year Tiger Analytics was on the Inc. 5000 list of fastest-growing companies in the U.S. Our consultants bring deep expertise in Data Science, Machine Learning and AI and we maintain one of the best Glassdoor ratings among our peers.

The Senior Data Architect/Data Modeler role will be responsible for the design, development and maintenance of data models and standards for Enterprise data platforms. As a data architect and data modeler, the candidate should have insurance domain expertise, understand IT Platforms, and be able to provide data solutions that help solve their challenges and data needs.

Responsibilities

• Translate business requirements into working logical and physical Service Layer Data models.
• Create and maintain Logical Data Model (LDM) and Physical Data Model (PDM) for the project.
• Create and maintain the Source to Target Data Mapping document for this project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Gather and Publish Data Dictionaries: Maintain data models and capture data models from existing databases and record descriptive information.
• Identify business needs, organize and define data, create and maintain Conceptual, Logical and Physical data models; Maintain appropriate Version Control on data models.
• Participate in the de-normalization of the data model, ensuring that business rules which are impacted during de-normalization are implemented via an alternate mechanism (i.e. trigger, application code).
• Closely work with the App Dev team and DBA to create an appropriate Conceptual, Logical and Physical Data Model.
• Present data designs and project approaches to the DRB for review and approval and ensure all DRB artifacts are created.
• Generate DDL and validate that the DDL is implemented properly.
• Identify opportunities to reuse data and reduce redundancy in data across the enterprise.

Requirements

• Data Modeling
• Database Platforms / Languages
• Cloud knowledge (Azure preferred)
• SQL development a plus

Benefits

This position offers an excellent opportunity for significant career development in a fast-growing and challenging entrepreneurial environment with a high degree of individual responsibility.