Senior Business Intelligence Specialist

Source Code; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading technology firm in downtown Toronto is seeking a Senior Business Intelligence Specialist to design and implement web applications using Oracle APEX. The candidate will need to translate technical specifications into functioning applications while troubleshooting technical challenges. This hybrid position requires the candidate to work 3 days onsite and 2 days remotely, with expectations increasing from 4 to 5 days onsite as the project evolves. Strong expertise in advanced SQL and cloud technologies is crucial.

Qualifications

• Experience with advanced APEX features like interactive reports and dynamic actions.
• Strong skills in relational databases and data modelling.
• Proficiency in cloud technologies like Azure and AWS.

Responsibilities

• Design, develop, and implement web applications using Oracle APEX.
• Translate technical systems specifications into working applications.
• Troubleshoot technical problems during software operation.

Skills

Advanced APEX features

Relational databases (Oracle, SQL Server)

Data modelling (relational & dimensional)

Advanced SQL

Query optimization

Data replication

Cloud technologies (Azure, Google, AWS)

Technical analysis

Job description

RQ09624 - Sr. Business Intelligence Specialist

About the job 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.

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