Design a stable, reliable, and effective Power BI Service environment for reporting
Develop dashboards and create new complex Power BI custom UI visualizations according to specifications
Write and extract SQL queries to validate student loan data from various sources, including forbearance data
Perform data validation tasks to ensure data quality across multiple data sets and conduct root cause analysis of loan-related data issues and anomalies
Migrate existing Tableau and Crystal reports to Power BI
Set up and configure Power BI as it relates to the Power Platform environment
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
Construct automation routines to export data to other mediums such as Excel
Ensure all reports meet agency and performance requirements
Gather business requirements and identify new features, including documentation and leading technical meetings when business analyst is unavailable
Develop technical manuals and provide user-level training to the State
Lead Power BI technical training, mentoring, and co-development with business area employees
Liaise with developers to improve reporting functionality and establish best practices
Deliver daily project status reports to end clients tracking progress to milestones
Perform knowledge transfer
Qualifications
Required
Advanced Power BI development experience
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 for both informal and formal settings