Job Description :
Job Title: Data Modeler
Location: San Jose,CA
Duration: Full Time.
Salary: DOE
Job Description:
Tools & Technologies
ER/Studio , VB scripting, Snowflake, Teradata , SQL
Job 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, quality data solutions for Enterprise Data Warehouse.
· 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(SDR) into a logical model with clearly-written business definitions for logical entities & attributes 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, Data Profiling using SQL queries on the metadata as needed.