Quick overview
Job description
Job Title: Power BI Data Architect
Location: Herndon VA
Duration: Long term
Clearance: Able to obtain
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.
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.
“CompQsoft provides equal opportunity in all aspects of employment and in the working environment to all employees and applicants. CompQsoft does not take any non-merit factors like race, color, religion, sex (gender), mental/physical disability, and age into account for purposes of recruitment, hiring and development.
Similar jobs
- ML
Senior QA Automation EngineerRecently posted
Masterapp Labs · Glen Allen, VA · On-site · Posted 16 Nov 2026 🇺🇸
JiraTechnologySalary not listed - MI
Workday Financials ConsultantRecently posted
Mindlance · New York, NY · Hybrid · Posted 16 Nov 2026 🇺🇸
WorkdayBudgetingERP+6TechnologySalary not listed - TC

Systems AdministrationRecently posted
Tri-Force Consulting Services Inc · New York, NY · On-site · Posted 16 Nov 2026 🇺🇸
Account ManagementActive DirectoryCompliance+3TechnologySalary not listed - SI

Storage Engineer | Storage & Backup | Experienced HireRecently posted
Susquehanna International Group, LLP · Bala Cynwyd, PA · Hybrid · Posted 16 Nov 2026 🇺🇸
AnsibleBashGrafana+3TechnologySalary not listed - AS

Python Kafka DeveloperRecently posted
Amaze Systems Inc · Farmington, WA · On-site · Posted 16 Nov 2026 🇺🇸
DockerMicroservicesSQL+19TechnologySalary not listed - CS

Senior Java DeveloperRecently posted
Cynet Systems · San Antonio, TX · Hybrid · Posted 16 Nov 2026 🇺🇸
DockerSpringSpring Boot+17Technology$45 - $50/hr - RI

Senior Backend Python DeveloperRecently posted
Rivago infotech inc · Charlotte, NC · Hybrid · Posted 16 Nov 2026 🇺🇸
DjangoFlaskMicroservices+18TechnologySalary not listed - BE

Workday Financial Solution ArchitectRecently posted
BESTPEGASUS LLC · New York, NY · On-site · Posted 16 Nov 2026 🇺🇸
Power BITechnologySalary not listed - IN

M365 SharePoint Online EngineerRecently posted
InterSources Inc. · Blythewood, SC · Hybrid · Posted 16 Nov 2026 🇺🇸
Microsoft OfficeSharePointWindows ServerTechnologySalary not listed - GL
Senior Software Engineer – Security Automation & AnalyticsRecently posted
Geopaq Logic · Seattle, WA · Hybrid · Posted 16 Nov 2026 🇺🇸
SQLGitLooker+9TechnologySalary not listed - SE
SAP R2R Lead - W2 CONTRACTRecently posted
SunRay Enterprise Inc · United States · On-site · Posted 16 Nov 2026 🇺🇸
Stakeholder ManagementManagement AccountingReconciliation+2TechnologySalary not listed - TM

Mission Systems Engineer, LeadRecently posted
The MITRE Corporation · McLean, VA · On-site · Posted 16 Nov 2026 🇺🇸
MATLABSQLPythonTechnology$146.4k - $183k/yr
