Logo of Huzzle

Consultant, Data & Analytics (January, May, September 2025)

image

BDO

Sep 11, 2024

  • Job
    Full-time
    Entry Level
  • Data
    Engineering
  • Vancouver
  • Quick Apply

AI generated summary

  • You need post-secondary education in engineering/computer science, experience with Azure tools, Python programming, and strong attention to detail. Big data and SQL skills are a plus.
  • You will engage with clients, implement analytics solutions, design data models, enhance data efficiency, clean and transform data, develop architectures, and create data visualizations for informed decision-making.

Requirements

  • Post-secondary education in engineering or computer science or equivalent work experience
  • Good experience working with Azure Databricks, Azure Data Factory and Azure Data Lake
  • Programming experience in Python
  • Strong attention to the quality of work delivered (attention to detail)
  • Able to adapt quickly to changing client requirements
  • The following are considered an asset:
  • Experience using the Apache Hadoop ecosystem (Spark, Data Lake, Hive, HDFS, Impala) to tackle "big data" problems
  • Knowledge of ETL, ELT, Lambda and Kappa data architectures
  • Experience with the Microsoft SQL Server Analytics stack including: Core SQL, SSIS, SSRS, SSAS
  • Experience working with SQL and NoSQL databases
  • Knowledge of Continuous Integration and Source Control systems (e.g. Gradle, Maven, Bamboo, TeamCity, Git)
  • Data Visualization experience in Power BI, Tableau, or similar
  • Exposure to data science, machine learning or statistics
  • Some experience using Docker

Responsibilities

  • - Play an integral role in our delivery practice as we execute on enterprise level client engagements through our various industry specializations
  • - Engage directly with clients and drive the implementation and successful end user experience of analytics solutions; execute on engagements and collaborate with the client and delivery team to ensure that any applicable milestones and deliverables are met on time and on budget
  • - Design and develop industry-specific data models for client projects in industries such as Natural Resources, Finance, Manufacturing and Distribution, and Retail
  • - Work with other engineers to enhance data models and improve data query efficiency; create complex data queries to facilitate ad hoc and exploratory analytics
  • - Build real-time data capture and transformation functionality across all products and build out technology stack for Business Intelligence and Data Warehouse
  • - Clean data: review for data inconsistencies and identify opportunities to improve data collection process; Wrangle/Munge data: transform or map data from one raw data form into another format with the intent of making it more appropriate and valuable for analytics
  • - Develop, construct, test and maintain architectures such as databases and large-scale data processing systems; design, construct, install, test and maintain highly scalable data management systems
  • - Employ a variety of languages and tools (e.g. scripting languages) to marry systems together
  • - Build or recommend data visualization tools and business intelligence tools such as interactive dashboards and automated reports, to enable leaders to make swift, fact-based decisions
  • - Remain up to date of development technologies, both current and future in order to deliver state-of-the-art Analytics solutions for our customers

FAQs

What is the job title for this position?

The job title is Consultant, Data & Analytics.

What educational background is required for this role?

A post-secondary education in engineering or computer science, or equivalent work experience is required.

Which programming language should candidates be proficient in?

Candidates should have programming experience in Python.

What are the expected start dates for this position?

The expected start dates are January, May, and September 2025.

What data tools are mentioned as important for this role?

Important data tools include Azure Databricks, Azure Data Factory, and Azure Data Lake, along with knowledge of the Apache Hadoop ecosystem, SQL databases, and data visualization tools such as Power BI or Tableau.

Is experience with data visualization considered an asset?

Yes, experience with data visualization tools like Power BI, Tableau, or similar is considered an asset.

What is the pay range for this job?

The pay range for this position is $67,000 to $101,000 per annum.

What can candidates expect from the company culture at BDO?

Candidates can expect a people-first culture that prioritizes personal and professional growth, inclusivity, and community involvement.

Does BDO offer support for personal goals outside of work?

Yes, BDO supports the achievement of personal goals outside of the office and encourages making an impact in the community.

Are flexible benefits offered from the start of employment?

Yes, competitive total cash compensation and flexible benefits are provided from day one.

What is BDO's commitment to diversity and inclusion?

BDO is committed to a workplace culture of respect, inclusion, and diversity, recognizing and celebrating the differences among employees.

What does the hybrid work model at BDO entail?

The hybrid work model allows personnel to work some of their time in the office, at client sites, and virtually, based on flexible arrangements.

What ethical standards are in place at BDO?

BDO's Code of Conduct sets clear standards for how business is conducted, reflecting shared values and guiding principles to maintain trust and make ethical decisions.

Accounting
Industry
10,001+
Employees
1963
Founded Year

Mission & Purpose

BDO is the leading provider of professional services within the mid-tier of our profession. We are proud to deliver seamless client service, from 1658 offices in 167 countries, across the world. Our 91K+ professionals continuously transform our approach by embracing future-oriented technology and focusing on quality. Strategic decisions and investments made in recent years have further equipped the organisation with the global infrastructure and innovative solutions needed to deliver long-term value for our clients.