Data Architect Analyst

Job Summary

Design, govern, and enable high-quality enterprise data model that support enterprise reporting, analytics, and AI-driven use cases leveraging the Data Vault 2.0 modeling methodology. This role bridges business requirements and technical implementation, ensuring data is structured, trusted, reusable, and aligned to enterprise architecture standards, primarily within Microsoft Fabric and the enterprise analytics ecosystem. 

Key Responsibilities

• Design, maintain, develop and execute conceptual, logical, and physical data models for BI and analytics. 
• Strong working knowledge of modern data and analytics architectures and hands on implementation experience 
• Define and enforce semantic modeling standards and metric definitions 
• Partner with Data Engineering to align lakehouse and warehouse architectures 
• Enable self-service and managed BI through reusable semantic models 
• Translate business requirements into scalable data structures 
• Support Microsoft Fabric adoption and analytics architecture patterns 
• Establish data modeling patterns, naming standards, and guidelines 
• Contribute to data governance, quality, lineage, and metadata initiatives 
• Support AI and advanced analytics readiness                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             Scope & Impact 
• Improves data trust, consistency, and usability for decision-making 
• Influences analytics design across all enterprise domains 
• Reduces duplication and inconsistencies across reports and data products 
• Supports enterprise analytics modernization initiatives 

Management Responsibilities

Preferred Qualifications

Required Qualifications 

• Demonstrated experience designing and maintaining enterprise‑scale conceptual, logical, and physical data models that support reporting, analytics, and AI use cases.  
• Strong expertise in dimensional and analytical data modeling, including defining canonical business entities, shared metrics, and reusable semantic layers.  
• Proven ability to translate business requirements into scalable, governed data structures, balancing flexibility, performance, and long‑term maintainability.  
• Solid understanding of modern analytics architectures, including lakehouse, warehouse, and medallion patterns, and how data models align to each layer.  
• Working knowledge of data governance, data quality, lineage, and metadata practices, and how these are embedded into model design rather than retrofitted 

Preferred Skills 

• Experience modeling data in Microsoft Fabric, including alignment with OneLake, Lakehouse/Warehouse, and Power BI semantic models. 
• Hands‑on experience with Data Vault 2.0 as an integration and history‑preserving modeling approach, paired with dimensional models for analytics consumption. Word
• Experience defining and enforcing enterprise data modeling standards, naming conventions, and design guidelines across multiple domains.  
• Familiarity with AI‑ and ML‑ready data design, ensuring data models can support feature reuse, advanced analytics, and future AI workloads. 
• Experience working in a governed self‑service analytics environment, enabling reuse while maintaining consistency and trust 

Minimum Qualifications

Certifications

Work Environment/Physical Demands

Competencies

Salary Plan

Job Grade