Senior BI Specialist – LanceSoft

Job Title: Senior BI Specialist

Location: Toronto, ON

Job Description: Title : Senior BI Specialist
Location: Toronto, ON (Hybrid)
Duration: 4+ Months Contract with 8+ Months possible extension.Job Description:
Deliverables:
A Senior Business Intelligence Specialist FFS resource is needed for the IFIS in Cloud Project for the below deliverables:

• Validate business requirements and update functional and technical design documents.
• Retrofit custom ETL scripts and optimize OBIEE solution based on business requirements.
• Prepare impact assessment documentations and recommended approach for meeting client requirements.
• Prepare Implementation plan and effort estimates.
• Work with other team members to execute recommended/approved approach.
• Complete fit/gap and solution options for Oracle business intelligence solutions including OBIEE, and Oracle Analytics Cloud.
• Complete prototypes, set-up DEV environments and document optimal deployment solutions
• Complete design documents.
• Document and complete testing of OBIEE BAR files, data, reports, and visualizations.
• Identify the PII (Personally identifiable information) in databases, develop scripts, perform Data Masking of PII, and validate the same.

Oracle Business Intelligence Enterprise Edition 12 Expertise (75%)

• Experience with OBIEE, 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.
• Experience with data integration, data cleansing, and integration with OBIEE, and OAC.
• Skilled in Software Development Life cycle and can apply in understanding, building and maintaining custom solutions.
• 5+ year of primary focus on developing customer solutions using Oracle’s analytics offerings: Oracle Analytics Cloud, Data Visualization, Fusion Analytics for Warehouse, OBIEE, OBIA, Machine Learning and Autonomous Data warehouse (ADW)
• 5+ year of extensive, hands on, end to end implementation/Operate experience using OAC/OBIEE Integration/Reporting tools – Analysis & Dashboards, Oracle Data Integrator
• Good knowledge of OBIA pre-built content and experience with customizing/extending OBIA pre-built content of different modules
• Solid understanding of Business Intelligence (BI) tools, Data Warehouse (DW), Oracle Data Integrator (ODI), Data Modelling concepts and SQL/PLSQL.
• Good knowledge of Oracle Applications – Oracle E-business Suite or Oracle ERP, Oracle HCM (the Oracle cloud SaaS offering) is preferable.
• Good knowledge of Database, Cloud Concepts, Autonomous Data warehouse (ADW), Data Integration is an added advantage.
• Hands-on experience in data masking of PII (Personally identifiable information)
• Good understanding of ITIL based Operate/managed services processes and methodologies including experience in incident management, minor enhancements, service request management, application upgrades, etc. Hands on experience in Hypercare support would also be beneficial.

Oracle E-business Suite R12 Expertise (15%)

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

Change Management, Training and Transition (5%)

• Demonstrated experience with Data reconciliation.
• Experience in training, transition and change management activities.

Soft Skills (5%)

• Excellent communications skills, both written and verbal: clear, concise, and jargon-free.
• Ability to communicate concepts and details to clients, development.

Must have:

• Experience with OBIEE, 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.
• Experience with data integration, data cleansing, and integration with OBIEE, and OAC.
• 5+ year of primary focus on developing customer solutions using Oracle’s analytics offerings: Oracle Analytics Cloud, Data Visualization, Fusion Analytics for Warehouse, OBIEE, OBIA, Machine Learning and Autonomous Data warehouse (ADW)

Company Name: LanceSoft

Salary:

Apply for this job!