Data Engineer

Location/Region: Greater Toronto Area (home office based)

The Role

VetStrategy is undergoing an exciting digital transformation. Key to this is to improve the management of our core data sets, bringing data from disparate systems together to improve management information reporting, underpin AI initiatives and enrich the experience of our clients and patients.

Technically, the subject matter expert will be expected to fulfil many of the tasks traditionally covered by a DBA role in a cloud infrastructure environment. We primarily rely on Microsoft products, so experience of Microsoft SQL server and its variants in Azure will be central to the role.

In addition, acting as a data extraction liaison, the subject matter expert will be the technical authority accountable for working with 3rd party practice management vendors to support the PMS conversion program in ensuring data extraction occurs within the project timelines while performing data mapping and validation.

Responsibilities

· The Data Engineer will be a hands-on operational role working with various internal teams and external vendors to ensure data extraction, mapping and validation occurs as it relates to the PMS conversion program.

· The Data Engineer should also expect to spend time acting ‘hands on’ and will be expert at applying the technologies set out in the over-arching strategy.

· Additionally, as part of the wider technology team, the Data Engineer is expected to provide technical guidance to teams working with data extraction, storage, normalization, and neighbouring technologies, most notably Microsoft’s Power Platform and Azure infrastructure.

Background, Experience and Qualifications

This is a technically specialised role, and the role holder will be expert in:

· The administration of database systems, primarily Microsoft SQL Server but, additionally, MongoDB, MariaDB.

· Relevant technologies in Microsoft Azure, such as SQL Managed Instance, SQL Managed Database, Azure Data Factory, etc.

· The use of REST APIs, JSON and ETL technologies/protocols for moving data between systems.

· Some exposure to business intelligence tools, such as Microsoft PowerBI, would be helpful.

· Scripting tools and experience with programming/development in Visual Studio/C#.

Additionally, the role holder must be:

· Adept in the use of enterprise architecture and data modelling frameworks to develop artefacts that represent and support the management of a complex, divergent, data environment.

· Experienced in setting and driving delivery of a data strategy, considering business goals, technical merit and commercial impacts.

· Confident in delivering through Agile/Scrum as well as traditional waterfall frameworks.

· Experienced in championing the use of architecture and code repositories to ensure consistent working practice across all teams.

· Cognisant of, and responsive to, requirements to develop in line with information security best practice.

· Capable of interfacing the IT Infrastructure team to ensure non-functional requirements, such as performance, scalability, resilience and identity/access management, are effectively delivered in the end-to-end solution.

· Familiar with ITIL (change, incident and problem management) and comfortable with delivering in that framework.

· Comfortable with being the face of IT – working directly with Finance, Marketing and other business units – for the systems and services in scope.

· Ready to think internationally; is sensitive and responsive to the needs of business units across multiple jurisdictions, often with local issues and priorities.

Personal characteristics

· Excellent oral and written communication skills, with the ability to tune style and approach to create effective relationships with a diverse range of technical and non-technical stakeholders.

· Has natural technical gravitas; speaks with authority on complex issues and is regarded as a natural ‘thought leader’ by their peers.

· Is curious, with an open, questioning style with the confidence to challenge assumptions and ask “why?” constructively.

· Confident in dealing with uncertainty; can analyse and pick apart a disorganised environment, using risk and reward-based approaches to determining a strategic direction.

· Interested in and an active contributor to automation and continuous improvement, recognising that small changes as well as big-ticket projects create a real business benefit.

· Meticulous and accurate, maintaining documentation to a high standard.

· Strong organisational skills, with the ability to prioritise and manage a demanding portfolio of projects.

· A self-starter, decisive and able to work at pace, confident to prioritise, take ownership and make appropriate decisions to drive topics forward – commits and delivers.

Our Ideal Candidate possesses the following Cultural Competencies:

We are Relationship Focused!

• In every interaction with the hospitals, we build and maintain personal connections and trust. All relationships matter regardless of different levels, functions, cultures or geography.

We Collaborate!

• Different perspectives are encouraged as we look for the best way to do things. We collaborate with the hospitals and one another to ensure that all work is in the best interest of the hospital and takes into account the unique needs of each location. We are externally focused on our hospitals rather than only internally focused on our processes.

We Speak the Truth!

• We are honest and transparent. We can question or challenge without fear of negative repercussions. We support one another and take responsibility for ourselves.

We are Humble!

• We’re all in this together. There is no room for ego or hierarchy mentality here. We are unpretentious and approachable. We support and appreciate one another. We regularly seek feedback without defensiveness. We reflect on our activities and the impact we have on others.

We Take Care of the Rest!

• We view everything we do through the lens of the hospitals. We seek to understand first. Every decision we make is based on impact to patient care, client service, and hospitals teams. We do what’s best for the hospitals not just Home Office.

Job Types: Full-time, Permanent

Flexible Language Requirement:

• French not required

Schedule:

• 8 hour shift

Work Location: Hybrid remote in VAUGHAN, ON

Please Note :
nvalabs.org is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, nvalabs.org provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.