Data Architect

This is a fully remote position, open to applicants in District of Columbia, +1 more state.

📋 Description

• Design, implement, and oversee scalable data models and data integration solutions utilizing Microsoft Dataverse and the Power Platform.

• Create conceptual, logical, and physical data models, which include Dataverse tables, columns, relationships, business rules, choices, lookup fields, calculated fields, and rollup fields.

• Establish standards for Dataverse data architecture, reusable patterns, naming conventions, and best practices.

• Develop and document security models for Dataverse, including business units, security roles, teams, row-level access, field-level security, auditing, and environment-level controls.

• Engineer integration architecture linking Dataverse, Power Platform, Microsoft 365, Dynamics 365, Azure, and external systems.

• Assist in data migration, transformation, mapping, validation, and data quality management tasks.

• Create dataflows, virtual tables, APIs, connectors, and other integration mechanisms to facilitate enterprise data exchange.

• Support the Power Platform environment strategy across development, testing, staging, and production environments.

• Aid in application lifecycle management, encompassing managed and unmanaged solutions, publishers, versioning, deployment processes, and release management.

• Assess Dataverse, SharePoint, SQL Server, Azure SQL, data lake, and other storage platforms based on business, security, performance, and scalability requirements.

• Facilitate reporting and analytics using Power BI, Dataverse connectors, and data export options.

• Implement 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 convert business needs into technical designs.

• Evaluate solution designs for scalability, performance, security, compliance, and maintainability.

• Document data flows, access patterns, integration points, data dictionaries, entity relationship diagrams, and architectural decisions.

• Ensure compliance with organizational data handling, privacy, records management, and cybersecurity standards.

• Collaborate with DHS CBP PMO stakeholders and technical experts on research, evaluation, development, testing, and assessment activities.

• Travel up to 20%, potentially to remote and rugged locations.

⛳️ Requirements

• 3-10 years of relevant experience.

• Bachelor’s degree in a STEM field.

• Proven experience in designing and implementing data architectures using Microsoft Dataverse.

• Demonstrated expertise with Microsoft Power Platform, including Power Apps, Power Automate, Power Pages, and Power BI.

• Strong knowledge of Dataverse table design, relationships, security, business rules, and environment management.

• Experience integrating Dataverse with external systems through APIs, connectors, dataflows, Azure services, or middleware.

• Familiarity with Dataverse Web API, OData, REST APIs, and custom connectors.

• Background with Azure integration services such as Azure Logic Apps, Azure Functions, Azure Service Bus, Azure Data Factory, or Azure API Management.

• Experience in data migration, transformation, mapping, and data quality management.

• Understanding of Dynamics 365 data structures and extensibility.

• Knowledge of data governance, metadata management, data retention, auditing, and compliance issues.

• Ability to collaborate with both business and technical stakeholders to gather requirements and translate them into scalable data architecture solutions.

• Strong analytical, problem-solving, communication, and technical documentation abilities.

• Capacity to support enterprise-scale application development or modernization initiatives.

• U.S. citizenship is required.

• 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 in 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: Familiarity with Power Platform Center of Excellence governance models.

• Preferred: Knowledge of Common Data Model and Dynamics 365 industry accelerators.

🏝️ Benefits

• Competitive salary and performance-based bonuses.

• Comprehensive health, dental, and vision insurance plans.

• Retirement savings plan with company match.

• Opportunities for professional development and certifications.

• Flexible work schedules and remote work options.

• Generous paid time off and holidays.

• Dynamic and inclusive work environment.