7+ years in Business Intelligence, analytics, or data architecture.
4+ years of hands-on experience with Microsoft Power BI solutions.
Advanced skills in Power BI semantic modeling, DAX, and Power Query/M.
Experience in migrating legacy BI/reporting platforms.
Strong communication skills for technical and business discussions.
U.S. Citizenship and ability to obtain an Active Secret clearance.
Responsibilities
Review existing BusinessObjects reports and security requirements.
Develop architecture for migrating to Microsoft Power BI.
Determine which reports to migrate, consolidate, or retire.
Design scalable Power BI semantic models and datasets.
Create dimensional data models with appropriate structures.
Identify and recommend solutions for Power BI limitations and risks.
Optimize Power BI performance and troubleshoot issues.
Collaborate with stakeholders to translate reporting needs into Power BI solutions.
Provide technical leadership to Power BI developers.
Benefits
Full-time contract position with potential for long-term engagement.
Opportunity to work on a high-impact government modernization program.
Engagement with a diverse team of data professionals.
Access to advanced tools and technologies in data analytics.
Potential for professional development and certifications.
Full Job Description
Job Type
Full-time, Contract
Description
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.
