Power BI Data Architect
Herndon, VA - USA
Job Summary
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: 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 Peratons 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
- Bachelors 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 or call .
Required Experience:
Staff IC