Enterprise Data Architect - Hybrid Azure Data Platform

Amphenol Communications Solutions; Markham; Hybrid; CAD 133,000 - 150,000; Full time

Job summary

Amphenol Communications Solutions in Markham, ON, is seeking an Enterprise Data Architect to establish a secure, scalable data foundation across ERP, MES, and enterprise systems. You will drive governance, security, and analytics across manufacturing and finance domains.

The role requires deep Azure data platform experience, Fabric skills, and strong SQL/Power BI capabilities, with hybrid work in Markham.

Qualifications

• BS in Information Systems, Computer Science, Engineering, or related field.
• 7+ years of progressive experience in data architecture, data engineering, analytics architecture, or related discipline.
• Strong experience designing enterprise data architecture.
• Strong Microsoft Azure data platform experience.
• Hands-on experience with Microsoft Fabric: OneLake, Lakehouse, Warehouse, Data Factory.
• Strong experience with Azure SQL / SQL Server and strong SQL skills.
• Strong experience with Power BI and enterprise semantic models, including DAX, RLS, and Direct Lake.
• Experience with data governance, data security, lineage, metadata, data quality.

Responsibilities

• Design scalable data architecture across ERP, MES, applications, databases, APIs, files, and manufacturing data sources.
• Establish architecture standards for Azure, Microsoft Fabric, Azure SQL, OneLake, Lakehouse, Warehouse, and related technologies.
• Develop architecture patterns supporting multiple manufacturing locations and future global expansion.
• Establish and continuously improve the Enterprise Data Governance framework, including data ownership, domains, glossaries, metadata, catalog, and lineage.
• Design enterprise data models, dimensional models, canonical models, and semantic models.
• Design and implement enterprise data security architecture including RBAC, Entra ID, and DLP.
• Develop automation capabilities using APIs, workflow automation, alerts, and monitoring.

Skills

Azure data platform

Power BI

SQL skills

Data modeling

Data governance & security

ETL/ELT & data pipelines

Automation with APIs/workflows

RBAC / Entra ID

iPaaS (Boomi/MuleSoft)

Education

BS in Information Systems, Computer Science, Engineering, Business, or related field

Tools

Microsoft Fabric

OneLake

Lakehouse

Data Factory

Azure SQL / SQL Server

Direct Lake

Job description

Amphenol Communications Solutions in Markham, ON, is seeking an Enterprise Data Architect to establish a secure, scalable data foundation across ERP, MES, and enterprise systems. You will drive governance, security, and analytics across manufacturing and finance domains.

The role requires deep Azure data platform experience, Fabric skills, and strong SQL/Power BI capabilities, with hybrid work in Markham.