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

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
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

Comprehensive total rewards package highlighting competitive salary and bonus structures
Minimum 3 weeks of vacation
Flexible benefits plan to meet the needs of you and your family
Flexibility to work in-office, virtually or a combination of both
Generous company matched pension and share purchase programs
Opportunity to give back to communities in which we work, live and serve
Career growth and learning & development opportunities to develop your skills
And much more …

Systems Analyst II – Data Analysis, Migration

Key skills