Power BI Developer

HighCloud Solutions; Saint Paul (MN); On-site; USD 90,000 - 120,000; Full time

Job summary

MNIT, in partnership with the Office of Higher Education, seeks a full-time Power BI Developer to write SQL queries, validate loan data, construct dashboards, and migrate Tableau/Crystal reports to Power BI. The role includes configuring Power BI within the Power Platform and Azure SQL Server, plus user-level training for state staff.

The resource will deliver complex Power BI visuals, ensure accessibility and security, and produce reliable reports meeting agency requirements while supporting ad

Qualifications

• Advanced Power BI development experience with five years.
• Experience validating student loan data from multiple sources.
• Strong experience writing technical documentation.
• Excellent communication skills with senior leaders.
• Versatile presentation skills for various audiences.

Responsibilities

• Design a stable, reliable Power BI Service environment for reporting.
• Develop dashboards for various business users.
• Create complex Power BI visualizations per specifications.
• Perform data validation across multiple data sets.
• Lead reporting improvements and establish best practices.
• Provide technical manuals and user training.

Skills

Power BI Development

Data validation

Technical documentation

High-level communication

Presentation

Tools

Power BI

Azure SQL Server

SQL

Job description

The Minnesota Department of Information Technology Services (MNIT) partnering with Office of Higher Education (OHE) is seeking one full-time Power BI Developer to write/extract SQL queries, validate student loan data from various sources, construct PowerBI visualizations, create and maintain business dashboards, remediate accessibility issues, provide ad hoc reporting capabilities, and migrate existing Tableau/Crystal reports to PowerBI. In addition, this individual will need to set up and configure PowerBI as it relates to the PowerPlatform environment and perform user-level training to the State.

At a high level the resource is expected to produce a stable, reliable and effective PowerBI Service environment for reporting and create new complex PowerBI custom UI visualizations according to specifications. The resource will conduct root cause analysis of loan related data issues and anomalies and elicit business requirements when business analyst is unavailable, this includes communication and documentation of business rules. The resource will construct automation routines to export data to other mediums (e.g. Excel) and ensure all reports meet agency and performance requirements. Additionally, the resource will configure and establish best practice security, accessibility, and access management controls around reporting environment, and develop data refresh strategies sourcing from Azure SQL Server and other applicable data sources.

Sample Tasks

• Design a stable, reliable, and effective PowerBI Service environment for reporting
• Develop dashboards for various business users
• Create new complex PowerBI custom UI visualizations according to specifications
• Perform data validation tasks to ensure data quality across multiple data sets
• Liaise with developers to improve reporting functionality and establish best practices
• Gather business requirements and identify new features (including documentation and leading technical meetings)
• Develop technical manuals
• Lead Power BI technical training, mentoring, and co-development with business area employees
• Ensure all reports meet agency and performance requirements
• Configure and establish best practice security, accessibility, and access management controls around reporting environment
• Develop data refresh strategies sourcing from Azure SQL Server and other applicable data sources
• Deliver daily Project Status Reports to end clients tracking progress to milestones
• Perform knowledge transfer

Desired Skills & Experience

• Advanced Power BI Development experience of five years
• Experience performing robust student loan data validation (including forbearance data)
• Strong experience writing technical documentation
• Excellent communication skills, including communication with high-level leaders
• Versatile presentation skills (informal and formal)