Software Engineer (Oracle Hyperion Essbase – 1 Year Contract)

Requisition ID: 93154

Join the Global Community of Scotiabankers to help customers become better off.

The Team

The Data Models & Analytics team within Global Finance & Risk Technology (GFRT) provides analytics and support services for Global Finance Initiatives. The Data Models & Analytics team supports Financial Close Processes and provide Financial Data Management, Data Analysis, Data Quality and Data Governance services.

The Role

Oracle EPM (Hyperion Essbase) – Consultant with extensive experience in development, implementation, support of Hyperion Essbase Applications & scheduling Jobs in Autosys.

Some of the key accountabilities include:

• Hyperion Essbase (Linux Version 11.1.2.4): Hands-on experience with design/ development of Essbase Application.
• Deep understanding of ASO/BSO Application concepts.
• Hands on experience in writing Member Formulas, Calculation Script, Report Script, MDX, MAXL, Unix Shell scripting.
• Experience in writing complex Dimension build and load rules in Essbase and Cube partitioning.
• Security Setup: Creating groups/filters and users in Essbase.
• Hyperion Data Integration tools: Hyperion Shared Services, Workspace, Smart view, LCM etc.
• Automation/ Schedulers Tool: Scheduling Jobs in Autosys.
• Knowledge of ETL concepts, CDM, OBIEE and Oracle SQL is additional skill.

What You Will Bring to Succeed

• Requires expertise in areas of design, development, testing, security setup, Automation, migrations, version upgrades, Reporting.
• ETL Informatica, Oracle SQL, OBIEE Reporting and CDM knowledge.
• Building new servers which include installation, configuration and patching of Essbase components.
• Migration of artifacts from one application to another using LCM Creating Essbase Application ASO & BSO, Loading Dimension and Data using Rule file.
• Optimising Current process and memory tuning on server.
• Adhoc Requests and supporting users with SmartView/OBIEE reports related issues.
• Working with Oracle Support for creating and resolving Product related issues.
• Candidate with good understanding of Banking, Finance and Regulatory reports.
• Essbase Certifications.

The Workplace

• We are technology partners who help the business transform how our employees around the world work
• We have an inclusive and collaborative working environment that encourages creativity, curiosity, and celebrates success!
• You’ll get to work with and learn from diverse industry leaders, who have hailed from top technology companies around the world
• We foster an environment of innovation and continuous learning
• We care about our people, allowing them to design how they work to deliver amazing results
• We offer a competitive total rewards package, including a performance bonus, company matching programs (on pension & profit sharing), and generous vacation

Scotiabank

As Canada’s International Bank, we are a diverse and global team. We speak more than 100 languages with backgrounds from more than 120 countries. We value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know. If you require technical assistance please click here. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.

Is this Role not the Exact fit?

Sign up to stay in touch; we’ll let you know when we have new positions on the team.

Location(s):  Canada : Ontario : Toronto 

As Canada’s International Bank, we are a diverse and global team. We speak more than 100 languages with backgrounds from more than 120 countries. Our employees are committed to a superior customer experience and use the Bank’s six guiding sales practice principles to ensure they act with honesty and integrity.

At Scotiabank, we value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know. If you require technical assistance, please click here. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.