Position: Oracle BI Specialist
Location: Toronto/Onsite
Job ID#: RQ10632
Duration: 9 Months
Overview
The Oracle BI Specialist is responsible for validating business requirements, delivering Oracle Analytics Cloud (OAC) solutions, producing technical and functional documentation, and supporting change management, integration, testing, and knowledge transfer activities. The role requires strong experience with Oracle BI technologies, analytics solution design, endâuser engagement, and compliance with Ontario Government and Ministry Client/OPS standards, guidelines, and procedures.
Responsibilities
Solution Design & Implementation
- Validate business requirements and update functional and technical design documents.
- Implementation of Oracle Analytics Cloud; build custom ETL scripts and optimize BI solution for endâuser functionality.
- Prepare impact assessment documentation and recommended approach for engaging and training end users in adoption of Oracle BI functionality.
- Prepare implementation plan and effort estimates.
- Complete design documents and assist in testing solution.
- Update semantic layer; modify or build new reports and dashboards and underlying data structures and related components.
- Build, test and migrate reports and related objects.
- Work with other team members to execute recommended/approved approach.
- Complete work and achieve milestones within assigned deadlines.
Knowledge Transfer & Support
- Complete knowledge transfer to OPS team.
- Provide knowledge training to OPS resources that will maintain the solution post goâlive.
- Provide knowledge and skill transfer to a designated Ministry Client/OPS Organization staff.
Compliance & Governance
- Notify the Ministry Client/OPS Organization project manager in writing of any issues or other material concerns related to the Assignment Deliverables as soon as he/she becomes aware of them.
- Submit Deliverables for the Ministry Client/OPS Organization approval as they are completed.
- Comply with the Ontario Government and the Ministry Client/OPS Organization security procedures and practices.
- Comply with the Ontario Government and the Ministry Client/OPS Organization architecture/technology standards and best practices.
- Comply with the Ontario Government and the Ministry Client/OPS Organization Conflict of Interest and Confidentiality Guidelines.
- Comply with the Ontario Government I&IT Directive, Operational Policy on the I&IT Project Gateway Process, and other applicable Guidelines, Standards and Procedures.
Experience and Skill Set Requirements
Must Have
- Multiple years of experience in configuring, developing, and roll out of Oracle Analytics Cloud features in a large implementation.
- Experience leading Change Management, developing and delivering endâuser engagement deliverables (training courses, user guides, material) and working with end users to ensure ease of adoption, training and transitioning end users to analytics.
- Extensive experience with OAC and features to lead/recommend solutions for multiple stakeholders.
Desirable / Required Skills â 60%
- Experience with conducting workshops and requirementsâgathering sessions with clients on planning, budgeting, and forecasting initiatives.
- Experience with OBIEE, OAS, OAC, ODI, SQL, APEX, and related object design, build and implementation.
- Experience in building BI and Analytics applications optimized for highâperformance, highâvolume reporting and analytics functions on premise and cloud.
- Experience with data integration, data cleansing, and integration with OBIEE.
- Skilled in Software Development Life cycle and can apply in understanding, building, and maintaining custom solutions.
- Inâdepth experience in providing and documenting impact assessment for application changes, upgrades, and patches.
- Experience in eliciting, documenting, and validating business requirements.
- Experience in Software Testing, Quality Assurance and Documentation.
- Experience in building custom extensions and retrofit of code.
- Experience in technical guidance on Oracle EâBusiness Suite custom development.
- Demonstrated experience with Data reconciliation.
- Experience in training, transition and change management activities.
- Excellent communications skills, both written and verbal: clear, concise, and jargonâfree.
- Ability to communicate concepts and details to clients, development.
General Skills â 40%
- Experience with analyzing data in source systems to identify data cleanliness issues (e.g., missing values, duplicate meanings, invalid data).
- Experience with developing feedback processes to fix corrupt data in source systems.
- Experience with developing data extraction, transformation, and load programs (daily and initial load) on a wide range of data repositories (relational and multiâdimensional).
- Experience with developing, implementing, and maintaining schedule/dependency logic for ETL scripts.
- Experience with developing monitoring and error notification processes to ensure data is updated as designed.
- Experience with developing automation extraction, cleansing and load scripts.
- Experience generating research models and reports (scheduled and adâhoc).
- Proven troubleshooting and analytical experience.
- Experience in process decomposition/mapping and business process reâengineering and complex data models using UML.
- Experience in the use of development tools and business reâengineering software.
- Experience in developing enterprise architecture deliverables (business, logical, physical models) based on Enterprise Application Processes and Modeling methodology and guidelines.
- A team player with a track record for meeting deadlines.
About Symbiotic Digital.
Symbiotic Digital provides the IT Experts you need that solve problems and get things done. See what the top 2% in their field can do for you. (Symbiotic Digital is a division of Symbiotic Group Inc.)
We serve customers in two ways, we provide:
1. Digital Experts: IT Consulting expertise. Bright Minds That Produce Proven Results
2. Recruitment: Find The Right People You Need
Serving IT & Business leaders, Symbiotic Digital provides a business system that enable us to provide the Expert Technical staff needed to solve challenging business and IT problems. IT leaders in the most reputable organizations in Canada have relied on Symbiotic Digital to help them staff difficult assignments with proven Experts uniquely evaluated by our proven QMS\- Quality Management System Staff Development Model. We are a 100% Indigenous owned company.
Learn more online at https://www.symbioticgroup.com/home\-sd/.
Please submit your most recent resume to: [email protected]
View All Jobs online at: https://www.symbioticgroup.com/view\-jobs/
Activate JobCopilot
