Indotronix UK
REMOTE Hire : Data Modeler Job at Indotronix UK in San Diego
Indotronix UK, San Diego, CA, United States
Role: Data Modeler
Location: 100% Remote (PST support is preferred)
Duration: Long Term
Start Date: Immediate
Interview: Immediate
Job Description:
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.
- 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.
- 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.
- 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.
Additional 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 discussions 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.