Systems Analyst II – Data Analysis, Migration

Posted 3 days ago

Apply Now

Resume Score

Check how well your resume matches this job before you apply.

Sign in to check score

About the role

  • Systems Analyst II responsible for transforming and converting health data for Canadian physicians on TELUS EMR platform. Extracting, mapping, and validating data for migration to ensure accuracy.

Responsibilities

  • 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

Requirements

  • 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

Benefits

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

Job type

Full Time

Experience level

Junior

Salary

CA$57,000 - CA$105,000 per year

Degree requirement

Professional Certificate

Tech skills

GroovyJavaLinuxMySQLOraclePythonSQLUnix

Location requirements

OnsiteKelownaCanada

Report this job

Found something wrong with the page? Please let us know by submitting a report below.