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
Principal AI Platform Engineer building GenAI infrastructure for PointClickCare, a healthcare technology company. Connecting AI systems to products and enabling AI - generated insights in agent workflows.
Transactional Revenue Intelligence & Systems Analyst building dashboards, decision systems, and campaigns for Koronet’s global marketplace platform. Turning customer data into scalable growth and product insights.
Senior Combat Systems Engineer supporting naval and military systems, cybersecurity, and ship design projects at BMT. Leading assessments, technical investigations, assurance reviews, and mentoring engineering teams.
Senior Systems Designer creating complex gameplay, economy, and progression systems for Blackbird Interactive's Unreal 5 sci - fi action game. Bridging design, art, and code while developing player - facing features and developer tools.
VP leading quality engineering, DevOps, and release management for Bankjoy’s digital banking platform. Building automation - first practices, release gates, and reliable infrastructure for regulated financial institutions.
Engineering co - op supporting Thales ship systems design, integration, commissioning, and production issue resolution. Working across Vancouver shipyards, customer, suppliers, and Ottawa engineering teams.
Senior software engineer building internal marketing, sales, and client - operations systems for Wrapbook’s AI production - finance platform. Developing Salesforce integrations, data pipelines, APIs, and AI - native workflows.
Data Systems Analyst building and validating BI reports for Sleep Country Canada/Dormez - vous?, a Canadian sleep products retailer. Documenting metrics, supporting UAT, and training business users on self - service reporting.