Dataverse Data Architect

Bright Star; Washington (District of Columbia); Hybrid; USD 120,000 - 140,000; Full time

Benefits offered by this job

401(k) with company match

Health, dental, and vision insurance

Paid time off

Job summary

Bright Star in Washington, DC is recruiting an experienced Dataverse Data Architect to design, implement, and govern scalable data models and integration solutions on Microsoft Dataverse and the Power Platform for a CBP program. The role involves collaborating with program leadership, architects, developers, and reporting teams to set architecture standards, security models, and reusable patterns across Microsoft 365 and Azure.

Full-time hybrid role; U.S.

Qualifications

• Three to ten years of relevant experience in data architectures.
• Experience designing and implementing data architectures with Microsoft Dataverse.
• Proficiency with Power Platform components (Power Apps, Power Automate, Power Pages, Power BI).
• Strong knowledge of Dataverse tables, security, and environment management.
• Experience integrating Dataverse with external systems via APIs, connectors, or Azure services.
• U.S. citizenship and ability to obtain CBP BI.
• Excellent stakeholder communication and technical documentation skills.

Responsibilities

• Design, implement, and govern scalable data models and data integration on Dataverse and Power Platform.
• Develop conceptual, logical, and physical data models with Dataverse tables and relationships.
• Define architecture standards, naming conventions, and best practices.
• Design Dataverse security models, roles, teams, and row-level access.
• Develop integration architecture across Dataverse, Power Platform, Azure, and external systems.
• Support data migration, transformation, mapping, and data quality.
• Document data flows, data dictionaries, ER diagrams, and architecture decisions.
• Ensure compliance with security, privacy, and regulatory requirements.

Skills

Dataverse design

Power Platform

Azure integration

APIs & connectors

Security & governance

Stakeholder communication

Technical documentation

Education

Bachelor’s degree in IT / CS / Data Management

Tools

Dataverse

Power Platform

Power Apps

Power Automate

Power BI

Azure Data Factory

Azure Functions

REST APIs

Dynamics 365

Job description

Bright Star is a forward-thinking technology consultancy that specializes in harnessing the power of data and AI to solve complex business challenges. Our team of experts combines deep technical expertise with strategic insight to deliver innovative solutions that drive meaningful impact for our clients.

Role Description

Bright Star is recruiting an experienced Dataverse Data Architect to support a U.S. Customs and Border Protection (CBP) program. This position is full-time and is hybrid remote in Washington, DC. This role will work with program technical leadership, business stakeholders, solution architects, developers, and reporting teams to design, implement, and govern scalable data models and data integration solutions built on Microsoft Dataverse and the Power Platform. The work spans data modeling, security design, integration architecture, migration, and governance across the Microsoft 365 and Azure ecosystem.

This role offers a unique opportunity to define a federal enterprise data foundation. You will convert fragmented data currently spread across SharePoint, Excel, and Microsoft Lists into normalized, secure, reusable Dataverse models, and set the architecture standards, naming conventions, and reusable patterns that application developers and reporting teams build against.

Key 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, 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, including development, test, staging, and production environments.
• Support application lifecycle management, including managed and unmanaged solutions, publishers, versioning, deployment processes, and release management.
• Evaluate when to use Dataverse, SharePoint, SQL Server, Azure SQL, data lake, or 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 to ensure 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.

Required Qualifications

• Three to ten years of relevant experience and a Bachelor’s degree in Information Technology, Computer Science, Data Management, Engineering, or a related field.
• 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, data transformation, data 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.
• U.S. citizenship and the ability to obtain a CBP Background Investigation (BI).

Preferred Qualifications

• Experience with federal, public sector, or regulated environments.
• Microsoft Certified: Power Platform Solution Architect Expert.
• Microsoft Certified: Power Platform Functional Consultant Associate.
• Experience with Microsoft Purview or similar data cataloging and governance tools.
• Experience with CI/CD for Power Platform using Azure DevOps, GitHub Actions, or Power Platform Build Tools.
• Experience with Power Platform Center of Excellence governance models.
• Knowledge of Common Data Model and Dynamics 365 industry accelerators.

Job Type: Full-time

Pay: $120,000 – $140,000 per year

• 401(k) with company match
• Health, dental, and vision insurance
• Paid time off

Experience:

• Microsoft Dataverse and Power Platform data architecture: 3 years

Ability to Commute:

• Washington, DC (Preferred)

Ability to Relocate:

• Washington, DC: Relocate before starting work (Preferred)

Work Location:

• Hybrid remote in Washington, DC

Bright Star is an Equal Opportunity Employer.