Job Description

Trigyn has a contractual opportunity for a .Net Developer. This resource will work remotely for our client. Job Responsibilities: 1.Review the ICT standards and policies provided by the client for the applicable software such as Microsoft Azure Cloud, Internet Information Services, .Net and SQL in order to develop a compatible client Public Service Awards web platform. 2.Review, cleanse, and integrate client data from 2003-2015 and 2017-2022, stored in SQL databases, along with data from 2023-2025 in Excel. Convert the Excel files into dataflows or load them into a SQL database as needed to create unified datasets optimized for visualization and analysis. 3.Revamp the Public Service Innovation Hub that highlights client Public Service Awards initiatives and use PowerBI to connect the unique datasets to the Public Service Innovation Hub and enable informative interactive reporting of the client data. 4.Incorporate filter and search functionality into the Public Service Innovation Hub to highlight how client initiatives link to the Sustainable Development Goals (SDGs) and other client classifications i.e. regional grouping, economic grouping, and other topics that will be useful for research and analysis, 5.Incorporate a mechanism in the Public Service Innovation platform to ensure data is accessible, embeddable, and can be extracted by the user and downloaded in Excel or CSV, for research and analysis. 6.Demonstrate the revamped Public Service Innovation Hub to client and once accepted deploy to client servers on self-managed Microsoft Azure Cloud. 7.Conduct web application testing once deployed to client servers to ensure functionality including testing cross browser compatibility, testing for responsiveness, functionality testing, check for broken links, ensure security, cookie testing etc. 8.Work with guidance from Strategic Planning and Communication Services (SPCS), to conduct a user acceptance test, client can conduct the security test and the Department of Global Communications (DGC) can conduct the review of the look and feel of the site to make sure it conforms to client web standards; Ensure correct implementation of client information security standards and procedures, including client security testing and review of the development site, and remediation of any issues found. client IT security procedures must be followed, and code deliverable acceptance is subject to passing the client security tests. Any issues pertaining to the consultant s work which are identified by the client security test and DGC s branding test must be resolved by the developer. 9.Conduct complete hand-over and user training sessions to relevant staff members on how to manage the Public Service Innovation Hub. 10.Draft a how-to-guide manual, detailing the steps on how to manage the Public Service Innovation Hub to ensure continuity following the conclusion of the assignment. Expected outputs and delivery dates 1.A Proposal of a design solution for the new Public Service Innovation Hub based on the User Requirements and Specifications agreed in consultation with client ICT standards and policies. 2.A new database with integrated client data from 2017 - 2024 as well as unique datasets for visualization and analysis. 3.A mock-up design of the Public Service Innovation Hub in line with the user requirements and specifications agreed in consultation with client and in line with work assignment 3 - 5. 4.A new responsive, user-friendly, informative and interactive Public Service Innovation Hub that incorporates interactive data visualizations, filter and search functionality as mentioned in work assignment 4 and a mechanism on the Public Service Innovation Hub that ensures datasets are accessible, embeddable, and downloadable in Excel, CSV, and PDF formats for research and analysis, in line with work assignment 4 - 6. 5.A demonstration of the newly revamped Public Service Innovation Hub and once accepted deployment to the client servers on Microsoft Azure Cloud. 6.User acceptance testing that ensures functionality including cross browser compatibility, responsiveness and functionality, checking for broken links, ensuring security, cookie testing, etc. 7.A newly revamped Public Service Innovation Hub approved by client as meeting all necessary web and security standards. 8.Hand-over and user training sessions to relevant staff members on how to manage the Public Service Innovation Hub. 9.A how-to-guide manual, detailing the steps on how to manage the Public Service Innovation Hub to ensure continuity following the conclusion of the assignment. Performance indicators The performance of the consultant will be measured by the following indicators: Quality and comprehensiveness of the deliverables Timeliness of submissions of the expected outputs in line with the substantive requirements of the present TOR and in line with requests from the immediate supervisor Quality of analysis, recommendations, or conclusions in reports Comprehensiveness and clarity of briefing and materials Regular and predictable information sharing and updates on progress shared with the supervisor and other relevant parties Compliance with client style guidelines and accessibility standards Receptive/responsive to feedback from client and key stakeholders. Qualifications Bachelor s degree in information systems, Computer Science, SQL Development, Web Development or a related field is required. At least 7 years of professional experience professional experience in the field of information technology or related area, including SQL development, web development, optimising database performance, relational databases and interaction data visualizations. At least 7 years of C# experience is required. Extensive professional experience in developing interactive visualizations and dashboards (using complex SQL queries or related skills) is required. Proven experience with linking Power BI to databases is required. Experience working with an international organization. Strong communication skills in English (verbal and written) are essential.