Senior Power BI Architect - Enterprise Analytics Migration

Peraton; Herndon (VA); On-site; USD 86,000 - 138,000; Full time

Job summary

Peraton is seeking a senior Power BI Data Architect to lead the migration of SAP BusinessObjects to Power BI for the DOS CS M program in Herndon, VA. The role requires strong data architecture, semantic modeling, and governance skills to deliver enterprise reporting capabilities.

You will design target-state architectures, oversee migration decisions, and collaborate with data engineers, report developers, and stakeholders to ensure secure, scalable solutions across the data landscape.

Qualifications

• Bachelor’s degree in STEM with 8+ years in BI, analytics, or data architecture.
• 7+ years of experience in BI, analytics, data architecture, or related disciplines.
• 4+ years of hands-on experience architecting enterprise Microsoft Power BI solutions.
• Advanced experience with Power BI semantic modeling, DAX, Power Query/M, and Power BI Service.
• Experience migrating or modernizing legacy enterprise BI/reporting platforms.
• U.S. Citizenship and ability to obtain/hold an Active Secret clearance; on-site in Herndon, VA 3x a week.

Responsibilities

• Review BusinessObjects reports, universes, data sources, calculations, business rules, dependencies, and security requirements.
• Develop the target-state architecture for migrating reporting and analytics to Microsoft Power BI.
• Determine which existing reports should be migrated, consolidated, redesigned, or retired.
• Design scalable Power BI semantic models and reusable enterprise datasets.
• Develop dimensional data models with appropriate fact and dimension structures.
• Identify Power BI limitations, performance risks, architecture constraints, and migration issues; propose solutions.
• Determine data transformation and business logic placement across Synapse, Power BI, and ETL components.
• Troubleshoot Power BI performance and optimize semantic models, queries, and reports.
• Work with stakeholders, data engineers, DB teams, and developers to translate requirements into a Power BI solution.
• Provide technical leadership and guidance to Power BI developers.

Skills

Power BI

Data architecture

DAX

Power Query/M

Security/governance

Communication

Education

Bachelor’s degree in STEM

Tools

SAP BusinessObjects

Microsoft Fabric / Azure data services

Job description

Peraton is seeking a senior Power BI Data Architect to lead the migration of SAP BusinessObjects to Power BI for the DOS CS M program in Herndon, VA. The role requires strong data architecture, semantic modeling, and governance skills to deliver enterprise reporting capabilities.

You will design target-state architectures, oversee migration decisions, and collaborate with data engineers, report developers, and stakeholders to ensure secure, scalable solutions across the data landscape.