Data Warehousing Analyst

Apply now »
Apply now

Apply for Job

Date: Jun 17, 2022

Location: Vancouver, British Columbia, C

Company: Deloitte

Job Type: Permanent 
Reference code: 106201     
Primary Location: Vancouver, British Columbia, Canada 
All Available Locations: Vancouver 


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.

Who We Are

This isn’t a place to have a simple desk job or fill a means to an end. This is the place to begin an exciting career that is built upon your energy and motivation to solve the bigger picture.  At Deloitte, within the Digital Operate practice, we are the direct representation of what it means to serve with integrity. The trust from our team, clients, regulators, and the public has been fostered on the heels of our ability to adapt quickly, harbor continuous improvement, and seek out new opportunities to reinvent the future.

We are the face of the Digital practice and from the moment you join, you will be supported by a team of mentors and colleagues that will show you the ropes, provide context, tools, and guidance every step of the way. From there, YOU are the determining factor to how far you will go - the sky’s the limit. The opportunities are endless when you stay hungry for the next challenge.

We are driven to inspire, driven to go to great lengths to help our people and community, and driven to understand what it means to have a client-first mentality all while knowing what it means to stand in the end user’s shoes. We seek those that are never going to let their light dim, those that will continuously push themselves to solve the toughest of problems, those that are willing to push the boundaries and those that can quickly adapt to constantly changing requirements. We believe that if you’re willing to learn, continue to push back against the odds, and maintain the right work ethic, we will be there every step of the way to lift you up and ensure you succeed.

About the team

About the team

Deloitte Digital's vision is simple. We empower our clients to re-imagine how they connect and engage with their customers. Our aim is to be a global leader in driving digital transformation using digital platforms. By redefining the customer's digital journey, clients can look forward to stronger brand loyalty, a better customer relationship, and a sales process so personal it feels effortless.

The Operate team within the Digital practice is the enabler for organizations to optimize their business performance and profitability all while implementing transformations that engage and activate customers through the customer journey. We help our clients solve complex business problems, improve performance, enhance shareholder value, drive sustainable growth, and create a competitive advantage.

Enough about us, let’s talk about you

As a Data Warehouse Analyst your responsibilities include the following:

  • Analyze business requirements to identify data source(s) and required data columns, gain functional understanding of the data
  • Create and manage data-related artifacts such as data flow diagrams and source-to-target mappings as part of requirements definition and analysis
  • Create and manage conceptual and logical data models as part of solution design
  • Collaborate with developers and QA team members to ensure a common understanding of the data requirements, data models and functional specs
  • Develop/analyze complex SQL queries and/or data pipelines
  • Work with clients to resolve their queries through assigned tickets
  • Provide regular updates on project status to project manager, including raising risks, issues and impediments in a timely manner
  • Collaborate effectively with both business and technical stakeholders and managing offshore team
  • Respond proactively to any data or requirement issues; take ownership of risks, issues and impediments as appropriate to resolve them in a timely manner

You are someone with:

  • 4-6 years of hands-on experience with data warehousing projects
  • Good understanding of data warehousing concepts
  • Hands-on experience with Informatica and OBIEE
  • Proficiency with SQL 
  • Experience working with post-production support for data warehouse including migrations, load monitoring and incident support

You might also have:

  • Hands on UNIX skills
  • Comfortable with Oracle database concepts to analyze performance issues


Our shared values

While our Purpose guides us and helps explain why we exist, our shared values describe the behaviour we expect from each other at the firm.

They provide common ground to unite us across cultures and geographies. They help us to earn the trust and respect of our stakeholders. We all commit to living by these shared values, to stay true to the principles they represent, and to honour the legacy from which they came. They are what sets us apart and makes us Deloitte.

Every day, we live our Purpose through the following five shared values:

  • Lead the way: Deloitte is not only leading the profession, but reinventing it for the future. We’re also committed to creating opportunity and leading the way to a more sustainable world.
  • Serve with integrity: Deloitte has earned the trust of employees, clients, regulators, and the public for 175 years. Upholding that trust is our single most important responsibility.
  • Take care of each other: We look out for one another and prioritize respect, fairness, development, and well-being.
  • Foster inclusion: We are at our best when we foster an inclusive culture and embrace diversity in all forms. We know this attracts top talent, enables innovation, and helps us deliver well-rounded client solutions.
  • Collaborate for measurable impact: We approach our work with a collaborative mind¬set, teaming across businesses, geographies, and skill sets to deliver tangible, measurable, attributable impact.

The next step is yours

Sound like The One Firm. For You? Apply by [insert date].

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 PlanReconciliation Action Plan and the BlackNorth Initiative.

We encourage you to connect with us at if you require an accommodation for the recruitment process (including alternate formats of materials, accessible meeting rooms or other accommodations). We’d love to hear from you!

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 30 offices with representation across most of the country. We acknowledge our offices reside on traditional, treaty and unceded territories as part of Turtle Island and is still home to many First Nations, Métis, and Inuit peoples. We are all Treaty people.

Job Segment: Data Warehouse, Data Analyst, ERP, Accounting, CPA, Technology, Data, Finance