Consultant, Data - Oakville, Canada - BDO

BDO

Verified Company

Oakville, Canada

3 days ago

Posted by:

Sophia Lee

beBee Recruiter

Description

Putting people first, every day
BDO is a firm built on a foundation of positive relationships with our people and our clients. Each day, our professionals provide exceptional service, helping clients with advice and insight they can trust.

In turn, we offer an award-winning environment that fosters a people-first culture with a high priority on your personal and professional growth.

Your Opportunity

BDO Digital is looking for a new grad
Data Analytics Consultant/ Data Engineer to join our growing client-facing team on a full-time permanent basis.

The individual will own the following 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 industryspecific 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 realtime 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 largescale 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, factbased decisions
Remain up to date of development technologies, both current and future in order to deliver stateoftheart Analytics solutions for our customers

How do we define success for your role?

You demonstrate BDO's core values through all aspect of your work: Integrity, Respect and Collaboration You understand your client

- 's industry, challenges, and opportunities; client describe you as positive, professional, and delivering high quality work

You identify, recommend, and are focused on effective service delivery to your clients
You share in an inclusive and engaging work environment that develops, retains & attracts talent
You actively participate in the adoption of digital tools and strategies to drive an innovative workplace
You grow your expertise through learning and professional development.

Your experience and education

Postsecondary education in engineering or computer science or equivalent work experience
Good experience working with Azure Databricks, Azure Data Factory and Azure Data Lake
Strong attention to the quality of work delivered (attention to detail)
Able to adapt quickly to changing client requirements

Preferably, you also have:

Experience with the Microsoft SQL Server Analytics stack including: Core SQL, SSIS, SSRS, SSAS,
Programming experience in Python
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
Experience using the Apache Hadoop ecosystem (Spark, Data Lake, Hive, HDFS, Impala) to tackle "big data" problems
Exposure to data science, machine learning or statistics
Some experience using Docker Knowledge of ETL, ELT, Lambda and Kappa data architectures

Why BDO?
Our people-first approach to talent has earned us a spot among Canada's Top 100 Employers for 2024.

This recognition is a milestone we're thrilled to add to our collection of awards for both experienced and student talent experiences.

Our firm is committed to providing an environment where you can be successful in the following ways:

We enable you to engage with how we change and evolve, being a key contributor to the success and growth of BDO in Canada.
We help you become a better professional within our services, industries, and markets with extensive opportunities for learning and development.
We support your achievement of personal goals outside of the office and making an impact on your community.

Giving back adds up:
Where company meets community. BDO is actively involved in our communities by supporting local charity initiatives. We support staff wi