Purpose of the Job
A Data Modeler will facilitate the creation of Logical Data Models using normalized (3NF), and some Physical Model dimensional structures to support Enterprise Data Analytics and decision-making. The Data Modeler enforces architectural standards and logical modeling best practices by conducting modeling sessions with IT and business groups from all areas of the Enterprise, defining and documenting business definitions and relationships for Enterprise data.
Duties And Responsibilities
1. Create Logical and Physical data models using Embarcadero ER/Studio, employing IDEF1X specification and 3rd Normal Form for OLAP and OLTP systems.
2. Provide and enforce best practices and governance standards, normalization, data classification, quality data solutions for Enterprise Data Warehouse.
3. Conduct modeling sessions with project teams across all business groups, gather and define data requirements for Enterprise Data Model.
4. Lead discussion with stakeholders designed to transform Subscriber Data Requirements(SDR) into a logical model with clearly-written business definitions for logical entities and attributes data in a way that is consumable by a wide business audience.
5. Enforce architectural standards and train Developers, Technical Leads, Project Managers, and Systems Analysts regarding best practices for Enterprise Data Warehouse Design.
6. Perform light Data Analysis, Data Profiling using SQL queries on the metadata as needed.
Education
Bachelor's degree from a recognized university.
Experience.
- 4 - 6 Years Experience In data modeling , statistical analysis, data manipulation.
Skills And Abilities
- Working knowledge ER/Studio , Teradata , SQL.
- Experience writing business definitions and logical models in third-normal form
- Ability to grasp concepts quickly.
- knowledgeable in Inmon and Kimball approaches to Data Warehouse and Data Mart architecture
