Power BI Data Architect

Peraton

. Lead the architecture and technical design for migrating an existing SAP BusinessObjects reporting environment backed by SAP HANA to Microsoft Power BI .

Posted 11/6/2026full-timeHerndon • Virginia • United StatesSeniorLead💰 $86,000 - $138,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Expertise in architecting and designing enterprise Microsoft Power BI solutions, including advanced Power BI semantic modeling, DAX, and Power Query/M. Proven ability to lead migrations from SAP BusinessObjects to Power BI while ensuring optimal performance and scalability.

Highest-signal resume keywords

Microsoft Power BI ArchitectureDAX ProficiencyData ModelingSAP BusinessObjects MigrationBusiness Intelligence Leadership

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Power BI Semantic ModelingDAXPower Query/MData ArchitectureETL ComponentsDimensional Data ModelsPerformance OptimizationData TransformationsBusiness Rules AnalysisReporting Requirements Translation

Soft Skills

Technical LeadershipCommunicationCollaboration

Tools & Technologies

Microsoft Power BISAP HANASAP BusinessObjectsMicrosoft FabricAzure Data ServicesSynapse

Certifications & Qualifications

Microsoft Power BI CertificationMicrosoft Fabric CertificationActive Secret Clearance

Industry Keywords

Business IntelligenceAnalyticsReporting EnvironmentsEnterprise ReportingGovernance Standards

Tech Stack

Tools & technologies

AzureCloudETL

About the role

Key responsibilities & impact

Lead the architecture and technical design for migrating an existing SAP BusinessObjects reporting environment backed by SAP HANA to Microsoft Power BI
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 with appropriate fact and dimension structures
Identify Power BI technical limitations, performance risks, architectural constraints, and migration issues, and recommend solutions or alternatives
Determine appropriate placement of data transformations, calculations, and business logic across Synapse, Power BI semantic models, 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 reporting requirements into optimized Power BI solutions
Provide technical leadership and guidance to Power BI developers implementing the architecture
Support the Department of State Consular Systems Modernization Program for the Bureau of Diplomatic Technology

Requirements

What you’ll need

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 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: Experience with SAP BusinessObjects, including Web Intelligence (WebI), Universes, and enterprise reporting concepts
Preferred: Experience migrating SAP BusinessObjects reporting environments to Power BI
Preferred: Experience with Microsoft Fabric, Azure data services, or modern cloud data platforms
Preferred: Experience designing enterprise Power BI governance and Center of Excellence standards
Preferred: Microsoft Power BI or Fabric certifications
Preferred: Experience supporting large-scale, mission-critical reporting environments

Benefits

Comp & perks

Medical insurance
Dental insurance
Vision insurance
Life insurance
Health savings account
Short-term disability
Long-term disability
Employee Assistance Program (EAP)
Parental leave
401(k)
Paid time off (PTO) for vacation
Company-paid holidays
Potential eligibility for overtime
Potential eligibility for shift differential
Discretionary bonus eligibility