Power BI Analytics Architect

Global Sumi Technologies Inc.,; Richmond (VA); On-site; USD 90,000 - 120,000; Full time

Job summary

Global Sumi Technologies Inc. seeks a Power BI professional to design, develop, and maintain reports, dashboards, and semantic models across divisions and product teams.

You will connect to Dataverse, SQL Server, Azure Blob Storage, and Cosmos DB, building efficient data transformations with Power Query and crafting robust DAX measures for accurate insights. You will collaborate with business stakeholders to translate questions into visual analyses, support multiple teams, and help ensure data

Qualifications

• Design, develop, and maintain Power BI reports, dashboards, and semantic models to support business divisions and product teams.
• Build reporting solutions on established Dataverse data models, working with existing tables, relationships, and security configurations.
• Develop data connections and transformations using Power Query against sources like SQL Server, Azure Blob Storage, and Cosmos DB.
• Develop and optimize DAX measures, calculated columns, and semantic model relationships for accuracy and performance.
• Collaborate with stakeholders to translate business questions into usable visualizations and measures.
• Support multiple product teams and SCC BI lead with prioritization and agile ceremonies.
• Handle time-sensitive reporting requests as agency priorities require.
• Adhere to workspace structure, dataset management, row-level security, and security standards.
• Maintain and enhance reports and datasets, including performance tuning and refresh troubleshooting.
• Document semantic models, measure definitions, data sources, and refresh dependencies for ongoing maintenance and knowledge retention.
• Support end-user adoption through walkthroughs and knowledge transfer.
• Participate in backlog refinement and requirements discussions.

Responsibilities

• Create and maintain Power BI reports and dashboards that align with business needs.
• Implement semantic models and relationships to ensure accurate analytics.
• Establish and optimize data connections via Dataverse and Power Query.
• Write efficient DAX measures and calculated columns for performance.
• Work with stakeholders to define metrics and translate questions into visuals.
• Support multiple teams and respond to urgent reporting requests.
• Ensure security standards and dataset governance are followed.
• Document models, data sources, and dependencies for SCC maintenance.

Skills

Power BI

Power Query

DAX

Semantic Modeling

Data Visualization

Stakeholder Communication

Agile Methodologies

Tools

Dataverse

SQL Server

Azure Blob Storage

Cosmos DB

Job description

Global Sumi Technologies Inc. seeks a Power BI professional to design, develop, and maintain reports, dashboards, and semantic models across divisions and product teams.

You will connect to Dataverse, SQL Server, Azure Blob Storage, and Cosmos DB, building efficient data transformations with Power Query and crafting robust DAX measures for accurate insights. You will collaborate with business stakeholders to translate questions into visual analyses, support multiple teams, and help ensure data