TELUS Corporation

Systems Analyst II - Data Analysis and Migration

TELUS Corporation$57K — $105K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Diploma in related technologies from a post-secondary institution.
  • Minimum 1 year experience in data transformation, development, or related school projects.
  • Proficient in SQL/TSQL and data transformation scripting.
  • Familiarity with databases such as MSSQL, Oracle, MySQL.
  • Experience with scripting languages like Python or Groovy is advantageous.

Responsibilities

  • Extract data from various systems using light coding techniques.
  • Gather requirements and validate data by liaising with customers.
  • Map and transform data based on customer specifications.
  • Run ad-hoc queries and generate reports to analyze customer data.
  • Plan and perform data migrations, ensuring data integrity and accuracy.
  • Collaborate with cross-functional teams to resolve project issues.
  • Track issues, update project status, and manage risks during project execution.

Benefits

  • Comprehensive rewards package with competitive salary and bonus opportunities.
  • Minimum of 3 weeks vacation and flexible benefits plan.
  • Work flexibility, including in-office, virtual, or hybrid options.
  • Generous matched pension and share purchase programs.
  • Career growth and professional development opportunities.
Full Job Description
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


What You Bring

Required Experience

  • 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


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


Salary Range: $57,000-$105,000

Performance Bonus or Sales Incentive Plan: 10%

Actual total compensation will be determined based on factors such as knowledge, skills, performance and experience. We encourage all qualified candidates to apply, even if the posted salary range doesn't match your expectations. We're open to discussing competitive compensation packages tailored to your experience level and expertise. TELUS offers rewarding benefits, which may vary per job function, such as:
  • Comprehensive total rewards package highlighting competitive salary and bonus structures, minimum 3 weeks of vacation, and flexible benefits plan to meet the needs of you and your family
  • Flexibility to work in-office, virtually or a combination of both, based on the role's requirements
  • 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: This is for a current vacancy

Disclaimer: In accordance with the TELUS Health Solutions Data Center Security Policy, as a condition of employment, all team members whose job functions require they work at a Data Center and/or have access to detailed knowledge of technology related to client service delivery, are subject to a Personnel Security Screening conducted through the Government of Canada.

Note for Quebec candidates: if knowledge of English is required for this position, it is because the team member will be asked, on a regular basis, to interact in English with external or internal parties or to use English applications or software as part of their tasks.

By applying to this role, you understand and agree that your information will be shared with the TELUS Group of Companies' Talent Acquisition team(s) and/or any leader(s) who will be part of the selection process.

Health

We're looking for clinicians, programmers, product developers, sales and marketing people, customer support, and everyone in between. If you have a penchant for turning information into better health outcomes, then we want you to help us develop, implement and manage the most innovative healthcare solutions possible.

About TELUS Corporation

TELUS Corporation is a Canadian telecommunications company that provides a wide range of communications products and services, including wireless and wireline voice and data services, internet access, television, and healthcare. The company is committed to sustainability and has set ambitious goals to reduce its environmental impact. TELUS Corporation is headquartered in Vancouver, British Columbia, and has operations in Canada and internationally. The company is focused on delivering exceptional customer service and has won numerous awards for its customer service and innovation.
Learn more about TELUS Corporation
Size
90,800 employees
Market Cap
$28 billion
Industry
Founded
1990
5 Year Trend
+5.8%
NASDAQ

Similar Jobs

More Jobs at TELUS Corporation

More Information Technology Jobs

Find similar Systems Analyst II - Data Analysis and Migration jobs: