Back to jobs

Power BI Data Architect

Pay
Pay not listedSimilar roles state $154K–$226K
Work setting
Not stated
Employment
Full-time — employment source
Employment type in the employer’s posting: FULL_TIME
From the employer’s posting

Before you apply

Work authorization
Citizens onlyMust be able to obtain or have an Active Secret (or higher) clearance

What you’ll work on

Full posting
  • Develop 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 qualifications

Core 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.
Apply at OneZero Solutions

Posting record

Report an error

Actively 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

Pay

$154K–$226K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 3,103 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 0

Early. Similar jobs usually come down between day 8 and day 57.

From 9,462 similar postings that came down. Coming down is not always a hire.

OneZero Solutions is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See 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.
We are an employee-centric company that truly values our team members and the contributions they make to our customers and the missions they support. We pride ourselves on being forward-leaning thinkers and on building teams that are, and continue to be, technically proficient across a broad range of cyber mission areas. OneZero full-time employees receive a highly competitive benefits package, including health, dental, vision, and life insurance, a 401(k) with company matching, paid time off and holidays, an employee referral program, and educational assistance. Additional details are available on our website: https://www.onezerollc.com/careers/ Position Title: Power BI Data Architect Location: Herndon, VA
Description OneZero 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. Minimum Qualifications
- 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 onezerollc.applicantpro.com. The employer’s form will show what is required.

Already applied? Track this application

Demand for Data Leadership roles

New Data Leadership postings at the employers we follow are about the same over the last 6 weeks compared with the 6 before.

Weekly new Data Leadership postings at the same employers, from the week of August 17 to the week of November 2. The fewest in a week was 754, the most 1,166, and the latest week had 892.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Leadership, by the work the posting describes.

Data leaders run data teams or design how a company's data fits together. Managers hire, set priorities and answer for whether the data work pays off; architects choose the systems and the shape of the data.

Expect years of hands-on data work, experience leading people or projects, and the ability to explain tradeoffs to executives.

Unlike a senior engineer or analyst, most of a data leader's week goes to people, planning and decisions rather than building.

US government figures for computer and information systems managers

Median yearly pay, May 2025
$175,140
Expected change, 2025 to 2035
15.8% more jobsagainst 3.5% for all jobs

The government has no code for data leaders, so these figures are for the closest group, computer and information systems managers, which includes data processing and data operations managers.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 11-3021.

Job description

View original posting ↗

We are an employee-centric company that truly values our team members and the contributions they make to our customers and the missions they support. We pride ourselves on being forward-leaning thinkers and on building teams that are, and continue to be, technically proficient across a broad range of cyber mission areas. OneZero full-time employees receive a highly competitive benefits package, including health, dental, vision, and life insurance, a 401(k) with company matching, paid time off and holidays, an employee referral program, and educational assistance. Additional details are available on our website: https://www.onezerollc.com/careers/

Position Title: Power BI Data Architect

Location: Herndon, VA

Clearance: Secrt

Description

OneZero  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.

 

 

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.

OneZero Solutions, LLC is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

To request an accommodation, please contact us at recruiting@onezerollc.com or call (202) 987-2580.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Herndon, VA, 20170, US

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.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.