Azure Data Architect (Data Lake & SharePoint Modernization)

Job TItle : Azure Data Architect (Data Lake & SharePoint Modernization)

Location: Newport Beach, CA (hybrid)

Position : Contract

Job Describtion:

Design the end-to-end Azure data architecture, including ingestion, storage, transformation, serving, and governance layers.

Define a medallion (Bronze/Silver/Gold) lakehouse structure on Azure Data Lake Storage Gen2.

Produce architecture diagrams, standards, naming conventions, and technical documentation.

Evaluate and recommend the right mix of Azure services (and Fabric, where it fits) based on workload, scale, and cost.

Progress SQL to Azure Migration & Ingestion

Build reliable pipelines that extract data from Progress OpenEdge using ODBC/JDBC via Azure Data Factory with a Self-Hosted Integration Runtime.

Implement full and incremental (delta/CDC-style) loading patterns, handling the quirks of legacy schemas and data types.

Profile, cleanse, and validate source data, and establish data quality checks and reconciliation.

Plan the migration in phases so existing operations and reporting aren't disrupted.

SharePoint Online for File Storage & Data Maintenance

Design a SharePoint information architecture (sites, libraries, content types, metadata, and permissions) for document storage and business-maintained reference data.

Integrate SharePoint lists and libraries with the data lake so business users can maintain master or reference data that flows into analytics.

Automate file intake, approvals, and data movement using Power Automate and/or ADF.

Configure versioning limits and retention settings within SharePoint to keep libraries organized and storage under control.

Advise on what belongs in SharePoint versus ADLS so storage stays cost-effective and fit for purpose.

Required Qualifications:

Experience: 10+ years in data engineering/architecture, including 5+ years on Azure

• Strong, proven experience in Azure data architecture: ADLS Gen2, Azure Data Factory, Azure Synapse Analytics and/or Azure Databricks, Azure SQL.

Experience designing lakehouse/medallion architectures and dimensional data models (star schema).

Hands-on experience extracting data from Progress OpenEdge or similar legacy relational databases via ODBC/JDBC and Self-Hosted IR.

Advanced SQL, plus Python or PySpark for data transformation.

Working knowledge of SharePoint Online architecture, metadata, permissions, and integration with Azure (Graph API, Power Automate, ADF connectors).

Demonstrated cost-optimization track record on Azure (storage tiers, lifecycle policies, compute right-sizing, cost monitoring).

Azure security fundamentals: Entra ID, RBAC, managed identities, Key Vault, networking/private endpoints.

Experience with CI/CD and Infrastructure as Code.

Excellent communication skills and the ability to explain technical trade-offs to non-technical stakeholders.

Preferred Certifications

Microsoft Certified: Azure Solutions Architect Expert (AZ-305)

Microsoft Certified: Fabric Data Engineer Associate (DP-700)

Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)

Holders of the retired Azure Data Engineer Associate (DP-203) are also welcome.