Job summary:

Job description:

*** Webcam interview *** Long term contract  ***  While work will be performed remotely the candidate must reside in the state of Ohio and be willing to travel to Columbus to pick up their equipment.

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 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.  
• (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

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

Preferred qualifications: 

• Experience with MS Azure Cloud  - 2 years
• Experience with Angular 4.0 or above - 2 years
• Experience with Python and Pandas for Python - 2 years
• Experience with Python in Microsoft Visual Studio - 2 years

Required Skills

• Must have 3+ years of Python programming experience, at least 2 of which Python 3 must have been the primary programming language used.
• Experience with Angular 4.0 or above preferred
• Experience with MS Azure Cloud preferred
• Experience with JavaScript Object Notation (JSON) preferred
• Experience with Pandas for Python preferred

Contact the recruiter working on this position:

The recruiter working on this position is Mounika Lanka(Ravi Team)
His/her contact number is +(1) (703) 6468773
His/her contact email is mounika@msysinc.com

Our recruiters will be more than happy to help you to get this contract.