Lead Application & Data Architect

Position Summary We are seeking an experienced Data Architect to define, govern, and evolve the enterprise data architecture that supports analytics, reporting, operational intelligence, artificial intelligence, and emerging data-driven business capabilities. This role provides architectural leadership across Microsoft Fabric, One Lake, Data Warehouses, Lake houses, Azure Data Factory, Fabric Data Factory, SQL Server, and enterprise integration platforms. Our engineering organization has adopted Specification-Driven Development (SDD) as a core delivery discipline, and AI is a strategic priority.

Position Purpose Define enterprise data architecture strategy, design scalable and governable platforms, establish standards and best practices, provide architectural leadership for Microsoft Fabric adoption, support modernization initiatives, and enable AI-ready data foundations.

Key Responsibilities Develop and maintain the enterprise data architecture roadmap.

Establish target-state architectures for analytics, reporting, AI, and operational workloads.

Lead Microsoft Fabric architecture and governance including One Lake, Lakehouse, Data Warehouse, Fabric Data Factory, semantic models, and security.

Define standards for dimensional modeling, Data Vault, fact and dimension design, and slowly changing dimensions.

Establish ETL/ELT architecture standards across Azure Data Factory, Fabric Data Factory, SSIS, and Pentaho.

Create governance frameworks for data quality, lineage, metadata, security, privacy, and compliance.

Define AI-ready data architecture patterns and support AI, machine learning, and generative AI initiatives.

Conduct architecture reviews, mentor engineers, and establish reference architectures.

Promote Specification-Driven Development and architecture-first practices.

Required Qualifications Bachelor degree in Computer Science, Information Systems, Engineering, Mathematics, or related field.
8+ years of experience in data architecture, data engineering, data warehousing, or analytics.
3+ years in a senior architecture or technical leadership role.

Experience designing enterprise-scale cloud data platforms and modernization initiatives.

Required Technical Skills Microsoft Fabric Azure Data Factory Fabric Data FactorySQL Server Azure Data Lake Storage One Lake Enterprise  Data Architecture Dimensional Modeling Data VaultETL/ELT ArchitectureCDCData Governance Metadata Management Advanced SQL and T-SQL Preferred Qualifications Azure Synapse Analytics Spark and Py Spark Power  BIInfrastructure as CodeCI/CD for data platforms AI and machine learning platform experience

Enterprise architecture governance experience

Specification-Driven Development experience

Legacy Platform Experience (Beneficial)
Qlik Replicate Qlik ComposeSSISPentaho Data Integration Legacy data warehouse modernization

Hybrid cloud and on-premises architectures

Knowledge & Competencies Enterprise architecture principles

Data platform modernization

Data products and data mesh concepts

Lakehouse architectures

Hybrid cloud architectures

Strong stakeholder management and communication skills

Strategic technology planning and roadmap development

Success Criteria Define and execute enterprise data architecture strategy.

Establish Microsoft Fabric as the strategic analytics platform.

Create reusable architecture patterns.

Improve enterprise data quality, governance, security, and reliability.

Standardize warehousing, ETL/ELT, and analytics architecture practices.

Enable scalable AI and advanced analytics solutions.

Deliver architecture standards through disciplined SDD practices.

Lead modernization from legacy environments to Microsoft Fabric.

Work on a team leading in the adoption of Microsoft Fabric and AI-enabled data engineering capabilities.

Preferred…