IO Datasphere, Inc. has been providing project management, software development and IT staff augmentation services to our clients in the Midwest and throughout the U.S. since 1996. We are an approved vendor on contract to provide software development and IT staff augmentation services for the States of Illinois, Michigan, Minnesota, Iowa, and Wisconsin. We also provide these services to businesses, as well as local and county governments, in the Midwest and nationwide.

Our client 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.

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.

Tasks

· Set up and configure PowerBI as it relates to the PowerPlatform environment and perform user-level training

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

· Construct automation routines to export data to other mediums (e.g. Excel) and ensure all reports meet agency and performance requirements.

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

· 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

Knowledge, Skills and Abilities Required:

· Excellent communication skills, including communication with high-level leaders

· Versatile presentation skills (informal and formal)

NOTE: The work is expected to be done remotely.

Location: St. Paul, MN

Contract: 1 year

Skills Required:

· 5 years - Advanced Power BI Development experience

· Strong experience writing technical documentation

· Experience writing/extracting SQL queries

· Experience constructing PowerBI visualizations, create and maintain business dashboards, remediate accessibility issues, provide ad hoc reporting capabilities, and migrate existing Tableau/Crystal reports to PowerBI.

Skills Desired – A plus to have:

· Experience performing robust student loan data validation (including forbearance data)

*** Rate depends on experience

*** Candidates authorized to work in the US are encouraged to apply. We can accept H1b, , TN, and other valid work visas for IT. However, we cannot accept OPT or CPT visas at this time.

*** Companies submitting candidates should only submit direct W2 employees for this position.

Please submit your resume by using the "URL" below