Data Architect, Modeler

This is a fully remote position, open to applicants in United States.

📋 Description

• Create and implement enterprise data models for business intelligence, analytics, and operational reporting.

• Establish and enforce data-modeling best practices within a lakehouse setting.

• Design efficient, scalable, and governed data architectures utilizing Star Schema, Snowflake Schema, and Data Vault methodologies.

• Collaborate with business stakeholders to identify reporting, analytical, and operational data requirements.

• Partner with Data Engineers to convert logical models into optimized physical models using Microsoft Fabric and Delta Lake.

• Develop frameworks for data governance that encompass metadata management, data lineage, and data quality.

• Define and uphold canonical data models for essential business areas.

• Direct ETL/ELT approaches to ensure data integrity and performance in Fabric's Medallion Architecture.

• Set and document data-modeling standards across engineering teams.

• Evaluate and enhance existing data models.

• Provide guidance on data-modeling tools and data-management solutions.

⛳️ Requirements

• 7+ years of experience in data architecture, data modeling, or database design.

• Proficient data-modeling abilities; focused on Data Modeling.

• Expertise in dimensional (Star/Snowflake), relational, and Data Vault modeling techniques.

• Thorough understanding of relational and non-relational databases, including SQL, NoSQL, and Delta Lake architecture.

• Strong familiarity with Microsoft Fabric, Delta Lake, and Medallion Architecture.

• Proven experience in designing models for enterprise analytics, reporting, and operational scenarios.

• Strong SQL skills for modeling, query optimization, and data analysis.

• Practical experience with ETL/ELT processes and integration strategies.

• Knowledge of cloud data architectures, preferably Azure technologies such as Azure Data Lake, Synapse, and Databricks.

• Excellent analytical and problem-solving capabilities.

• Exceptional communication and stakeholder management skills.

• Preferred: Experience in Data Vault implementation; familiarity with tools like Alation, Collibra, Ataccama, or Atlan; KQL; Graph Data Modeling; Cosmos DB; machine-learning feature stores; and BI tools such as Power BI and Tableau.

🏝️ Benefits

• Competitive compensation.

• Comprehensive benefits package.

• Opportunities for professional advancement.

• Work with leading-edge data technologies in a Microsoft Fabric environment.

• Engage directly with business leaders.

• Be part of an innovative, high-impact team.