Highlights
The Minnesota Department of Information Technology Services (MNIT) 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, and migrate existing Tableau/Crystal reports to PowerBI. Additionally, the resource will 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.
Numbers & Facts
| Location | St Paul, MN, MN (Remote) |
| Industry | Computer/IT Services |
| Company Size | 100 to 499 employees |
| Year Founded | 1997 |
| Website | https://www.tscti.com/careers-0 |
Description
Description of Project
The Minnesota Department of Information Technology Services (MNIT) 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, and migrate existing Tableau/Crystal reports to PowerBI. In addition, this individual will need to set up and configure PowerBI as it relates to the PowerPlatform environment and 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 and elicit business requirements when business analyst is unavailable, this includes communication and documentation of business rules. The resource will construct automation routines to export data to other mediums (e.g. Excel) and ensure all reports meet agency and performance requirements. Additionally, the resource will 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.
Tasks
The Minnesota Department of Information Technology Services (MNIT) 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, and migrate existing Tableau/Crystal reports to PowerBI. In addition, this individual will need to set up and configure PowerBI as it relates to the PowerPlatform environment and 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 and elicit business requirements when business analyst is unavailable, this includes communication and documentation of business rules. The resource will construct automation routines to export data to other mediums (e.g. Excel) and ensure all reports meet agency and performance requirements. Additionally, the resource will 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.
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
- 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)
About Company
22nd Century Technologies, Inc., is one of the fastest growing IT Service Integrator and Workforce Solution companies in the United States. Founded in 1997, 22nd Century Technologies is a Certified National Minority Business Enterprise with 6,000+ people including 600+ Cyber SMEs nationwide supporting our customers in all 50 states, Canada, and Mexico. With HQs in Somerset, NJ and Mclean, VA, 22nd Century has 14 offices throughout the United States. As part of our unrelenting focus on quality and compliance, 22nd Century Technologies’ delivery is based on Certified Matured Processes including CMMI L3 Dev & SVC, ISO 20000, ISO 27001, and ISO 9001 quality processes. With a strong focus on the public sector, 22nd Century currently holds government contracts with 14 out of 15 Federal Executive agencies including DoD, 37 other Federal agencies, 50 States, 115+ Local agencies, and 37 School Districts. In the last three years, we have expanded our services to Fortune 500 and other commercial clients and currently support 80+ commercial clients.
Recognized among “Best Company to Work For” by Forbes, 22nd Century Technologies, Inc., consistently exceeds our clients’ expectations by focusing on their absolute satisfaction with jobs while keeping our employees motivated.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.