[Hiring] Power BI Developer @Omm IT Solutions

Role Description

The Client 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
• Migrate existing Tableau/Crystal reports to PowerBI
• Set up and configure PowerBI as it relates to the PowerPlatform environment
• 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
• Elicit business requirements when the business analyst is unavailable, including communication and documentation of business rules
• Construct automation routines to export data to other mediums (e.g., Excel)
• Ensure all reports meet agency and performance requirements
• Configure and establish best practice security, accessibility, and access management controls around the reporting environment
• Develop data refresh strategies sourcing from Azure SQL Server and other applicable data sources

Qualifications

• 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)

Requirements

• 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