Business Systems Analyst 2 / Analyste des systèmes d'entreprise 2 (11222)

Location: Toronto, ON
Date Posted: 12-12-2017
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 

Required 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 
- Agile & Project Management skills 
- Scripting (ex. Python) or development (ex. 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

Must have skills: (please at least 3 skills/exp):
1. SQL and Databases
2. EMR (Electronic Medical Record)
3. XML/Data

Nice to have skills: (please at least 3 skills/exp):
1. Scripting
2. Linux
3. Agile
or
this job portal is powered by CATS