SAP DW Data Modeler (3 - 16  Year Exp) New Jersey

By Publishing company

Job Summary

Experience: 3 - 16  Year(s) Salary:
Location: New Jersey Skills: SQL,OLAP/ROLAP,ERwin, Power Designer, ER/Studio or similar Education: Not Mentioned.
Job details

Job Description

The primary focus of this role is to develop Data Models for implementing Data Warehouse based on

data from SAP ECC applications that also integrates data from legacy systems. The Data Modeler is

responsible for analyzing data requirements, developing logical and physical data models for the Data

Warehouse and Data Marts. The individual in this role will translate business data requirements into

logical and physical data models, will understand and apply the concepts of proper data modeling and

database design, and utilize a strong understanding of source data to ensure the design approach results

in a logical and efficient data model to support client’s business Intelligence and analytics capabilities.

The position will also be responsible for on-going development and enhancements to the core client

EDW related to SAP datasets and partnering with the existing ETL development team around the

existing data warehouse for non-ERP related data domains (structured and semi-structured). Additional

partnership will occur between this role and the BI development and Planning System development

members in how SAP data is leveraged to provide reports, cubes, analytics and planning models to

business and technology teams.

Apply Here :

Candidate Profile



? A minimum of 5 or more years of experience in developing Data Warehouse Data Models using

Kimball Methodology in large, complex database systems (350+ tables).

? Minimum of 3 plus years of experience developing data models for Data Warehouses based on SAP

(Finance, Sales & Distribution, Project Accounting etc.)

? Highly competent with relational database design and structured query language (SQL).

? Minimum of five years’ experience with ERwin, Power Designer, ER/Studio or similar data modeling


? Solid understanding of Business Intelligence and Data Warehouse technologies (Dimensional

Modeling, Denormalization, Data Warehouse Appliances, OLAP/ROLAP, In Memory BI Technologies).

? Hands-on experience with developing meta data layer, reports and dashboards using Cognos,

Qlikview or any other BI Platforms

? Solid understanding of ETL tools (e.g., Informatica, Business Objects Data Services). Hands on

experience with these technologies a plus.

Company Profile

Company Name:
Publishing company
Contact Person:
Not Mentioned.
Phone Number:
Not Mentioned.
Mobile Number:
Not Mentioned.