Pay
Higher than most similar jobs
$150K–$180K against $89K–$149K, the middle half of what similar US postings state.
From 21,449 postings in the last year. Stated ranges, not salaries paid.
Power BI Data Architect (Active Secret or Interim Clearance required)
- Pay
$150,000–180,000/yearAnnual period assumed — pay source
Salary Description $150000 - $180000
Read the full posting- Work setting
On-site — work setting source
Work setup in the employer’s posting: On-site
From the employer’s posting- Employment
Full-time · Contract — employment source
Job Type Full-time, Contract Description Description
Read the full posting
Before you apply
- Work authorization
- Citizens only
Must be able to obtain or have an Active Secret (or higher) clearance
What you’ll work on
Full postingDevelop the target-state architecture for migrating reporting and analytics capabilities to Microsoft Power BI.
Design scalable Power BI semantic models and reusable enterprise datasets.
Develop dimensional data models, including appropriate fact and dimension structures.
From the employer’s posting
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.
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.
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.
What you’ll bring
All qualificationsCore experience
- Bachelor’s degree in STEM.
- 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.
- Demonstrated experience migrating or modernizing legacy enterprise BI/reporting platforms.
- Ability to communicate architecture decisions and tradeoffs to both technical teams and business stakeholders.
Preferred experience
- 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.
Qualification wording
Bachelor’s degree in STEM.
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.
Demonstrated experience migrating or modernizing legacy enterprise BI/reporting platforms.
Ability to communicate architecture decisions and tradeoffs to both technical teams and business stakeholders.
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.
Education & alternatives
Minimum Qualifications - Bachelor’s degree in STEM. - 7+ years of experience in Business Intelligence, analytics, data architecture, or related disciplines.
Posting record
Report an errorActively hiringFirst seen by us today, still listed, and not a repost of an earlier posting.
- Status in our records
- Live
- First seen by us
- Nov 13, 2026today
- Recorded sightings
- 1
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
How this job compares
Time since we first saw it
Day 0
Early. Similar jobs usually come down between day 9 and day 58.
From 40,073 similar postings that came down. Coming down is not always a hire.
Default - DO NOT USE is hiring
1 open job
Open jobs by the week we first saw them, last 12 weeks.
Hiring recordSee how this role fits your experience
Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
- Azure
- Power BI
- Power Query
- SAP
Where the posting names them
- 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.
Description Client 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:
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.
- 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.
- 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.
- 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
- 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.
- 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.
- 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. Requirements
- 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.
- 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.
- 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 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 designing enterprise Power BI governance and Center of Excellence standards. - Microsoft Power BI or Fabric certifications. - Experience supporting large-scale, mission-critical reporting environments.
Preferred Qualifications: - Experience with SAP BusinessObjects, including Web Intelligence (WebI), Universes, and enterprise reporting concepts. - Experience migrating SAP BusinessObjects reporting environments to Power BI.
Your next step
Complete your application on recruiting.paylocity.com. The employer’s form will show what is required.
Applying through Paylocity
- “Upload your resume and we’ll automatically fill out your application”: the form fills itself from your file, so check it before sending.
Already applied? Track this application
Job description
Job Type
Full-time, ContractDescription
Description
Client 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.
Requirements
Minimum Qualifications
- Bachelor’s degree in STEM.
- 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.
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.
Salary Description
$150000 - $180000Source details
Source notes
Source excerptsSelected passages from the saved posting. Check the full description for conditions and exceptions.
- Pay
Salary Description $150000 - $180000
- Location & working pattern
Herndon, VA
Working pattern and location restrictions need checking in the full posting.
- Work authorization
- 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.