Remote Dataverse Data Architect for Government Programs

LMI Consulting, LLC

Tysons (VA)

Remote

USD 109,000 - 160,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

LMI is seeking a Dataverse Data Architect to join a multidisciplinary team supporting the Department of Homeland Security (DHS) CBP PMO. The role requires U.S. citizenship and CBP BI eligibility, with up to 20% travel.

You will design and govern scalable Dataverse data models, security, and integrations, collaborating with stakeholders to deploy mission-critical data solutions. The ideal candidate has strong experience with Dataverse, Power Platform, Azure, and data governance, and will bridge

Qualifications

3–10 years of relevant experience and a STEM BS degree.
Experience designing and implementing data architectures using Microsoft Dataverse.
Experience with Microsoft Power Platform (Power Apps, Power Automate, Power Pages, Power BI).
Strong understanding of Dataverse table design, relationships, security, business rules, and environment management.
Experience integrating Dataverse with external systems using APIs, connectors, dataflows, Azure services, or middleware.
Experience with Dataverse Web API, OData, REST APIs, and custom connectors.
Experience with Azure integration services (Logic Apps, Functions, Service Bus, Data Factory, API Management).
Experience with data migration, transformation, mapping, and data quality management.
Familiarity with Dynamics 365 data structures and extensibility.
Understanding of data governance, metadata management, data retention, auditing, and compliance.
Ability to work with business and technical stakeholders to translate requirements into scalable data architectures.
U.S. citizenship and ability to obtain a CBP Background Investigation (BI); active BI preferred.
Preferred: Microsoft Certified roles related to Power Platform or Azure; federal/public sector experience.

Responsibilities

Design, implement, and govern scalable data models and data integration solutions using Microsoft Dataverse and the Power Platform.
Develop conceptual, logical, and physical data models, including Dataverse tables, columns, relationships, rules, and fields.
Define Dataverse data architecture standards, reusable patterns, naming conventions and best practices.
Design and document Dataverse security models, including security roles and access controls.
Develop integration architecture between Dataverse, Power Platform, Microsoft 365, Dynamics 365, Azure, and external systems.
Support data migration, transformation, mapping, validation, and data quality management activities.
Design dataflows, virtual tables, APIs, connectors, and other integration mechanisms.
Support Power Platform environment strategy and lifecycle management.
Support application lifecycle management including managed/unmanaged solutions and deployment processes.
Evaluate storage options (Dataverse, SharePoint, SQL Server, Azure) based on business needs.
Support reporting and analytics using Power BI and Dataverse connectors.
Establish data governance and metadata management practices.
Collaborate with stakeholders to translate requirements into technical designs.
Review solution designs for scalability, performance, security, and maintainability.
Document data flows, access patterns, integration points, and architecture decisions.
Ensure compliance with organizational data handling, privacy, and cybersecurity requirements.