Job Details

Must have state/Federal experience

Description of Engagement

• The Minnesota Department of Information Technology Services (MNIT), partnering with the Minnesota Department of Labor and Industry (DLI), resources to perform Developer duties and Quality Assurance Analyst duties for the Prevailing Wage system modernization project
• Minnesota's Prevailing Wage law (Minnesota Statutes 177.41 through 177.44) requires employees working on state-funded construction and public works projects to be paid wage rates comparable to wages paid for similar work in the area where the project is located.
• DLI is responsible for administering the Prevailing Wage law.
• s part of the agency wide modernization of all DLI technical systems, MNIT/DLI wishes to implement a state-of-the-art technology solution for Prevailing Wage.
• The solution would move the Prevailing Wage system off of aging technology and transform work with more streamlined business processes built into the new tool.
• DLI currently utilizes custom-developed automated systems for the processing of prevailing wage survey collection.

• Labor Standards application (Imaging system)
• PowerBuilder programming language (client/server) (User Interface)
• Informix (Database)
• Interfaces
• C programs (Linux server)
• Bash shell scripts (Linux server)
• Web-based forms and Flat file transfer systems (Electronic Data Interchange (EDI))
• Online surveys and wage reports, batch processing
• SP.Net Web forms C# / PHP
• MariaDB
• SQL Server
• FTP client/ server interactions
• Bash scripts
• Interface
• FTP client/server interactions (Linux server)
• The key business drivers for an effective new solution are efficiency, automation, and data quality improvement.

• Data Intake and Quality: More flexible data quality and remediation for incoming survey data
• Interactive Worksheet: utomated manual wage calculation process, using configurable business rules
• Communication: Simple workflow and notification capabilities to generate communications or alerts and support processes for editing, review, and approval of survey data
• Reports : Flexible reporting to offer additional graphical, geographical, dashboard, and table-style reports
• Technology and Support: Minimize DLI/MNIT effort to maintain the application, database, native web user interfaces, and underlying infrastructure
• The Developer resource will work to develop and modernize the Prevailing Wage system based on solution requirements supplied by the State.
• The Quality Assurance Analyst resource will write and execute test cases and carry out an overall testing strategy that includes unit, integration, regression, performance, security, and accessibility testing for the system.

• nalyze existing application to develop lists of fields and forms needed to be reproduced in the new application.
• Collaborate with business analyst to understand requirements and create design documentation.
• Create front end data input web forms to replicate old PowerBuilder forms and any new forms needed to collect data.
• Create backend API to receive form data and store in database.
• Create database tables.
• Create data output reports.
• Create business logic engine.
• Create interface system with external partners (i.e. Wagekey, Fair Contracting Foundation of MN).
• Work with State Geospatial staff as needed to develop mapping components.
• Provide knowledge transfer to State staff.
• Perform other related duties as assigned.

• Experience with .NET development
• Experience with Angular development
• Experience with Azure and cloud services
• Experience with Git
• Experience with Azure DevOps
• Experience with SQL and Microsoft SQL server