Power BI Data Architect (Gov't Tech)

Sikich•Herndon, VA
•Onsite

About The Position

Sikich is seeking a senior-level Power BI Data Architect to lead the architecture and technical design for migrating an existing SAP BusinessObjects reporting environment backed by SAP HANA to Microsoft Power BI. The position is based in Herndon, Virginia, and supports Sikich’s Department of State Consular Systems Modernization Program for the Bureau of Diplomatic Technology. The role requires expertise in data architecture, data modeling, analytics, and Power BI. The architect will develop an enterprise reporting and analytics architecture using governed, secure semantic models, and will guide implementation beyond individual report development. The position involves working with business stakeholders and technical teams to translate existing reporting needs into an optimized Power BI solution.

Requirements

  • Bachelor’s degree in STEM.
  • At least 7 years of experience in Business Intelligence, analytics, data architecture, or related disciplines.
  • At least 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 technical teams and business stakeholders.
  • U.S. citizenship.
  • Must be able to obtain or hold an active Secret or higher security clearance; interim clearances are acceptable.
  • Servant leadership: engaging employees, fostering their development, and building a positive culture.
  • Solutions-focused approach: developing, articulating, and implementing solutions to business problems.
  • Collaboration and relationship-building across organizational levels and business units.
  • Integrity, consistency, follow-through, and credibility that instill trust.
  • Ability to gain support for ideas, proposals, and solutions and influence action to advance initiatives, with or without formal authority.

Nice To Haves

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

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 solutions or alternatives.
  • Determine where to place data transformations, calculations, and business logic across Synapse, Power BI semantic models, other 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 reporting requirements into an optimized Power BI solution.
  • Provide technical leadership and guidance to Power BI developers implementing the architecture.

Benefits

  • Flexible Time Off policy, available from the first day of employment.
  • Paid holidays; the posting specifies eleven annually.
  • Wellness program with activities that may earn gift cards and other rewards.
  • Flexible work arrangements.
  • Health, dental, vision, life, and accident/death/disability insurance options.
  • Employer contribution to a Health Savings Account (HSA).
  • Paid parental bonding leave covering birth, adoption, and foster children.
  • 401(k) with employer contributions.
  • Tuition reimbursement.
  • Employee referral bonus program.
  • Client referral bonus program.
  • Pet insurance.
  • Up to four hours of paid annual volunteer time through the FORCE community volunteer program.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service