Data Architect

LMI

. Design, implement, and govern scalable data models and data integration solutions using Microsoft Dataverse and the Power Platform .

Posted 10/9/2026full-timeRemote • United StatesMid-LevelSenior💰 $109,000 - $160,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and implementing scalable data architectures using Microsoft Dataverse and the Power Platform, with a strong focus on data governance, integration, and compliance. Proficient in collaborating with stakeholders to translate business requirements into effective technical solutions.

Highest-signal resume keywords

Microsoft Dataverse ArchitecturePower Platform DevelopmentData Migration and TransformationData Governance and ComplianceAPI Integration and Dataflows

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

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

Hard Skills

Data Architecture DesignDataverse Table DesignPower BI ReportingAzure Integration ServicesOData and REST APIsData Quality ManagementData MigrationTechnical DocumentationData Governance PracticesData Modeling

Soft Skills

Analytical SkillsProblem-SolvingCommunication SkillsCollaborationStakeholder Engagement

Tools & Technologies

Microsoft Power PlatformAzure Logic AppsAzure FunctionsAzure Data FactoryPower AutomatePower AppsPower PagesDataverse Web APIMicrosoft 365Dynamics 365

Certifications & Qualifications

Microsoft Certified: Power Platform Solution Architect ExpertMicrosoft Certified: Power Platform Developer AssociateMicrosoft Certified: Power Platform Functional Consultant AssociateMicrosoft Certified: Azure Solutions Architect ExpertMicrosoft Certified: Azure Data Engineer Associate

Industry Keywords

Data GovernanceComplianceFederal SectorPublic SectorData CatalogingCommon Data ModelData RetentionMetadata ManagementCybersecurityRecords Management

Tech Stack

Tools & technologies

AzureCyber SecuritySQL

About the role

Key responsibilities & impact

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, business rules, choices, lookup fields, calculated fields, and rollup fields
Define Dataverse data architecture standards, reusable patterns, naming conventions, and best practices
Design and document Dataverse security models, including business units, security roles, teams, row-level access, field-level security, auditing, and environment-level 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 to support enterprise data exchange
Support Power Platform environment strategy across development, test, staging, and production environments
Support application lifecycle management, including managed and unmanaged solutions, publishers, versioning, deployment processes, and release management
Evaluate Dataverse, SharePoint, SQL Server, Azure SQL, data lake, and other storage platforms based on business, security, performance, and scalability needs
Support reporting and analytics using Power BI, Dataverse connectors, and data export options
Establish data governance practices for data ownership, quality, retention, classification, metadata management, and access control
Collaborate with business stakeholders, solution architects, developers, security teams, privacy teams, and governance teams to translate business requirements into technical designs
Review solution designs for scalability, performance, security, compliance, and maintainability
Document data flows, access patterns, integration points, data dictionaries, entity relationship diagrams, and architecture decisions
Support compliance with organizational data handling, privacy, records management, and cybersecurity requirements
Work with DHS CBP PMO stakeholders and technical experts on research, evaluation, development, test, and evaluation activities
Travel 20%, potentially to remote and rugged areas

Requirements

What you’ll need

3-10 years’ relevant experience
STEM BS degree
Demonstrated experience designing and implementing data architectures using Microsoft Dataverse
Demonstrated experience with Microsoft Power Platform, including Power Apps, Power Automate, Power Pages, and 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 such as Azure Logic Apps, Azure Functions, Azure Service Bus, Azure Data Factory, or Azure 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 considerations
Ability to work with business and technical stakeholders to gather requirements and translate them into scalable data architecture solutions
Strong analytical, problem-solving, communication, and technical documentation skills
Ability to support enterprise-scale application development or modernization efforts
Bachelor’s degree in Information Technology, Computer Science, Data Management, Engineering, or a related field, or equivalent professional experience
U.S. citizenship
Ability to obtain a CBP Background Investigation (BI)
Preferred: Microsoft Certified: Power Platform Solution Architect Expert
Preferred: Microsoft Certified: Power Platform Developer Associate
Preferred: Microsoft Certified: Power Platform Functional Consultant Associate
Preferred: Microsoft Certified: Azure Solutions Architect Expert or Azure Data Engineer Associate
Preferred: Experience with federal, public sector, or regulated environments
Preferred: Experience with Microsoft Purview or similar data cataloging and governance tools
Preferred: Experience with CI/CD for Power Platform using Azure DevOps, GitHub Actions, or Power Platform Build Tools
Preferred: Experience with Power Platform Center of Excellence governance models
Preferred: Knowledge of Common Data Model and Dynamics 365 industry accelerators