Oracle Analytics Senior Consultant / Consultant
Job Type: Permanent
Work Model: Hybrid
Reference code: 128686
Primary Location: Toronto, ON
All Available Locations: Toronto, ON
Our Purpose
At Deloitte, we are driven to inspire and help our people, organization, communities, and country to thrive. Our Purpose is to build a better future by accelerating and expanding access to knowledge. Purpose defines who we are and gives us reason to exist as an organization.
By living our Purpose, we will make an impact that matters.
- Learn from deep subject matter experts through mentoring and on the job coaching
- Leverage the Deloitte CPA Advantage program, a comprehensive support program for CPA modules and the CFE.
- Be encouraged to deepen your technical skills…whatever those may be.
- Build your leadership skills at Deloitte University.
- Have many careers in one Firm.
- Partner with clients to solve their most complex problems
- Enjoy flexible, proactive, and practical benefits that foster a culture of well-being and connectedness.
- Enjoy My Benefit Dollars - a flexible benefit to support your physical, financial and emotional well-being.
- Experience a firm where wellness matters.
- Experience MyFlex and an agile work environment where work is what you do not where you do it
- Experience MyFlex where reduced hours or seasonal work allows you to meet your personal goals.
- Build a network of colleagues for life
- Have an impact that matters through pro bono and significant volunteer opportunities.
- Be empowered to lead and have impact with clients, our communities and in the office.
- Be expected to share your ideas and to make them a reality.
- Be part of a firm that leads the way and pushes themselves to look like contemporary Canada.
- Grow your network and your knowledge by joining one of our many Employee Resource Groups.
--
What will your typical day look like?
• Lead and manage Oracle Analytics Cloud (OAC) implementations and projects.
• Design, develop, and maintain data warehousing solutions using leading database technologies such as Oracle, DB2, and SQL Server.
• Utilize ETL tools, specifically Oracle Data Integrator (ODI), to extract, transform, and load data.
• Implement and manage Fusion Data Intelligence (FDI) solutions.
• Collaborate with clients to understand their business requirements and translate them into technical solutions.
• Develop and maintain Business Intelligence solutions, including DW/DM schemas, ETL processes, business/semantic modeling, subject areas, reports, and dashboards.
• Manage all aspects of the analytics project life cycle, including discovery, design, build, test, and deploy phases.
• Provide expertise in Oracle ERP Cloud and ensure seamless integration with analytics solutions.
• Apply thorough knowledge of data warehousing theory, including relational and multi-dimensional OLAP.
About the team
The Oracle Analytics Senior Consultant/Consultant plays a crucial role in Oracle Analytics projects, focusing on the design, implementation, and deployment of analytics solutions using Oracle Analytics Cloud (OAC) and related technologies such as Autonomous Data Warehouse (ADW), Oracle Data Integrator (ODI), and Oracle Cloud Infrastructure (OCI). The candidate is expected to have comprehensive experience in the entire analytics development process, including working with ERP and operational data sources, designing and building Data Warehouse/Data Mart relational OLAP schemas, creating ETL routines, configuring and deploying OAC, managing OAC security, and developing reports and dashboards. Additionally, they should be adept at testing, performing migrations, and training users.
The ideal candidate should also possess experience with Oracle's Fusion Data Intelligence (FDI) platform, including provisioning, setting up, validating data, creating data augmentations, modifying metadata, and developing custom data integrations and structures. Familiarity with out-of-the-box FDI content for financials, human capital management, and supply chain management is essential. Furthermore, the candidate should have functional business experience in key areas such as accounting, supply chain, and human resource management, preferably with experience supporting Oracle ERP Cloud functions. They should be skilled in business analysis, requirements gathering, and managing business expectations, making them well-suited to support organizations deploying Oracle Analytics.
Enough about us, let's talk about you
You are someone who has:
• Post-secondary degree from accredited University or equivalent, preferably in Computer Science or Engineering.
• Experience with Oracle ERP Cloud
• 2+ years of experience with leading database technologies (Oracle, DB2, SQL Server), Data Warehousing , Oracle Analytics Cloud (OAC), ETL tools (ODI)
• 1+ years of experience with Fusion Data Intelligence (FDI)
• Thorough knowledge of Data Warehousing theory, including Relational and Multi-Dimensional OLAP
• Experience with all aspects of Business Intelligence: DW/DM schemas, ETL, Business/Semantic Modeling, Subject Areas, Reports & Dashboards
• Experience with all aspects of the analytics project life cycle: Discovery, Design, Build, Test, Deploy
Recommended:
• Experience with OBIEE (Oracle Business Intelligence Enterprise Edition), Oracle BI Financial Applications, Oracle BI Procurement / Order Management Applications, Oracle OLAP
• Experience with Essbase, Microsoft SQL Server DB, Unix/Linux, other BI solutions (MicroStrategy, Cognos, BOBJ)
• Experience with Agile development methodologies
• Experience with Business Process Analysis
• Understanding of standard Business Functions (GL, AR, AP, Order Management, HR, etc.)
• Experience working in several industries (Financial, Insurance, etc.) in a consulting environment.
Total Rewards
The salary range for this position is $72,000 - $138,000, and individuals may be eligible to participate in our bonus program. Deloitte is fair and competitive when it comes to the salaries of our people. We regularly benchmark across a variety of positions, industries, sectors, targets, and levels. Our approach is grounded on recognizing people's unique strengths and contributions and rewarding the value that they deliver.
Our Total Rewards Package extends well beyond traditional compensation and benefit programs and is designed to recognize employee contributions, encourage personal wellness, and support firm growth. Along with a competitive base salary and variable pay opportunities, we offer a wide array of initiatives that differentiate us as a people-first organization. Some representative examples include: $4,000 per year for mental health support benefits, a $1,300 flexible benefit spending account, 38+ days off (including 10 firm-wide closures known as "Deloitte Days"), flexible work arrangements and a hybrid work structure.
Our promise to our people: Deloitte is where potential comes to life.
Be yourself, and more.
We are a group of talented people who want to learn, gain experience, and develop skills. Wherever you are in your career, we want you to advance.
You shape how we make impact.
Diverse perspectives and life experiences make us better. Whoever you are and wherever you're from, we want you to feel like you belong here. We provide flexible working options to support you and how you can contribute.
Be the leader you want to be
Some guide teams, some change culture, some build essential expertise. We offer opportunities and experiences that support your continuing growth as a leader.
Have as many careers as you want.
We are uniquely able to offer you new challenges and roles - and prepare you for them. We bring together people with unique experiences and talents, and we are the place to develop a lasting network of friends, peers, and mentors.
The next step is yours
At Deloitte, we are all about doing business inclusively - that starts with having diverse colleagues of all abilities. Deloitte encourages applications from all qualified candidates who represent the full diversity of communities across Canada. This includes, but is not limited to, people with disabilities, candidates from Indigenous communities, and candidates from the Black community in support of living our values, creating a culture of Diversity Equity and Inclusion and our commitment to our AccessAbility Action Plan, Reconciliation Action Plan and the BlackNorth Initiative.
We encourage you to connect with us at accessiblecareers@deloitte.ca if you require an accommodation for the recruitment process (including alternate formats of materials, accessible meeting rooms or other accommodations) or indigenouscareers@deloitte.ca for any questions relating to careers for Indigenous peoples at Deloitte (First Nations, Inuit, Métis).
By applying to this job you will be assessed against the Deloitte Global Talent Standards. We've designed these standards to provide our clients with a consistent and exceptional Deloitte experience globally.
Deloitte Canada has 20 offices with representation across most of the country. We acknowledge that Deloitte offices stand on traditional, treaty, and unceded territories in what is now known as Canada. We recognize that Indigenous Peoples have been the caretakers of this land since time immemorial, nurturing its resources and preserving its natural beauty. We acknowledge this land is still home to many First Nations, Inuit, and Métis Peoples, who continue to maintain their deep connection to the land and its sacred teachings. We humbly acknowledge that we are all Treaty people, and we commit to fostering a relationship of respect, collaboration, and stewardship with Indigenous communities in our shared goal of reconciliation and environmental sustainability.