• US Citizen

• Green Card

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 24th Dec 2022

Logical Data Modeling
Writing & Communication
3NF / Inmon Data Warehouse architecture
Er Studio or ER Win 
Role Responsibilities

Facilitates the creation of Logical Data Models using normalized (3NF), IDEF1X, and some physical model dimensional structures (star and snowflake schemas) in OLAP and OLTP systems to support Enterprise Data Analytics and decision-making. The Data Modeler enforces architectural standards and logical modeling best practices and conducts modeling sessions with IT and business groups from all areas of the Enterprise, defining and documenting semantics, business definitions, and relationships for Enterprise data. The Data Modeler must have excellent verbal and written communication skills, demonstrable experience writing business definitions and logical models in third-normal form, a high customer service and work ethic, the ability to grasp and articulate abstract concepts quickly, and be capable of interfacing easily with both business and technical people. The Data Modeler is knowledgeable in Inmon and Kimball approaches to Data Warehouse and Data Mart architecture. Software experience: Embarcadero ER Studio or ER/Win, SQL Query tools, database platform-related query and design tools. Experience with Cloud BI Platform (such as Snowflake) preferred.

Role responsibilities

Create logical and physical data models using Embarcadero ER/Studio, employing IDEF1X specification and 3rd Normal Form for OLAP and OLTP systems.
Provide and enforce best practices and governance standards, normalization, data classification, and normalization in the delivery of high-quality data solutions for Enterprise Data Warehouse, business group focused BI platforms (Data Marts), metadata reporting applications, and OLTP systems.
Conduct modeling sessions with project teams across all business groups, gather and define data requirements for Enterprise Data Model.
Lead discussion with stakeholders designed to transform subscriber data requirements into a robust, canonical logical model and data dictionary, with clearly-written business definitions for logical entities and attributes that describe enterprise data in a way that is consumable by a wide business audience.
Enforce architectural standards and train Developers, Technical Leads, Project Managers, and Systems Analysts regarding best practices for Enterprise Data Warehouse Design.
Identify repeatable processes and develop automation macros using VBScript and Er/Studio’s OLE Automation Interface to increase efficiency, productivity, and accuracy of modeling processes.
Perform light Data Analysis and Data Profiling as needed.