Top 4 desired skill sets:
- Experience with C# -- 5 years
- Experience with HandleBar and Django templating – 2 years
- Experience with Angular 4.0 or above – 2 years
- Experience with MS Azure Cloud - 2 years
Candidate requirements:
- 3 years of Python programming experience, at least 2 of which Python 3 must have been the primary language
- Experience with JavaScript Object Notation (JSON) -- 5 years
- Experience with Angular 4.0 or above – 2 years
- Experience with JavaScript -- 2 years
- Experience with C# -- 5 years
- Experience with MS SQL (or Oracle) – 5 years
- Experience with HandleBar and Django templating – 2 years
- Experience with MS Azure Cloud - 2 years
- Experience with Python and Pandas for Python - 2 years
- Experience with Python in Microsoft Visual Studio – 2 years
Distribution of work:
- (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
Description of work
Client 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 back-up 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