Data Architect Jobs

About The Position

Requirements

• Bachelor’s degree in STEM and 8 or more years of experience.
• 7 or more years of experience in business intelligence, analytics, data architecture, or related disciplines.
• 4 or more 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 or reporting platforms.
• Ability to communicate architecture decisions and tradeoffs to technical teams and business stakeholders.
• U.S. citizenship.
• Must be able to obtain or have an active Secret or higher clearance; interim clearances are acceptable.
• Ability to work onsite three days per week in Herndon, Virginia.

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 data transformations, calculations, and business logic should be placed across Synapse, Power BI semantic models, other applicable data layers, and ETL components.
• Troubleshoot Power BI performance and optimize semantic models, queries, and reports.
• Collaborate 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

• Medical benefits
• Dental insurance
• Vision insurance
• Life insurance
• Health savings account
• Short- and long-term disability
• Employee assistance program (EAP)
• Parental leave
• 401(k)
• Paid time off (PTO) for vacation
• Company-paid holidays
• Potential eligibility for overtime, shift differential, and a discretionary bonus