Data Architect

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.

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.

Skills: Architectural Services, Automation, Best Practices, Business Intelligence, Change Management, Cloud Computing, Corporate Policies, Cross-Functional, Customer Relationship Management (CRM) Systems, Data Modeling, Data Quality, DataArchitect Data Modeling Tool, Database Administration, Database Design, DevOps, ERP (Enterprise Resource Planning), IBM DB2, Information/Data Security (InfoSec), Large-Scale Systems, Leadership, Maintain Compliance, Manufacturing Data Management, Master Data Management (MDM), Mentoring, Metadata, Microsoft SQL Server, Microsoft SQL Server DBA (Database Administration), Microsoft Windows Azure, Migration Strategy, Multiplatform/Cross-Platform, NoSQL, Performance Metrics, Performance Modeling, Performance Tuning/Optimization, Power BI, Reporting Dashboards, SQL (Structured Query Language), SQL Databases, Sarbanes-Oxley Act (SOX), Software Development Lifecycle (SDLC), Software Engineering, System Migration, Systems Administration/Management, Telemetry