Junior Data Engineer – Toronto

We’re looking for a curious, intelligent, and proactive cloud focused Junior Data Engineer to help us tackle complex data analytics projects end-to-end in Microsoft Azure.

Company Overview

The NMG Group is a global advisory and intermediary firm focused exclusively in financial services. Established in 1992, NMG has enjoyed steady expansion internationally. We have clients across the world with our most established businesses in Australia, South Africa, Asia, the UK and Canada and a growing presence in the US and Europe. Our main offices are in Sydney, Singapore, Kuala Lumpur, Johannesburg, Cape Town, London, Toronto and New York.

At NMG Consulting we are a nimble firm of 160 people focusing exclusively on the Insurance, Reinsurance, Wealth Management and Asset Management Industries. Our advisory model uniquely integrates Consulting, Insights and Analytics. Located globally, we are a diverse team of talented and experienced individuals, partnering with industry leaders to provide deep and powerful insights and knowledge.

We are constantly evolving and the range of work that we do rapidly challenges and expands our peoples’ knowledge. Our flat, team-based structures encourage participation from all experience levels – everyone is encouraged to contribute, regardless of their role. We advocate hearing different points of view, collaboration and constructive debate.

Summary Statement

Within this role you will work with various teams based in multiple locations globally to deliver solutions on the Azure Cloud using core Azure cloud tools and languages. You’re committed to delivering high quality interactions and you’re excited about making a big impact on a small team.

Role

Junior Data Engineer

Location:

Toronto

Key Responsibilities

  • Data Engineering (Development) - collaborate with functional group leaders and engineering team(s) to gather and analyse business and technical data requirement needs and understand how data is collected, analysed & utilised to design and implement the management, monitoring, security, and privacy of data using the full stack of Azure data services. SQL server development and coding complex functions, stored procedures, triggers, indexes, queries or ad-hoc analyses, and views (using T-SQL). Design and develop Azure Data Factory ETL, ELT or ingestion processes that will transform a variety of cloud data sources into SQL databases or data warehouses or integration solutions, including REST APIs. Design and build Microsoft Azure functions to optimize data extractions and ensure data validation, cleansing and merging forms a critical part of data processing solutions. Adhere to or recommend best practice cloud services, database or data engineering, and identity standards and perform team and 3rd party code reviews in accordance with such standards.

  • Testing - perform unit, integration, or system testing (automated or otherwise) on all developed code and / or system components through stringent routines and procedures to ensure accuracy and solution integrity and that solutions run smoothly with optimum operational efficiency, ensuring all solutions will meet SLAs & performance criteria. Provide feedback on solutions’ usability, features, and design based on results of testing. High focus on performing your own data reconciliations during testing phases to ensure that your development work has been completed successfully prior to deployments for user acceptance testing.

  • Production Support and Maintenance - provide support by applying critical thinking skills to troubleshoot, determine the cause of failure, and quickly restore failed components or processes when they occur; Diagnose and remediate resource contention issues and failures in application logs. Participate in an on-call rotation with the team when necessary, specifically related to customer-facing digital cloud solutions. Conduct monthly reviews of incidents and service requests, analyse, and recommend improvement in quality and work with the internal team on identifying pain points in existing Azure deployments and configuration and ways to alleviate them. Monitor connections and locks and performance of SQL instances to track historical peak load on servers and proactively working on performance tuning and writing queries for front-end applications. Manage, monitor, and ensure the security and privacy of data to satisfy business needs.

  • Legacy Migrations: Migrating on-prem SQL instances and legacy SAS datasets to Azure SQL in development, test, or production environments. Our values: Living the NMG values of Collaboration, Curiosity, Go for It, and Make it Count in all that you do.

  • Documentation: Originate and maintain documentation for new and existing solutions throughout the solutioning life cycle, covering all applicable functional areas, such as bugs, change requests, operational policies and procedures, solution designs, integration and API specifications, technical specifications, test plans and test results, production control (and / or job scheduling), security administration, TSQL code and logical as well as physical data models where applicable.

Competencies, Qualifications & Experience

  • Knowledge of BI and reporting using SQL, SSAS, Tabular Models, Python and Power BI. Modern version control Git, SVN, TFS, etc.

  • Azure DevOps & Infrastructure automation for continuous integration and continuous deployment of technical solutions leveraging Azure Services and Features.

  • Experience in multiple or all Azure components, including API Management, Event Hubs, Functions, Resource Manager Templates, Storage Accounts, Notifications Hub, Key Vault, Data Lake Stores, Data Lake Analytics, Synapse Analytics, Databricks, HD Insight similar cloud infrastructure.

  • Working experience in hardening cloud production environments for error handling, fault tolerance, self-healing, monitoring and incident alerting and recovery.

  • Non-Technical Skills - Ability to interact with business as well as technical teams. Strong communication and client management skills. Ability to learn and respond quickly to the fast-changing business environment. Ability to multitask and excellent interpersonal skills. Apply learned lessons into future solution considerations. Analytical mindset with a problem-solving approach. Ability to work in an agile environment with a focus on continuous improvement. Resourcefulness and troubleshooting aptitude. Self-motivated and eager to learn. A team player.

Related Job Openings

Scroll to Top