Job Id: MNSITE-2669 (90090323)15
Remote PowerBI Developer/Admin with legacy migration, UI visualizations, Azure SQL Server, DAX, Crystal Reports and training experience
Location: St Paul MN (OHE)
Duration: 12 months
Minimum Qualifications
• Three (3) years’ experience in PowerBI development and administration roles
o A Master’s degree substitutes for three years of experience, or a Bachelor’s degree substitutes for two years, or an Associate’s degree substitutes for one year
• Two (2) engagements lasting more than six (6) months in PowerBI Development role
Desired Skills
• Proven work experience as a PowerBI developer
• In-depth understanding of the PowerBI environment (e.g. permissions, recovery, security and monitoring)
• Knowledge of data warehouses and Azure SQL Server
• Advanced experience with the SQL programming language
• Familiarity with creating custom DAX expressions/functions
• Excellent analytical and organization skills
• Ability to understand front-end users requirements and a problem-solving attitude
• Experience migrating Crystal reports to PowerBI
Sample Tasks
• Design a stable, reliable, and effective PowerBI Service environment for public and secure reporting
• Migrate legacy reports to PowerBI
• Create new complex PowerBI custom UI visualizations according to specifications
• Construct automation routines to export data to other mediums (e.g. Excel)
• Liaise with developers to improve reporting functionality and establish best practices
• Gather user requirements and identify new features
• Develop technical and training manuals
• Lead Power BI training, mentoring, and co-development with business area employees
• Ensure all reports meet agency and performance requirements
• Configure and establish best practice security 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
Description of Project
The Minnesota Department of Information Technology Services (MNIT) partnering with the Minnesota Office of Higher Education “OHE” is seeking one full-time resource to work on constructing PowerBI visualizations, transactional reports, automated extract files, ad hoc reporting capabilities, and migrate existing Tableau/Crystal reports to PowerBI. In addition, this individual will need to set up and configure the PowerBI Cloud service to support public and secure reports. Data sources will include a SQL based data warehouse and the Microsoft Power Platform(DataVerse) environment. The individual will also perform end-user training/mentoring.
At a high level, the resource will:
Gather report requirements
Write Power BI pagination reports and dashboards
Write SQL stored procedures
Create Power Flows for report automation activities
Work with Dynamics developers to integrate reports into Iframes
Work with legacy report logic and convert into Power BI
Leave a Reply