Systems Analyst II - Data Analysis and Migration

Description

Join our team

Do you thrive in a fast-paced, team centric environment? Are you a detailed-oriented individual who loves solving problems by leveraging creative solutions?  Do you want to be in a space where your knowledge and experience are used and fostered? Read on as this is the job for you!

As a key member of the TELUS Health team, you will be joining a growing team of Analysts in transforming and converting health data for Canadian physicians on a TELUS EMR (Electronic Medical Record) platform.  This exciting opportunity will allow you to leverage your experience and skillset within an innovative and collaborative environment while performing meaningful work that is crucial to the success of our TELUS Health EMR platforms.

Here’s how

As part of the team, you’ll be responsible for:

• 
  

  Extracting data from various source systems and data stores by performing light business coding (ex. Java, Python, C#, etc.)

  
  


• 
  

  Connecting with our customers to conduct requirement gathering and performing data validations

  
  


• 
  

  Mapping and transforming data using various techniques (ex. XSLT, MapForce, scripting, etc.) based on customer input and requirements

  
  


• 
  

  Performing ad-hoc queries (ex. SQL, LINQ, etc.) and reports to analyse customer data before and after migration

  
  


• 
  

  Planning and performing go-live transformation and  validation to ensure no data is lost or corrupted

  
  


• 
  

  Executing production data migrations (requires occasional evening/weekend work)

  
  


• 
  

  Collaboration with various teams across the business to identify roadblocks and resolve issues,  to ensure timely completion for each project

  
  


• 
  

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

  
  


• 
  

  Tracking issues, communicating project status, and managing project risk

  
  

What You Bring

Required Experience

• Graduation from a post-secondary institution with a Diploma specializing in related technologies


• 1 year minimum experience working on data transformation, development, or school related projects

Technical Knowledge

• 
  

  SQL/TSQL

  
  


• 
  

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

  
  


• 
  

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

  
  


• 
  

  Scripting (ex. Python/Groovy) or development (ex. Java/C#)

  
  


• 
  

  Linux/Unix and Groovy an asset

  
  


• 
  

  MapForce an asset

  
  

Functional Skills

• 
  

  Detail oriented 

  
  


• 
  

  Avid problem solver

  
  


• 
  

  Ability to communicate both verbally and written in English, French is an asset

  
  


• 
  

  Ability to multi-task and manage numerous concurrent projects 

  
  


• 
  

  Strong analysis and problem solving skills with the ability to identify root cause 

  
  


• 
  

  Ability to communicate in an effective and respectful manner with customers and fellow team members 

  
  


• 
  

  Self-directed in completing project-based work

  
  

Great to Have

• 
  

  Agile & Project Management skills

  
  


• 
  

  Understanding of Network Infrastructure

  
  


• 
  

  Electronic Medical Records (EMR), Medical or clinical workflow experience

  
  


• 
  

  Experience with HL7, CoPD and CDS/CMS XML standards

  
  


• 
  

  Experience with the Atlassian tool suite (ex. Jira, Bitbucket, Confluence)