Power BI Developer

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

• Design, develop, and maintain Power BI reports, dashboards, and semantic models supporting business divisions and product teams across the agency.
• Build reporting solutions on established Dataverse data models, working with existing tables, relationships, and security configurations rather than defining the underlying data layer.
• Develop data connections and transformations using Power Query against additional sources as required, including SQL Server, Azure Blob Storage, and Cosmos DB.
• Develop and optimize DAX measures, calculated columns, and semantic model relationships for accuracy and performance.
• Work with business stakeholders to understand reporting needs, define measures and metrics, and translate business questions into usable visualizations.
• Support reporting needs across multiple product teams and divisional efforts, with assignment and prioritization directed by the SCC Power Platform and business intelligence lead.
• Support short-duration, time-sensitive reporting requests as agency priorities require.
• Implement reports in accordance with established workspace structure, dataset management, and row-level security standards, and contribute recommendations to strengthen those standards.
• Apply appropriate handling of sensitive and restricted data in accordance with SCC data classification and security requirements, building to established security design.
• Maintain and enhance existing reports and datasets, including performance tuning, refresh troubleshooting, and defect resolution.
• Document semantic models, measure definitions, data sources, and refresh dependencies to support ongoing SCC maintenance and knowledge retention.
• Support end user adoption through report walkthroughs and knowledge transfer to business users and SCC staff.
• Participate in agile ceremonies, backlog refinement, and requirements discussions.