Sr. Business Intelligence Specialist

About the Role

RQ09624 - Sr. Business Intelligence Specialist

Location

Downtown, Toronto (St. Clair W)

Work Policy

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 Details

Contract 2-3 months, possible extension

Responsibilities

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

Requirements

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