Delivering practical solutions to solve complex challenges with an eye on maximizing customers' current IT investments
Lead Microsoft Data Engineer
Location
United States
Posted
3 days ago
Salary
$135K - $160K / year
Job Description
Role Description
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
- Ensuring proper implementation of retention, auditability, and role-based access controls within the Microsoft SaaS architecture
Qualifications
- 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
Requirements
- Microsoft Azure data services certifications
- Active Federal Government Public Trust clearance
Benefits
The projected compensation range for this position is $135K - $160K annualized (USD). The final salary offered will generally fall within this range and is determined by various factors, including but not limited to the individual's particular combination of education, knowledge, skills, competencies, and experience, as well as internal pay equity, location, contract-specific affordability and other organizational requirements.
Job 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
- Microsoft Azure data services certifications
- Active Federal Government Public Trust clearance
Benefits
- The projected compensation range for this position is $135K - $160K annualized (USD). The final salary offered will generally fall within this range and is determined by various factors, including but not limited to the individual's particular combination of education, knowledge, skills, competencies, and experience, as well as internal pay equity, location, contract-specific affordability and other organizational requirements.
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
Senior Data Engineer supporting data platform initiatives in healthcare.
Data Engineer / Data Scientist supporting advanced analytics and operational workflows at Ares Enterprise
Staff Data Engineer at Penn Mutual designing enterprise data platforms and pipelines
Senior Data Engineer
CareforthFounded in Boston, Careforth's caregiver programs and services improve health outcomes, keeping care at home longer. Additionally, our programs provide financial benefit to caregivers and cost savings to state agencies and health plans. At Careforth, we understand the challenges of caregiving and are committed to supporting family caregivers at every turn. Caregivers play a critical role in the future of healthcare—and so can you.
This role involves architecting and building robust, scalable, and secure data pipelines utilizing Databricks, Apache Spark, and various AWS Cloud services. The individual will also collaborate cross-functionally, conduct code reviews, and mentor junior engineers to enforce engineering excellence.