Data Analyst 1 / Analyste de données 1 (12036)

Location: Toronto, ON M, Canada
Date Posted: 26-06-2018
Description:
In this role, as a key member of our client Health team, you will be joining a growing team of Analysts transforming & converting health data for Canadian doctors to a client EMR (Electronic Medical Record). This is an exciting opportunity to leverage your experience and skillet within an innovative and collaborative environment. Your work will be crucial to the success of the EMR platform within client Health! 

As part of the team, you’ll be responsible for: 
• 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 
• Validating transformation with the client 
• Planning and performing final transformation 
• 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 
• Tracking issues, communicating project status, and managing project risk 

Functional Skills: 
• 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 

Technical Knowledge: 
• SQL/TSQL 
• Data Transformation Scripting and Mapping (ex. XML, XSL/XPath) 
• Familiarity with databases such as MSSQL, Oracle, MySQL, etc 
• Linux and Groovy an asset 
• Scripting (ex. Python) or development (ex. Java/C#) 

Great to Have 
• Agile & Project Management skills 
• Medical experience or clinical workflow as asset 
• Awareness of data migration standards

Must have skills: (please at least 3 skills/exp):
1. BASH/Linux scripting or equivalent
2. XML/XSLT experience
3. SQL

Nice to have skills: (please at least 3 skills/exp):
1. Java/C# programming experience
2. Agile & Project Management skills
3. Medical experience or clinic workflo  
or
this job portal is powered by CATS