Junior Data Analyst

This job posting is no longer active.

Division: Telecommunications
Location: Vancouver, BC, Canada
Job ID: 18181
Job Status: Full Time Regular


Job Description

Job Status
Full Time Regular

Job Summary
You are a Junior Data Analyst with knowledge of file system, SQL, Microsoft BI tools and Office suite. You will be responsible for retrieving and manipulating business sources data coming from the versatile locations Share Point, Google Drive, E-Mail and so on) in number of different formats (Excel, CSV, TXT and others), performing tasks related to developing reports, dashboards, vendor exports, data warehousing and other solutions using the Microsoft SQL Server platform within the Ledcor Technical Services Business Intelligence Team. Our team is growing rapidly and operates closely with telecommunications clients supporting telecommunications growth within the US and Canada.

Join the Ledcor Technical Services team in Vancouver, BC or Calgary, AB today!

  • Communicate sources data with vendors, clients and business users
  • Retrieve source data from locations and systems on schedule in time for processing
  • Monitor submissions of source extracts when it's third party responsibility
  • Make basic massaging of data in the sources when needed before submitting for processing
  • Create basic data handling queries on large data sets, help in design reports and dashboards
  • Take part in developing vendor and client exports
  • Maintain data warehouse and associated ETL processes, keep track of execution
  • Monitor jobs and transfer queues to ensure they are functioning as expected
  • Manage source changes, communicate to team members in timely manner for making adjustments to processing solutions
  • Create and maintain documentation for data retrieval
  • Research and innovate new of data retrieval, analyze and bring forth ideas for continuous improvement

  • Some previous experience up to 2 years in a data quality/data integrity role, new graduates are welcome
  • Diploma or degree in Computer Science or related experience
  • MCTS or MCITP in SQL server 2016+ would be an asset
  • Proven hands on skills in T-SQL Development of queries, views, stored procedures etc. (MS SQL Server 2008R2 or +) required
  • Working knowledge of Microsoft Office suite of products required
  • MS BI tools Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS) knowledge desirable
  • Related academic or hands-on experience in BI tools such as Power BI, basic .NET (VB.Net or C#), R would be an advantage
  • Excellent communication skills
  • Ability to coordinate multiple requests and prioritize accordingly

Work Conditions
  • Office-based position

Ledcor Technical Services (LTS) designs, builds, and maintains wireline or wireless networks that span North America and beyond. We are a proven leader and innovator in telecommunications network construction, maintenance, and service installation and repair.

But when you work for Ledcor, your experience will go far beyond the project. Do you want a career that means more? Join our True Blue team now!

Ledcor is an equal-opportunity employer. We are committed to a policy of non-discrimination in all of our employment practices. We welcome and encourage applications from all qualified individuals, regardless of race, gender, disability or any other identifying characteristic.

Date Posted