Senior Data Modeler - DW/BI & ETL Expert (Erwin/ER Studio)

3 s Business Corporation Inc.; New York (NY); On-site; USD 100,000 - 130,000; Full time

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

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.