Data Modeler

Job description

Must Have Technical/Functional Skills Data Modeler responsible for designing and maintaining enterprise data models and semantic structures that enable consistent, scalable, and governed analytics across SMBC’s transformation program. This role ensures that product KPIs, value stream metrics, and business data entities are modeled accurately to support Power BI, AI/ML, and enterprise reporting ecosystems.

Must Have skills

. Enterprise Data Modeling & Design

• Design conceptual, logical, and physical data models aligned to transformation needs
• Define enterprise data domains, entities, relationships, and hierarchies
• Ensure alignment with product/value stream-based operating model________________________________________ 2.

KPI & Semantic Model Alignment

• Translate business requirements into data models supporting KPIs and metrics
• Align models with standardized metric definitions and reporting logic
• Support semantic layer design used by Power BI and analytics tools ________________________________________ 3.

Data Integration & Platform Alignment

• Design models for integration with:
• Enterprise data warehouses (SQL / cloud platforms)
• Analytical data layers
• Collaborate with Data Engineers to:
• Ensure data availability, consistency, and transformation logic
• Support ingestion, transformation, and consumption layers ________________________________________ 4. Data Standardization & Governance

Define and enforce

• Standardized data definitions and naming conventions
• Data lineage and traceability across systems
• Ensure alignment with enterprise governance and control frameworks
• Maintain single version of truth for reporting datasets ________________________________________ 5.

Performance & Optimization

• Optimize data models for:
• Reporting performance (Power BI / dashboards)
• Query efficiency and scalability
• Support efficient use of:
• Aggregations, partitions, and indexing strategies ________________________________________ 6. Collaboration with Business & Analytics Teams
• Work with:
• Business/Product teams for KPI definitions o BI teams for reporting requirements
• Data Science teams for model-ready datasets
• Convert business requirements into scalable data structures Salary Range: $105,000 to $120,000 per year </div

Qualifications

BACHELOR OF COMPUTER SCIENCE