Data Modeler

Requirements & Scope of Responsibility

• Partners closely with data analysts and data engineers to review new source system data and evaluate alignment with the enterprise curated data model.

• Adheres to standards, patterns, and best practices for logical and physical data modeling within the enterprise ecosystem.
• Analyzes source-to-target mappings and proposes enhancements to core data entities, attributes, and relationships to ensure model extensibility and consistency across domains.
• Authors new entities and model changes in SQLDBM (or equivalent modeling tool), maintaining forward-engineering alignment with the Snowflake data warehouse.
• Oversees version control, change tracking, and documentation for all model updates, ensuring enterprise visibility and traceability.
• Participates in cross-functional design sessions with data analysts, data architects, and business stakeholders to validate model updates and ensure they meet analytical and operational use cases.
• Conducts data profiling and collaborates with engineering teams to ensure data quality, completeness, and conformance to model standards.
• Provides guidance and guardrails for integrating new data sources into curated layers, balancing flexibility for analytic needs with adherence to enterprise modeling principles.
• Works collaboratively with data governance to align model naming conventions, business term definitions, and approved entity relationships.

Explicit Non-Ownership (Out of Scope)

• Does not own business logic, KPIs, or analytic definitions (these are governed by data analysts or business partners).

• Does not execute or manage ETL/ELT pipelines beyond providing transformation logic requirements and model integration guidance.
• Does not directly own data quality operations or issue remediation; partners with data engineering or data stewardship teams for action.
• Does not act as a project manager or backlog owner for analytics or reporting deliverables.
• Does not determine business requirements or success metrics beyond providing technical feasibility and model impact assessments.