Enterprise Data Architect (Azure, BI, SQL, Data Governance) at Irving TX

Hello,

Hope you are doing well.

This is Ram from ICS Global Soft. Kindly find the below job description and let me know your availability

Role: Enterprise Data Architect (Azure, BI, SQL, Data Governance)

Location: Irving TX- Day 1 Onsite

Duration: Long-term Contract

Role Overview

The Azure Data Architect is the enterprise-wide technical leader responsible for designing, governing, and operating a unified data platform across on-prem, Azure, and Microsoft Fabric. The role integrates architectural strategy with platform ownership covering post merger integration, Lakehouse design, BI platform management, DBA oversight, DevOps deployments, observability, and security.

Core Responsibilities

• Enterprise Data Architecture & Cloud Strategy
• Architect modern enterprise data platforms across On Prem, Azure, and Fabric ecosystems.
• Define architectural standards, reusable patterns, roadmaps, and modernization strategies.
• Lead scalable ingestion, storage, transformation, and modeling frameworks.
• Drive cloud adoption with a focus on resiliency, standardization, and business alignment.

Strategic Architecture & Enterprise Responsibilities

Post Merger Data Integration & Platform Consolidation

• Consolidate data environments, pipelines, and models across acquired companies.
• Integrate ERP, CRM, and operational systems into unified Lake/Lakehouse architectures.
• Establish reusable ingestion and onboarding frameworks for future acquisitions.
• Standardize canonical models and reduce duplicated or conflicting data assets.

Enterprise Lakehouse Architecture (Azure + Microsoft Fabric)

• Design and operate Lakehouse architectures following Bronze/Silver/Gold patterns.
• Govern Fabric workspaces, Lakehouses, Pipelines, and semantic models.
• Define and maintain enterprise KPI frameworks and shared semantic layers.
• Ensure strong lineage, data quality, and operational observability.

Master Data Management (MDM) & Canonical Entity Design

• Define canonical entities (Customer, Product, Vendor, Location, etc.).
• Implement pragmatic MDM-lite or hybrid models that scale without unnecessary overhead.
• Resolve identity conflicts, hierarchy mismatches, and attribute drift across systems.
• Establish metadata, stewardship roles, and entity lifecycle governance.

Data Governance, Security & Compliance

• Architect scalable governance models supporting acquisitions and enterprise growth.
• Implement domain isolation, RLS/CLS, data certification, and metadata standards.
• Ensure compliance with SOX, privacy, and corporate data security policies.
• Partner with security teams to enforce consistent controls across platforms.

Platform Ownership & Operational Leadership

(Repositioned after Strategic responsibilities for better narrative flow.)

BI Platform Administration

• Oversee Power BI, Fabric, and on prem BI platforms.
• Govern workspace hierarchy, capacity usage, semantic models, and performance.
• Ensure reliability, scalability, and governed data access.

SQL & DB2 DBA Leadership

• Provide direction to SQL Server and DB2 DBAs for performance, HA/DR, and maintenance.
• Govern schema lifecycle, environment consistency, and change management.
• Support DB2 and legacy system modernization and migration strategies.

Production Deployments & DevOps

• Govern CI/CD and deployment pipelines across On Prem, Azure, and Fabric.
• Standardize automation, approvals, versioning, rollback, and SDLC practices.
• Manage deployments for ADF, Logic Apps, Azure SQL/Synapse, Cosmos DB, and Fabric.

Observability, Monitoring & Orchestration

• Architect end to end observability using New Relic.
• Implement dashboards, telemetry, alerting, and workload reliability standards.
• Govern enterprise scheduling and orchestration using Control M.
• Drive proactive monitoring across pipelines, databases, and Fabric workloads.

Cross Functional Leadership

• Provide architectural leadership and direction across data engineering, BI, and DBA teams to ensure alignment with enterprise data strategy.
• Lead decision making on data platform patterns, governance standards, and modernization initiatives.
• Mentor technical teams and drive adoption of best practices in cloud data engineering, DevOps, and Lakehouse architecture.

Technical Qualifications

Required

• 12 15+ years in enterprise data architecture and cloud analytics.
• Expertise in data modeling, schema design, and large scale data systems.
• Advanced hands on experience with ADF, Azure SQL, Synapse, and ADLS Gen2.
• Strong SQL Server background with performance tuning expertise.
• Experience with DB2/iSeries data structures and migration.
• Familiarity with Cosmos DB/NoSQL and Databricks/PySpark.

Preferred

• Azure DevOps, CI/CD, and Infrastructure as Code (ARM/Bicep/Terraform).
• Azure Entra ID and least privilege security architecture.
• Azure cost governance and optimization.
• Strong experience with Microsoft Fabric.