Locals or Nearby Urgent Need SR DATA Modeler BI
Core
Designing and implementing dimensional data models and analytical datasets for business intelligence platforms.
Role type
Senior Data Modeler (BI)
Builds
Dimensional models, logical and physical data designs, and BI stack components.
Domain
Data Warehousing and Business Intelligence
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, 3NF relational modeling, BI application architecture and development, Data profiling and business rules investigation, Conformed dimensions and enterprise hierarchy design, Virtual semantic layer implementation.
Preferred skills
Experience with MOLAP, ROLAP, and HOLAP, Creating mockup reports and storylines.
Technologies
IBM DB2, SQL, Star Schema, Snowflake Schema, 3NF, BI Stack components.
Responsibilities
Develop dimensional models based on business requirements, Transform logical data models into physical data design, Engage with stakeholders to understand data access paths, Perform data profiling and business rules investigations, Map and document data transformations, Support project delivery teams in assessing resource needs.
Seniority
Senior, hands-on IC