Programmer

Description:

• (40%) Build complex JSON-structured maps that define parameters to generate payment reports as an API response for internal and external users
• (20%) Compose HTML-structured templates that will be rendered with JSON data using Handlebars and Django Template Language.
• (15%) Perform unit, integration, and regression testing of report generation though API services supported by Django framework and Azure Functions.
• (15%) Provide coding support on Python-written API modules of new requirements or alterations of existing functionality.
• (10%) Elicit requirements for HTML template content and define specifications for JSON mapping parameters.

Skills & Number of years of Experience / Last Used

• Experience with Angular 4.0 or above – 2 years
• Experience with C# -- 5 years
• Experience with MS SQL (or Oracle) – 5 years
• Experience with JavaScript Object Notation (JSON) – 3 Years
• Experience with JavaScript -- 2 years
• Experience with HTML -- 2 years
• Experience with Handlebars.js templates – 1 year
• Experience with Angular 4.0 or above – 2 years
• Experience with MS Azure Cloud - 1 years
• Experience with Handlebars.js templates – 1 years

Description of the team the candidate will be working on:

The Department of Education calculates and processes approximately $8 billion of school funding annually. The data processing systems used are a mix of COBOL and SAS programs; running on an OpenVMS mainframe; reading from Oracle databases, SAS datasets, and flat files; and writing to SAS datasets and flat files. The Department seeks to modernize this data processing environment by reworking the system to utilize modern technologies, specifically replacing COBOL and SAS on OpenVMS with Python on Windows and SQL server databases. To this end, the Department seeks a senior programmer/system architect with significant Python 3 and C# expertise, in order to:

Design a new data reporting system to produce internal and public facing financial reports as well as backup calculation explanation reporting. Goals to improve over the legacy system include, but are not limited to:

• Leverage Angular 4.0 or above, Microsoft Azure cloud and SQL Server database technologies in
• creating new public-facing web reports that are more user friendly, can be downloaded into technologies like Excel or PDF format.
• Replace all COBOL and SAS generated web reports utilizing current ODE reporting tools (e.g. SoS HTML template and JSON data, JavaScript ( and HandleBar templating), Django Template Language, PowerBI)
• Assist with creating a front-end system for serving up to the public prior fiscal year legacy web reports stored in SQL server database.
• Produce business and operational reports, showing payment change tolerances and exception handling.
• Leverage the Microsoft Visual Studio IDE, Team Foundation Server and Microsoft DevOps for source
• control, release management, and system build.