Business Analyst - Reporting


Category: Information Technology
Location: Vancouver, British Columbia
Title: Business Analyst - Reporting
Job ID: 13201
Job Status: Full Time Regular

Job Summary

You are a Business Analyst with experience developing reports, dashboards, and applications using the Microsoft SQL Server platform. You will be responsible for reports, vendor exports, data warehousing tasks, and other data related tasks within the Ledcor Technical Services Team. Our team is growing rapidly and operates closely with telecommunications clients like Telus to support telecommunications growth within Western Canada.

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


• Maintain and enhance existing data warehouse, exports, and reports
• Create complex analytic queries on large data sets
• Develop vendor and client exports that meet provided specifications
• Develop and maintain the data warehouse and associated ETL processes
• Perform quality checks on reports and exports to ensure exceptional quality
• Monitor job and transfer queues to ensure they are functioning as expected
• Provide business users the data required for metrics and analysis
• Manage change requests
• Develop new SSRS packages to meet business needs
• Create and maintain documentation for all projects
• Research and develop new ways to improve existing functionality
• Proactively analyze and bring forth ideas for continuous improvement


• 2+ years of similar IT-related experience in a large-scale production environment; previous experience in the telecom industry would be an asset
• Diploma or degree in Computer Science
• MCTS or MCITP in SQL server 2014 / 2008 would be an asset
• Excellent skills in T-SQL Development using queries and stored Procedures (MS SQL Server 2008R2 or +) required
• Hands-on experience with relational and dimensional databases required
• MS Reporting Services (SSRS) experience, including development of complex reports, required
• MS Analysis Services (SSAS) experience, for complex cube reporting solutions, required
• Excellent skills in Data Integration and Data transformations required
• Experience utilizing MS Integration Services (SSIS), including development of full DW ETL Solutions, high preferred
• Related skills such as Power BI tools, basic .NET or C# 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.

Vancouver, BC
Vancouver, British Columbia

Date Posted 4/7/2017 2:51:43 PM