| Data Modeler at Remote, Remote, USA |
| Email: [email protected] |
| From: Aditya Kumar, HMG America LLC [email protected] Reply to: [email protected] Hi my name is Aditya and I am workiing at HMG America LLC which is the best Business Solutions focused Information Technology Company with IT consulting and services, software and web development, staff augmentation and other professional services. One of our direct clients is looking for Data Modeler in USA. Below is the detailed job description. Role: Data Modeler Location: USA 100% Remote (PST support is preferred) Duration: Long Term Contract Top Skills (demonstrable experience in all required): 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/Studios OLE Automation Interface to increase efficiency, productivity, and accuracy of modeling processes. Perform light Data Analysis and Data Profiling as needed. Keywords: access management business intelligence information technology |
| [email protected] View all |
| Sat Dec 24 01:35:00 UTC 2022 |