Data Modeler

3 s Business Corporation Inc.

New York (NY)

On-site

USD 100,000 - 130,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

A specialized software and consulting services provider in New York is seeking an experienced IT professional with over 10 years of expertise in Data Modeling and Data Warehousing. The ideal candidate will have strong skills in tools such as Erwin and Microsoft SSIS, along with exceptional communication abilities. This role involves facilitating data requirement meetings, developing mapping spreadsheets for ETL, and implementing data management practices critical to success in various projects.

Qualifications

10+ years in Information Technology with expertise in Data modeling and Data Warehousing.
Experience in various projects related to Data Modeling and System/Data Analysis.
Good understanding of views, Synonyms, Indexes, Joins, and Partitioning.

Responsibilities

Facilitate data requirement meetings and resolve conflicts.
Implement Slowly Changing Dimensions in Dimension tables.
Develop mapping spreadsheets for ETL team.

Skills

Data Modeling

Data Warehousing

ETL

SQL

Data Analysis

Communication

Tools

Erwin

Microsoft SSIS

Informatica

Job description

3S Business Corporation is a specialized Software & Consulting Services Provider based in Houston, TX, which helps clients plan, implement and maintain their technology investments cost effectively while improving the business performance. 3S Business Corporation’s customers find it to be nimble, responsive and committed not only to project & services success, but to constantly delivering customer value. We work with fortune 500 companies, several prime vendors and provide placements to our candidates with these companies. We are a primary supplier to direct clients and major SAP implementation partners.3S Business Corporation partnership and alliances with global leaders helps to work on the latest technologies to provide business efficiencies for customers and partners

Job Description

10+ years in Information Technology with Expertise in Data modeling for Data Warehouse/Data Mart development, Data Warehousing (OLAP)/Business Intelligence (BI) applications and Data Analysis for Online Transaction Processing (OLTP).
Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.
Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star‑Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.
Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers.
Good understanding of views, Synonyms, Indexes, Joins and Partitioning.
Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft SSIS and Informatica.
Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.
Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, data types, volumetric, domain definitions, and corporate meta‑data definitions.
Exceptional communication and presentation skills and established track record of client interactions.