Lead Specialist, Modeling & Arch II

Overview

Key Accountabilities

• Design and maintain logical and physical data models for analytics, integration, and reporting use cases, aligned with enterprise standards and naming conventions.
• Translate business requirements into consistent entities, attributes, and relationships; ensure definitions align with the business glossary and stewardship ownership.
• Develop dimensional models and curated layer schemas that support performant analytics and standardized KPIs.
• Define mappings and transformation rules from source systems to curated layers; ensure traceability, lineage, and reconciliation requirements are met.
• Participate in solution design reviews; identify modeling risks and recommend mitigation (data quality, master/reference data, performance, historization).
• Support data engineers with model-driven implementation guidance; validate that physical implementations align with approved designs.
• Contribute reusable templates, reference models, and design patterns to accelerate delivery and standardize outputs.
• Collaborate with governance teams to ensure metadata completeness, catalog registration, and data quality checks are embedded in delivery.

Skills

• Strong data modeling capabilities (logical/physical, dimensional) and ability to document and communicate designs clearly.
• Understanding of data quality, lineage, metadata, and governance requirements for enterprise data products.
• Ability to work across engineers, analysts, and business stakeholders to resolve definition and integration challenges.
• Experience with modeling tools and SQL; familiarity with cloud data platform design considerations.
• Strong analytical thinking and ability to troubleshoot modeling and integration defects.