Database Architect (Data Modeler)

Requirements:
84 months of experience writing complex SQL for queries, stored procedures/triggers/functions in DB2/Oracle for data extraction and data integration purposes in multi-terabyte database.
84 months of experience in gathering reporting and analysis requirements and translating them into reporting structure data models, including aggregate tables, pivoted tables, and relational and dimensional (star-schema) marts.
84 months of experience with data modeling, including logical, conceptual, and physical modeling of data warehouse projects and data warehouse loading techniques (Change Data Capture (CDC) and Slowly Changing Dimensions).
84 months of experience with various reporting tools, including COGNOS.