Business Intelligence Analyst


Category: Business Process Management
Location: Vancouver, British Columbia
Title: Business Intelligence Analyst
Job ID: 13456
Job Status: Full Time Regular

Job Summary

You are a Business Intelligence 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 to support their business growth within Canada and US.

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


• Communicate requirements and business rules with business users and transform them into technical specifications
• Create complex analytic queries on large data sets, Design reports and dashboards
• Develop vendor and client exports that meet specifications, provide business users the data required for metrics and analysis
• Develop and maintain data warehouse and associated ETL processes
• Perform testing on packages, reports and exports to ensure exceptional quality
• Monitor jobs and transfer queues to ensure they are functioning as expected
• Manage change requests
• 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 or related experience
• Advanced practical knowledge of business intelligence concepts and solutions, including use of external data
• Solid business acumen and ethics to assess business intelligence requirements and priorities in the context of differing agendas or conflicting objectives; ability to coordinate multiple requests and prioritize accordingly
• Advanced understanding of IT systems, databases, and data management including data quality
• Hands-on experience with relational and dimensional databases design and administration required
• Excellent skills in Data Integration and Data transformations required
• MCTS or MCITP in SQL server 2008R2 + would be an asset
• Excellent skills in T-SQL Development of queries, views, stored procedures etc. (MS SQL Server 2008R2 or +) required
• MS Reporting Services (SSRS) experience, including development of complex reports, required
• MS Analysis Services (SSAS) experience, for complex cube reporting solutions, desired
• MS Office
• Experience utilizing MS Integration Services (SSIS), including development of full DW ETL Solutions, required
• Related skills in BI tools such as Power BI, basic .NET (VB.Net or C#) would be an advantage

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 5/3/2017 4:47:51 PM