RQ09624 - Sr. Business Intelligence Specialist

RQ09624 - Sr. Business Intelligence Specialist Downtown, Toronto (St. Clair W) Hybrid - - Candidate MUST work 3 days onsite and 2 days remote. Starting October 20, resources are expected to come into the office 4 days per week. Starting January 5, resources are expected to come into the office 5 days per week. This is subject to change based on manager discretion. Contract 2-3 months, possible extension Design, develop, and implement web applications using Oracle APEX. Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests. Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations. Must-Haves: Experience with advanced APEX features like interactive reports, charts, and dynamic actions Writing complex procedures/pkg/views/scripts to do data de-normalization, data extraction, data transformation(cleansing), and data loading. Relational databases (Oracle, SQL Server), data modelling (relational & dimensional) , advanced SQL , query optimization, data replication, administration Cloud technologies (Azure, Google, AWS) Conducting technical evaluation and assessment of options for technical design issues, application figuration aspects and integration capabilities, related tools and utilities, gap analysis of integration components to technical requirements/specifications/documentation Technical analysis, Oracle APEX program code, detailed programming and reports specifications, program design, writing and /or generating code, and conducting unit tests Nice-to-Have: Public sector experience