Data Analyst 2 / Analyste de donnes 2 (12353)

Location: Toronto, ON, Canada
Date Posted: 12-09-2018
In this role, as a key member of our client 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:
• 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#)
 Our Client
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. Programming / Scripting experience 2 SQL, PL/SQL 3. Data Transformation Scripting and Mapping XML technologies 4. Ability to track issues on multiple concurrent projects 
Nice to have skills
: (please at least 3 skills/exp): 1. Healthcare experience (Understanding clinical workflows etc.) 2. Agile and project management skill 3. Awareness of data migrations standards 
this job portal is powered by CATS