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.