# Data Modeler — 3S Business Corporation Inc.

- Location: New York, NY
- Posted: May 19, 2015
- Status: open (checked Nov 21, 2026)
- Apply (employer's site): https://jobs.smartrecruiters.com/3sbusinesscorporationinc1/83008157
- Employer record: https://visajobs.io/company/3s-business.md

## Sponsorship history
- Tier: Employer history only
- With this exact title: 0
- Staffing / consulting firm: 82% of its H-1B applications place workers at client sites (FY2024–FY2026)

## Description
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
Qualifications
Technical Skills
• Data Modeling Tools: Erwin and ER studio
• OLAP Tools: SAP Business Objects
• ETL Tools: Microsoft SSIS and Informatica 7.1.3
• Database Tools: Microsoft SQL Server 2000/2005/2008,2012
• Packages: Microsoft Office Suite, Microsoft Project 2010, SAP Business Objects
• Operating Systems: Microsoft Windows 9x/NT/2000/XP/Vista/7 and UNIX
Additional Information
Exp. On the Service cloud or Tech Support that we need from SFDC standpoint

> History, not a promise: past H-1B filings do not mean an employer will sponsor you or a given role. Data: U.S. DOL OFLC LCA disclosure (FY2024–FY2026 for role counts, certified LCAs) and the USCIS H-1B Employer Data Hub. Not legal advice. Methodology: https://visajobs.io/methodology
