StPaulRecruiter Since 2001
the smart solution for St. Paul jobs

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

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Minnesota jobs by following @recnetMN on Twitter!

St. Paul RSS job feeds