Data Warehouse Data Modeler — Star Schema Expert

Ask IT consulting; San Antonio (TX); On-site; USD 120,000 - 160,000; Full time

Job summary

Ask IT consulting seeks an experienced data warehousing specialist to design data models and lead DW/BI project implementations in a dynamic environment. You will contribute to data modeling, warehousing architecture, and profiling activities, collaborating with BI teams on complex data solutions.

The role requires hands-on expertise with star schemas, data marts, ERwin, and major RDBMS platforms, with a focus on data quality and scalable design practices in the U.S. market.

Qualifications

• Experience with Data Mart star schema structures and normalized warehouse designs.
• Strong understanding of data warehousing concepts and design principles.
• Proven solo contributor in complex DW/BI implementations.
• Experience with ERwin for data modeling.
• Knowledge of RDBMS such as Netezza, UDB/DB2 or Teradata.
• Experience with data profiling tools like IBM InfoSphere Information Analyzer.
• Bank domain knowledge is a plus.

Skills

Data models

Data marts

Star schema

Data warehouse design

Data warehousing concepts

ERwin

SQL

RDBMS

Netezza

UDB/DB2

Teradata

Data profiling

IBM InfoSphere Information Analyzer

Bank domain knowledge

Tools

ERwin

IBM InfoSphere Information Analyzer

Netezza

UDB/DB2

Teradata

Job description

Required Skills – PLEASE INDICATE YEARS OF EXP BY EACH · Data Models – Experienced in Data Mart (Star Shema Structures) and Warehouse Data Model designs (Normalized) · Strong understanding of Data warehousing design concepts/skills Strong individual contributor in complex Data Warehousing and Business Intelligence project implementations · ERwin tool · SQL ; In depth architectural understanding of RDBMS like Netezza, UDB/DB2 or Teradata. Data Profiling and discovery tools such as IBM InfoSphere Information Analyzer. Bank Domain Knowledge.

Additional Information

All your information will be kept confidential according to EEO guidelines.

By clicking the link above or any third-party link within this posting, you are leaving this site and going to a third-party website where the third-party website's terms and privacy policy apply