RQ09624 - Sr. Business Intelligence Specialist
On-siteToronto, Ontario, Canada
Toronto, Ontario, CanadaOn-siteFull TimeSenior LevelMedium
Full TimeSenior LevelMedium
Job Summary
Design, develop, and implement web applications using Oracle APEX, translating technical specifications into tested code for data-driven programs. Resolve and troubleshoot software package issues during implementation, conversion, and migration while conducting unit tests. Write complex procedures, views, and scripts to perform data de-normalization, extraction, transformation, and loading. Conduct technical evaluations, gap analyses, and query optimizations across relational databases and cloud technologies. Perform detailed programming and report specifications for application configuration and integration capabilities.
Required Qualifications
- Must work 3 days onsite and 2 days remote
- Come into the office 4 days per week
- Come into the office 5 days per week
- 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
Desired Qualifications
- Public sector experience
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.