Data Architect Jobs

About The Position

Requirements

• Bachelor’s degree in a STEM field and 8 or more years of experience.
• 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.
• Must be a U.S. citizen.
• Must be able to obtain or hold an active Secret or higher clearance; interim clearances are acceptable.
• Ability to work on-site three days a 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 reside 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

• Medical, dental, and vision benefits.
• Life insurance.
• Health savings account.
• Short- and long-term disability.
• Employee assistance program (EAP).
• Parental leave.
• 401(k).
• Paid time off for vacation.
• Company-paid holidays.
• Depending on the position, employees may be eligible for overtime, shift differential, and a discretionary bonus.