.Net/Data Architect with C#, API design, JSON, CI/CD, OpenAPI/swagger and K12/education experience

Job ID: MT-0069AH-DA (90090723)4P

.Net/Data Architect with C#, API design, JSON, CI/CD, OpenAPI/swagger and K12/education experience

Location: Helena MT (Montana Office of Public Instruction (OPI))
Duration: 42 months (up to 40 hours per week)
Positions: 1 (1/2)
The individual may work remote but will be required to occasionally work on-site at OPI offices in Helena on demand and on short notice

Knowledge, Skills and Abilities
• Proficiency in C# and dotnet core
• API Design and implementation experience
• Able to work within an existing CI/CD environment and make improvements
• OpenAPI (swagger) experience
Experience Requirements
1. 10+ years work experience as a developer.
2. Expert knowledge of principles and practices of electronic data and information management systems and procedures.
3. Expert technical background, with understanding or hands-on experience in software development and web technologies.
4. Proven working experience as a technical lead in the information technology domain.
5. Experience with public education systems and data and/or a background in public education are highly preferred.
6. Strong organizational skills including attention to detail and multi-tasking skills.

Job/Project Description
A Data Architect/Solution Architect/API Developer is being sought (starting August 2020) to provide up to 40 hours per week Data Architect/Solution Architect/Front-End Developer expertise for the Montana Office of Public Instruction (OPI) MITI Grant project. The individual will be required to work on-site at OPI offices in Helena.

In 2009, the Montana Office of Public Instruction was awarded our first SLDS grant from the US Department of Education. With this grant the OPI created Montana’s Statewide Longitudinal Data System (SLDS), which is named GEMS (Growth and Enhancement of Montana Students). GEMS is currently running on a javascript based front-end with a RESTful API abstraction layer based on an OpenAPI specification and a Microsoft SQL Server 2019 data backend with PowerBI and SSRS providing visualiation and reporting. The security is through Active Directory and allows for both public and secure data and dashboards to be presented depending on the role of the user. Data visualizations are currently created in both PowerBI and SSRS and routed through the API layer to manage secured access. The API architecture has recently been created and may require some updates to initial assumptions as usage grows while still maintaining support for existing applications.

Objectives of this CEP:
The MITI project will migrate GEMS from an in-house designed and architected datawarehouse structure to a CEDS aligned structure. As part of the migration the current API layer will be updated to utilize the new CEDS data structure and expanded to provide a more robust abstraction of the underlying structure. The updated API structure will be able to provide access to JSON structured data elements for use by researchers. The project will be architected, built and supported by OPI staff with the assistance of contracted staff augmentation to help us bootstrap the effort. In addition to OPI staff there is an open source community providing resources that may be integrated into our efforts while some of our work may also be provided to the open source community to assist other similar efforts being carried out in other states. We hope to explore additional functionalities that may be enabled through the API layer including the feasibility of self-service data marts for research goals.

MT E-RTR.docx

Leave a Reply