Data Analytics Senior Consultant / Senior Data Engineer – MS Azure & SQL Server Stack

Full Time December 24, 2021 Science, Technology, Engineering and Mathematics

Job Overview

Job title: Data Analytics Senior Consultant / Senior Data Engineer – MS Azure & SQL Server Stack

Job description: Data Analytics Senior Consultant / Senior Data Engineer – MS Azure & SQL Server Stack

Employer BDO Canada Location Ottawa, Ontario Salary To be determined Closing date Jan 19, 2022

Sector Function Contract Type Hours

Save job – Click to add the job to your shortlist

You need to or to save a job.

Your opportunity
We are looking for a Data Analytics Senior Consultant / Senior Data Engineer to join our growing client-facing Technology Consulting team on a full-time permanent or contract basis, with the ability to work remotely from anywhere in Canada. 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 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

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

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
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 firm is committed to providing an environment where you can be successful in the following ways:

We enable you to engage with the firm’s strategic plan, and be a key contributor to the success and growth of the firm.
We help you be the best professional you can be in our services, industries and markets.
Achieve your personal goals outside of the office and make an impact on your community.

Giving back, it adds up: Where company meets community. BDO is actively involved in our communities by supporting local charity initiatives. We support staff with local and national events where you will be given the opportunity to contribute to your community.

Total rewards that matter : We pay for performance with competitive total cash compensation that recognizes and rewards your contribution. We provide flexible benefits from day one, and a market leading personal time off policy. We are committed to supporting your overall wellness beyond working hours, and provide reimbursement for wellness initiatives that fit your lifestyle.

Everyone counts: We believe every employee should have the opportunity to participate and succeed. Through leadership by our Chief Inclusion and Diversity Officer, we are committed to a workplace culture of respect, inclusion, and diversity. We recognize and celebrate the valuable differences among each of us, including race, religious beliefs, physical or mental disabilities, age, place of origin, marital status, family status, gender or gender identity and sexual orientation. If you require accommodation to complete the application process, please contact us.

As a hybrid workplace, all BDO personnel are expected to spend some of their time working in the office, at the client and remotely unless accommodations or alternative work arrangements are in place. To protect the health and safety of our people, clients and communities, we require all partners and employees to be COVID-19 fully vaccinated in order to enter a BDO office. Individuals that cannot be fully vaccinated with a Health Canada approved vaccine due to medical reasons or another protected ground under Human Rights legislation may request an accommodation.

Share this job

Save jobClick to add the job to your shortlist

You need to or to save a job.

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Before you apply –
Turn on alerts for jobs like this!

We’ll send them straight to your inbox :

Email address required Other Marketing Communication

Yes, I’d like to receive emails from LocalWork.ca with helpful announcements of advertising specials, new features, notices, events, special offers and other important information that may be of interest to me.

Province required

When you create this job alert we will email you a selection of jobs matching your criteria. Our and apply to this service.

All emails will contain a link in the footer to enable you to unsubscribe at any time.

LocalWork.ca is a property of Metroland Media Group Ltd. 211 Prichard Rd. Unit #4 Hamilton, ON L8J 0G5,

To see our Privacy Policy, click

Create alert and continue to apply (This will open in a new window from which you will be automatically redirected to an external site after 5 seconds)

Company:

Expected salary:

Location: Ottawa, ON

Job date: Wed, 22 Dec 2021 08:54:00 GMT

Job Source: Careerjet.ca