Programmer/Software Developer, Level 2

Programmer / Software Developer, Level 2

On behalf of our client Procom is seeking a Programmer / Software Developer, Level 2.

Tasks

The Contractor’s resource will perform tasks in support of Business Intelligence development projects. These tasks may include but are not limited to the following :

• Responsible for full-cycle application development including database design, application coding, testing, and reporting.
• This includes delivering data-driven dashboards to support business decisions.
• Work is carried out primarily using, Oracle Application Express (APEX), JavaScript, Python, and Tableau Software, including, but not limited to, the following tasks :
• a. Design, develop, and maintain web-based applications using Oracle APEX, JavaScript, Python, HTML, and CSS, ensuring functionality, usability, and alignment with business objectives;
• b. Implement front-end and back-end application features, integrating RESTful APIs and web services to enable dynamic content delivery and system interoperability;
• c. Design and model relational database schemas to support application logic and business requirements, including the creation of tables, views, indexes, and constraints;
• d. Write efficient and maintainable SQL queries involving complex joins, aggregate functions, subqueries, and set operations to support reporting and application functionality;
• e. Develop and conduct unit, integration, and user acceptance tests to verify the accuracy, performance, and security of applications prior to release;
• f. Troubleshoot, debug, and resolve issues across the application stack, ensuring optimal performance, scalability, and reliability of delivered solutions;
• g. Create and maintain interactive dashboards and visual analytics using Tableau Software, transforming raw data into meaningful insights for stakeholders;
• h. Document application workflows, technical architecture, database structures, and development procedures to support long-term maintenance and team collaboration;

i. Mentor junior developers by conducting code reviews, offering technical guidance, and facilitating skill development through pair programming or training sessions; and

j. Collaborate closely with business analysts, QA teams, and project stakeholders to gather requirements, validate solutions, and deliver high-quality products on time and within scope.

Must Have

• Must clearly demonstrate that the proposed resource has a minimum of 5 years of combined experience in the past 10 years performing the tasks listed in the SOW as an Application Developer for both web applications and dashboards.
• Must demonstrate that the proposed resource has experience a minimum of 6 months of combined experience in the past 5 years using Oracle APEX, SQL, and Tableau in the context of developing full stack web application and Tableau Dashboards.

Duration :   12 Months +

Location :   Onsite, Ottawa

Security Clearance :   Secret Clearance