Power BI consultant

Company: Xylo Technologies
Location: Saint Paul
Posted on: March 19, 2023

Job Description:

Job Description

Title: Power BI Developer
Duration: 1 Year
100% remote

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 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 Minimum Qualifications
    • Three (3) years' experience in PowerBI development and administration roles
      • 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

Keywords: Xylo Technologies, St. Paul , Power BI consultant, Professions , Saint Paul, Minnesota