The Lead Azure Data Engineer is responsible for migration, governance, and data integration for the implementation of new Microsoft Cloud based document routing and task management system.
They will ensure alignment with the technical, security, and document management requirements such as leading data discovery and mapping, validating metadata standards, managing data migration into Dataverse and SharePoint Online, and ensuring proper implementation of retention, auditability, and role-based access controls within the Microsoft SaaS architecture.

Requirements

A minimum of 6 years IT experience with focus on data integration and data migration using Azure Data Services
Must have strong experience designing data models, configuring Dataverse tables, managing relationships, enforcing row- and field-level security, and supporting workflow-driven data structures.
Knowledge of SharePoint Online document libraries, metadata schemas, retention labels, records management, and large-volume document storage design.
Proficiency in data mapping, transformation, validation, and migration using APIs, Azure services, Power Automate, and REST-based integrations.
Experience with Azure data services (e.g., Azure Data Factory, Azure SQL, Azure AI Search, Azure storage components) in FedRAMP-aligned environments.
Understanding of producing audit logging, identity integration (Entra ID), and support for records retention and legal hold requirements.
Ability to structure data for Power BI dashboards, performance reporting, and AI-enabled search and discovery.
Establishing metadata standards, validation rules, lifecycle controls, and ensuring data accuracy and consistency across enterprise workflows.
Bachelors degree or equivalent
Must be a US Citizen

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data integrationdata migrationdata modelingmetadata standardsdata mappingdata transformationdata validationAzure Data ServicesPower BIREST-based integrations