Telus Senior Data Analyst I - THFS in ON, Canada

Position Overview:

Our Data Team is looking for keen individuals to join a growing team of Analysts transforming & converting health data for Canadian doctors to a TELUS EMR (Electronic Medical Record). As part of the team, you’ll be responsible for:

  • Understanding the client’s workflows and requirements

  • Configuring and customizing mapping templates

  • Validating transformation with the client

  • Planning and performing final transformation

  • Tracking issues, communicating project status, and managing project risk


  • Extract data from various source systems and data stores by performing light business coding (Java/.NET, scripting, etc.)

  • Meet with clients to conduct requirements gathering and perform validation in-person and over teleconference

  • Map and transform data using various techniques (XSLT, SSIS, MapForce, etc.) based on client input and requirements

  • Perform ad-hoc queries (SQL, LINQ, etc.) and reports to analyst client data before and after migration

  • Load data into target system and perform validation to ensure no data is lost or corrupted

  • Work with various teams to identify roadblocks, resolve issues, track go-live dates and ensure timely completion for each project

  • Documenting details of projects in Salesforce/Jira and complete cleanup tasks

  • Execute production data migrations (requires occasional evening/weekend work)

  • Contribute to on-going development and refinement of data migration tools and processes

  • Apply lessons to future projects and continuously improve the migration process

Required Knowledge:


  • Data Transformation Scripting and Mapping (XML, XSL/XPath)

  • Familiarity with databases such as MSSQL, Oracle, MySQL, etc

  • Agile & Project Management skills

  • Requirements gathering and documentation

  • Scripting (Python) or development (Java/C#)

  • Awareness of data migration standards

  • Medical experience or clinical workflow as asset

Required Skills & Abilities:

  • Avid problem solver

  • Ability to speak and write in English, French is an asset

  • Ability to analyse problems and identify root cause

  • Ability to perform validation with clients and complete User Acceptance Testing (UAT) for each physician

  • Ability to communicate effectively with physicians and other clinic staff to manage their expectations

  • Ability to be self-directed in completing project-based work

  • Ability to track issues on multiple concurrent projects

Required Experience:

  • 5 years minimum experience working on data transformation or development projects

Who is TELUS?

We're a high-performing team of individuals who collectively make TELUS one of the leading telecommunications companies in Canada. Our competitive consumer offerings include wireline, wireless, internet and Optik TV™. We also deliver a compelling range of products and services for small, medium and large businesses; and have carved out a leadership position in the health, energy, finance and public sector markets with innovative industry specific solutions.

TELUS Health is an IT leader in Canada that focuses on the health sector. Our mission is to improve the way information is being used along the continuum of care to better the health of citizens in Canada and in selected countries.

The TELUS team is as diverse as the society we live in and the customers we serve. We're also passionate about creating success for our customers, our shareholders, our communities and our team. And we do so by living theTELUS valuesand delivering on ourCustomers First commitments.

Do you share our passion?

At TELUS,youcreate future friendly® possibilities.

At TELUS, we are committed to diversity and equitable access to employment opportunities based on ability.

Disclaimer:In accordance with the TELUS Health Solutions Data Center Security Policy, as a condition of employment, all personnel whose job functions require they work at a Data Center and/or have access to detailed knowledge of technology related to client service delivery, are subject to a Personnel Security Screening conducted through the Government of Canada.


Title: Senior Data Analyst I - THFS

Location: CAN-ON-Ottawa

Requisition ID: ROL02596-16

Other Locations: CA-ON-Markham, CA-ON-Cambridge, CA-BC-Kelowna, CA-BC-Surrey, CA-BC-Vancouver