Sr. Data Modeler BI
Core
Designing and implementing dimensional data models and analytical data sets for IBM DB2 databases to support business intelligence and reporting needs.
Role type
Senior Business Intelligence Data Modeler
Builds
Logical and physical data models, dimensional schemas (Star/Snowflake), and virtual semantic layers for data warehousing.
Domain
Data Warehousing, Business Intelligence, Enterprise Data Architecture
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Dimensional modeling (Star/Snowflake schemas), Advanced SQL query writing and optimization, IBM DB2 physical modeling and tuning, Ralph Kimball data modeling concepts, 3NF relational modeling, Bill Inmon data modeling concepts, BI stack architecture and configuration, MOLAP/ROLAP/HOLAP design
Preferred skills
Virtual semantic layer implementation using views on normalized ODS, creating mockup reports and storylines
Responsibilities
Develop dimensional models based on business requirements, define conformed dimensions and enterprise hierarchies, transform logical models into physical DB2 designs, map data transformations from a business terms perspective, perform data profiling and business rule investigations, support project teams in resource assessment
Seniority
Senior, hands-on IC