Category: Information Technology
Location: Vancouver, British Columbia
Business Analyst - Reporting
Job ID: 13201
Job Status: Full Time Regular
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
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, British Columbia