logo

View all jobs

Data Analyst 2 / Analyste de données 2 (15240)

Toronto, ON
Description:
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
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
• Medical experience or clinical workflow as asset
• Experience with HL7, CoPD and CDS/CMS XML standards
• Experience with the Atlassian tool suite (ex. Jira, Bitbucket, Confluence)


Required Experience:
• Data Analyst 2
o Graduation from a post-secondary institution with a Degree specializing in related technologies
o 2+ years of experience working on data transformation or development projects
o 2+ years of working with SQL/TSQL
o 2+ years of working with XML and related tools (ex. XSL/XPath)
o 2+ years of working with a scripting language (ex. Bash/JavaScript/Python/Perl/etc.)

Must to have skills: 
• 1. 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



Nice to have skills
• 1. Agile & Project Management skills
• Understanding of Network Infrastructure
• Medical experience or clinical workflow as asset
• Experience with HL7, CoPD and CDS/CMS XML standards
• Experience with the Atlassian tool suite (ex. Jira, Bitbucket, Confluence)
Powered by