Data Architect

🔥 12 hours ago

🏛️ District of Columbia, Washington – Remote

🏛️ District of Columbia – Remote ☕ Washington – Remote

💵 $109k - $160k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

🚰 Data Engineer

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

👻 Ghost score 0%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

LMI

WebsiteLinkedInAll Job Openings

1001 - 5000 employees

Founded 1961

📦 Logistics

🏥 Healthcare

🎖️ Defense

Logistics • Healthcare • Defense

LMI is a forward-thinking company that focuses on reimagining the path from insight to outcome through innovative solutions in various sectors, including applied AI and digital health. They provide advanced analytics, engineering support, and performance optimization across defense, health, and civilian markets, with a strong commitment to enhancing mission effectiveness for government clients. With a focus on collaboration and research, LMI aims to drive positive change through its diverse capabilities and partnerships.

📋 Description

• 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

• 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