Power BI Data Architect

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 Overview

Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world's leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains: land, sea, space, air, and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces. Each day, our employees do the can't be done by solving the most daunting challenges facing our customers. Visit peraton.com to learn how we're keeping people around the world safe and secure.

Responsibilities

Peraton is seeking a senior-level Power BI Data Architect to lead the architecture and technical design for the migration of an existing SAP BusinessObjects reporting environment, backed by SAP HANA, to Microsoft Power BI. This position is located in Herndon, VA. The qualified applicant will become part of Peraton's Department of State (DOS) Consular Systems Modernization (CSM) Program, for the Bureau of Diplomatic Technology (DT).

Roles and Responsibilities:

This position requires a strong combination of data architecture, data modeling, analytics, and Power BI expertise. The successful candidate must be capable of looking beyond individual report development and determining the appropriate overall architecture for delivering enterprise reporting and analytics through Power BI using semantic models with robust governance and strong security.

Key Responsibilities

• Review BusinessObjects reports, Universes, data sources, calculations, business rules, dependencies, and security requirements.
• Develop the target-state architecture for migrating reporting and analytics capabilities 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, including appropriate fact and dimension structures.
• Identify Power BI technical limitations, performance risks, architectural constraints, and migration issues and recommend appropriate solutions or alternatives.
• Determine the appropriate placement of data transformations, calculations, and business logic across Synapse, Power BI semantic models, and other applicable data layers and ETL components.
• Troubleshoot Power BI performance and optimize semantic models, queries, and reports
• Work with business stakeholders, data engineers, database teams, report developers, and application teams to translate existing reporting requirements into an optimized Power BI solution.
• Provide technical leadership and guidance to Power BI developers implementing the architecture.

DOSCSM

Qualifications

Minimum Qualifications

• Bachelor’s degree in STEM along with 8+ years experience.
• 7+ years of experience in Business Intelligence, analytics, data architecture, or related disciplines.
• 4+ years of hands-on experience architecting and designing enterprise Microsoft Power BI solutions.
• Advanced experience with Power BI semantic modeling, DAX, Power Query/M, and Power BI Service.
• Demonstrated experience migrating or modernizing legacy enterprise BI/reporting platforms.
• Ability to communicate architecture decisions and tradeoffs to both technical teams and business stakeholders.
• U.S. Citizen.
• Must be able to obtain or have an Active Secret (or higher) clearance. Interim clearances acceptable.
• Ability to work on-site 3x a week in Herndon, VA

Preferred Qualifications:

• Experience with SAP BusinessObjects, including Web Intelligence (WebI), Universes, and enterprise reporting concepts.
• Experience migrating SAP BusinessObjects reporting environments to Power BI.
• Experience with Microsoft Fabric, Azure data services, or modern cloud data platforms.
• Experience designing enterprise Power BI governance and Center of Excellence standards.
• Microsoft Power BI or Fabric certifications.
• Experience supporting large-scale, mission-critical reporting environments.

Target Salary Range

$86,000 - $138,000. This represents the typical salary range for this position. Salary is determined by various factors, including but not limited to, the scope and responsibilities of the position, the individual's experience, education, knowledge, skills, and competencies, as well as geographic location and business and contract considerations. Depending on the position, employees may be eligible for overtime, shift differential, and a discretionary bonus in addition to base pay.

Benefits Statement

Peraton offers eligible employees a variety of benefits including medical, dental, vision, life, health savings account, short/long term disability, EAP, parental leave, 401(k), paid time off (PTO) for vacation, and company paid holidays. A full listing of available benefits can be viewed athttps://www.careers.peraton.com/benefits.

EEO

EEO: Equal opportunity employer, including disability and protected veterans, or other characteristics protected by law.