Power BI Architect

Power BI Architect Strategic Staffing Solutions

• 3.6 Richmond, VA Job Details Full-time | Contract $100
• $102 an hour 11 hours ago Qualifications Data model design Cloud identity and access management (IAM) Performance tuning Power BI Data visualization software proficiency Cloud data warehouses SQL Azure AD Star schema BigQuery Active Directory Virtual Private Clouds Dimensional modeling Identity & access management Full Job Description PowerBI Semantic Model Architect 3-6 months contract to hire Richmond, VA•remote but will have meetings in Richmond onsite occasionally •ideal candidates are within a 2 hour radius of Richmond W2 Rate•$100-102/hr•

NO CTC NO 1099 NO THIRD PARTY

Technical Skills & Requirements Power BI & Semantic Modeling (Expert) Advanced Power BI semantic modeling (DirectQuery and Import modes) Deep expertise in DAX performance tuning and query behavior Performance Analyzer, DAX Studio, and Tabular Editor mastery Strong understanding of VertiPaq vs DirectQuery execution patterns BigQuery & SQL (Advanced) Ability to analyze generated SQL from Power BI and optimize queries Strong understanding of partitioning, filtering, and join optimization Experience working with large-scale analytical datasets in BigQuery Data Modeling (Advanced) Star schema design for high-performance BI systems Fact/dimension modeling optimized for DirectQuery performance Knowledge of materialized views and aggregated modeling strategies Platform & Cloud (Intermediate to Advanced) Power BI Service administration (workspaces, governance, refresh policies) GCP IAM, service accounts, and BigQuery dataset security models On-premises gateway architecture in GCP VPC environments Entra ID / Azure AD integration for authentication and access control

Critical Skill:

DAX Query Folding A core responsibility of this role is ensuring DAX query folding to BigQuery. When folding works correctly, Power BI translates DAX into efficient BigQuery SQL, minimizing data movement and cost. When folding fails, Power BI processes data in-memory, which can result in significant performance degradation and increased query costs.

Pay:

$100.00

• $102.

00 per hour

Work Location:

Remote