Responsibilities
- Writing and extracting SQL queries
- Validating student loan data from multiple sources
- Developing Power BI visualizations, custom UI components, and business dashboards
- Maintaining reports
- Remediating accessibility issues
- Providing ad hoc reporting
- Migrating existing Tableau and Crystal Reports to Power BI
- Configuring Power BI within the Power Platform environment and providing user-level training to the State
- Establishing and maintaining a stable, reliable, and effective Power BI Service reporting environment
- Developing complex custom visualizations to meet specifications
- Conducting root cause analysis of loan-related data issues and anomalies
- Gathering business requirements when a business analyst is unavailable, including documenting and communicating business rules
- Developing automated data exports to other formats (e.g., Excel)
- Ensuring reports meet agency and performance requirements
- Implementing security, accessibility, and access management best practices
- Developing data refresh strategies using Azure SQL Server and other applicable data sources
- Delivering daily Project Status Reports to end clients tracking progress to milestones
- Performing knowledge transfer
The work is expected to be done remotely.
Sample Tasks
- 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
Required Skills and Experience
- Advanced Power BI Development experience of five (5) 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)
Mode of Interview
Interviews will be conducted remotely via Microsoft Teams.
Project Schedule
- Anticipated Project Start Date: December 2026
- Anticipated Project End Date: August, 2027
Company Overview
Quetica is a specialized consulting and product development firm led by industry experts with deep expertise in engineering, information technology and big data solutions. Quetica helps state and government agencies, commercial clients and financial institutions globally to efficiently and effectively accelerate business growth, achieve sustainable cost reduction and accomplish better service levels through delivery of hands-on practical expertise and world class solutions.