Lead Specialist, Modeling & Arch II

Job Description

Job Purpose

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.

Minimum Qualification

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or related discipline.

Minimum Experience

• 8–12 years of experience in data modeling and solution architecture within enterprise analytics environments.
• Hands-on experience delivering models for modern cloud data platforms and supporting implementation throughout production.

Maaden High Performance Competencies

• Ownership & Accountability – Takes end-to-end ownership for delivery and outcomes.
• Collaboration – Works effectively across engineering, governance, and business teams.
• Execution Excellence – Delivers robust solutions with strong quality and reliability.
• Continuous Improvement – Improves performance, cost, and operability over time.
• Impact & Influence – Guides teams and vendors through technical leadership.

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.