Power BI Developer

Akaasa Technologies; Virginia (MN); On-site; USD 90,000 - 130,000; Full time

Job summary

State Corporation Commission (SCC) is seeking a Power BI Developer for a one-year contract to design, build, and maintain analytics reporting across agency divisions. The role focuses on dashboards, semantic models, and data connections using Dataverse, SQL Server, Azure Blob Storage, and Cosmos DB.

Collaboration with stakeholders and adherence to security standards are essential for success. The position is a full-time contract within the SCC's Enterprise Technology Services (ETS) division,

Qualifications

• Experience designing and maintaining Power BI reports and dashboards.
• Knowledge of Dataverse data models and security configurations.
• Experience with data querying and transformations (Power Query) in diverse sources.

Responsibilities

• Design, develop, and maintain Power BI reports, dashboards, and semantic models.
• Build reporting solutions on Dataverse data models with existing tables and security.
• Develop data connections and transformations using Power Query with SQL Server, Azure Blob Storage, and Cosmos DB.
• Develop and optimize DAX measures and semantic model relationships for performance.
• Collaborate with stakeholders to define measures and translate business questions into visuals.
• Support reporting needs across product teams and BI lead with prioritization.
• Handle short-duration reporting requests as agency priorities require.
• Document semantic models, data sources, and refresh dependencies for SCC maintenance.
• Support end user adoption through walkthroughs and knowledge transfer.
• Participate in agile ceremonies and backlog refinement.

Skills

Power BI

DAX

Power Query

Data Modeling

Semantic Modeling

SQL Server

Azure Blob Storage

Cosmos DB

Stakeholder Communication

Tools

Dataverse

SQL Server

Azure Blob Storage

Cosmos DB

Power Query

Security Configurations

Job description

Power BI Developer The State Corporation Commission's (SCC) Enterprise Technology Services ("ETS") Division seeks a contract Power BI Developer to design, build, and maintain reporting and analytics solutions supporting business divisions across the agency. This is a full-time contract engagement with an initial term of one year and the option to extend.

Responsibilities Include:

• 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.