Microsoft 365 Data Architect

Microsoft 365 Data ArchitectAbout Bright Star

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 Microsoft 365 Data Architect to support U.S. Customs and Border Protection (CBP). This is a full-time, hybrid position. This role will design and govern the data and information architecture underpinning a Microsoft 365 environment — defining how information is structured, classified, secured, moved, and retained across SharePoint Online, Teams, OneDrive, Exchange Online, the Power Platform, and Microsoft Purview.This role offers a unique opportunity to set architecture standards for an enterprise collaboration and records environment at a federal component agency. The work spans information architecture, governance and compliance, integration design, and analytics enablement. The Microsoft 365 Data Architectwill influence decisions that affect how users find, share, and retain mission information.

Key Responsibilities

• Design, develop, and maintain enterprise data architecture solutions across the Microsoft 365 ecosystem, including data architecture standards, governance models, metadata structures, and information management practices.
• Assess business requirements and translate them into scalable, secure, and maintainable architecture designs, including conceptual, logical, and physical data models supporting business applications, collaboration, reporting, records management, and automation.
• Establish information architecture for SharePoint Online, including site structures, content types, metadata, document libraries, lists, permissions, and lifecycle management.
• Design data structures and integration patterns across Microsoft 365 services, including SharePoint Online, Teams, OneDrive, Exchange Online, Microsoft Lists, Power Platform, and Microsoft Graph.
• Design data integration solutions using Microsoft Graph API, Power Platform connectors, Azure services, and other approved integration tools.
• Support enterprise reporting and analytics by designing data flows between Microsoft 365 and Power BI, Dataverse, Azure Data Lake, Azure SQL, or other approved data platforms.
• Define and enforce data classification, retention, archival, eDiscovery, records management, and compliance requirements within Microsoft 365.
• Design secure access models using role-based access control, group-based permissions, sensitivity labels, conditional access considerations, and least-privilege principles.
• Support Microsoft Purview implementation for data governance, information protection, data lifecycle management, audit, compliance, and discovery.
• Review existing Microsoft 365 data structures and recommend improvements for scalability, usability, security, compliance, and performance.
• Develop architecture diagrams, data flow diagrams, data dictionaries, metadata models, integration specifications, and architecture decision records.
• Support migration planning from legacy repositories, file shares, on-premises SharePoint, or other platforms into Microsoft 365.
• Support application lifecycle management and environment planning for Microsoft 365-integrated applications and Power Platform solutions.
• Collaborate with cybersecurity, privacy, records management, legal, business, and technical stakeholders to ensure data architecture aligns with organizational policies and regulatory requirements.
• Provide technical guidance to solution architects, developers, administrators, business analysts, and project teams.
• Identify risks, dependencies, constraints, and data quality issues, and recommend mitigation strategies.

Required Qualifications

• 3–10 years of relevant experience and a degree in Information Technology, Computer Science, Data Management, Engineering, or a related field, or equivalent professional experience.
• Demonstrated experience designing data architecture solutions within Microsoft 365 environments.
• Strong knowledge of Microsoft 365 services, including SharePoint Online, Microsoft Teams, OneDrive, Exchange Online, Microsoft Lists, and Microsoft Purview.
• Experience developing information architecture for SharePoint Online, including metadata, content types, site structures, document libraries, lists, and permissions.
• Experience with Microsoft Power Platform, including Power Apps, Power Automate, Power BI, and Dataverse.
• Experience designing integrations using Microsoft Graph API, REST APIs, Power Platform connectors, Azure Logic Apps, Azure Functions, Azure Data Factory, or similar tools.
• Understanding of Microsoft Purview capabilities, including data classification, sensitivity labels, retention labels, records management, audit, eDiscovery, and data lifecycle management.
• Experience designing secure access and permissions models using Microsoft Entra ID, Microsoft 365 Groups, SharePoint permissions, Teams permissions, and role-based access control.
• Knowledge of data governance, metadata management, records management, privacy, cybersecurity, and compliance practices.
• Experience supporting reporting, analytics, and data movement between Microsoft 365 and platforms such as Power BI, Azure Data Lake, Azure SQL, Dataverse, or enterprise data warehouses.
• Experience with data migration, data mapping, data cleansing, and validation from legacy systems into Microsoft 365.
• Ability to create data models, data flow diagrams, entity relationship diagrams, architecture documentation, and technical design artifacts.
• Ability to evaluate technical options and recommend fit-for-purpose data storage, collaboration, integration, and governance solutions.
• Strong analytical, problem-solving, communication, and stakeholder engagement skills, with the ability to work collaboratively across business, technical, cybersecurity, privacy, records, legal, and governance stakeholders.
• U.S. citizenship is required. Must be able to obtain and maintain a CBP Background Investigation (BI); an active CBP BI is preferred.

Preferred Qualifications

• Microsoft 365 Certified: Administrator Expert.
• Microsoft Certified: Power Platform Solution Architect Expert.
• Microsoft Certified: Azure Solutions Architect Expert.
• Microsoft Certified: Azure Data Engineer Associate.
• Experience with federal, public sector, or regulated environments.
• Experience with Microsoft Cloud for Government, GCC, GCC High, or other secure cloud environments.
• Experience with enterprise content management, records management, or knowledge management programs.
• Active CBP Background Investigation.

Job Details

Job Type: Full-time

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

Benefits:

· 401(k) with company match

· Health, dental, and vision insurance

· Paid time off

Experience:

· 3–10 years of relevant experience

Ability to Commute:

· Washington, DC (Preferred)

Ability to Relocate:

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

Work Location:

· Hybrid remote in Washington, DC

Equal Employment Opportunity

Bright Star is an Equal Opportunity Employer.

Pay: $120,000.00 - $140,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Life insurance
• Paid time off
• Vision insurance

Application Question(s):

• Are you a US citizen?
• Do you currently hold an active DHS Public Trust or CBP Background Investigation (BI)? This is a required qualification for this position.
• Do you have at least 5 years of hands-on experience with Microsoft Dataverse?
• Do you have at least 8 years of experience in data architecture, enterprise data management, Microsoft business applications, or application modernization?
• Have you served as a Technical Lead, Solution Architect, Senior SME, or Data Architecture Lead for at least 3 years?
• Do you have experience integrating Dataverse with Power Apps, Power Automate, SharePoint Online, Microsoft Lists, Excel, Teams, Outlook, and Power BI?
• Have you supported DHS, CBP, FEMA, TSA, USCIS, ICE, CISA, or another DHS component?

Work Location: Hybrid remote in Washington, DC 20004

Salary : $120,000 - $140,000