Business Intelligence Analyst

Website CanaDream

Company Overview

Pacific Coast Distribution Ltd. is a locally owned company, and a full-service logistics provider for asset-based freight transportation, logistics, long and short-term storage trailers and warehousing distribution services in BC and the Pacific Northwest

About the Role:

This position resides in Langley, British Columbia. Due unavailability of public transit in our area, it is mandatory that a successful candidate owns a personal vehicle.

The Business Intelligence Analyst requires at least 2 of experience in highly technical area of developing and maintaining SQL Server Integration Services (SSIS) packages to support Data warehouse extract, transform and load process (ETL). An essential prerequisite to fill this position is an expertise in designing and securing OLAP cubes, dashboards, other BI content.

Job Requirements:

·       Architect and implement leading edge solutions to develop, enhance and improve the BI solutions. Design, create, document and implement complex multidimensional cubes, reports and data visualization which deliver information via the web to end users.

·       Provide technical expertise in the development of the BI solutions by assessing client needs/requirements, reviewing technical options, determining software architecture and leading all levels of the solution development and deployment.

·       Develop and maintain SQL Server Integration Services (SSIS) packages to support Data warehouse extract, transform and load process (ETL).

·       Build and Maintain reports using SQL Server Reporting Services.

·       Develop and maintain SQL Server tables, views, stored procedures and functions.

·       Administer the SQL Server databases (data marts) including security, user permissions, performance and usage monitoring.

·       Design, develop and maintain OLAP cubes, dashboards and other BI content as required.

·       Providing complex ad hoc reporting, including predictive modelling, to support strategic and operational decision-making on implications of equipment and human resource utilization.

·       Write SQL code to extract and analyze data from multiple data sources.

·       Build queries and scripts/procedures to retrieve and aggregate data from multiple disparate sources into digestible and actionable formats

Skills & Qualifications:

·       Education, training, and experience equivalent to 6 semesters in a degree or diploma in Information Systems or Computer Science program from a recognized school, plus a minimum of two (2) years recent related work experience.

·       Expert knowledge and understanding of relational and multidimensional (OLAP) databases as well as proven knowledge and experience in working with SQL Server or Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), SharePoint.

·       Experience in the development and maintenance of popular BI platforms including Power BI and Tableau.

·       Ability to create and understand complex T-SQL and MDX queries and previous administrative experience setting up new users and monitoring performance.

·       Proficiency in scripting and computer programming foundations. Knowledge of web authoring technology such as Java Scripts, HTML, and ASP .NET, AJAX is also required. High level of expertise in Microsoft Office suite of applications.

·       Ability to apply machine learning and/or natural language processing (NLP) concepts is a bonus.

Company Overview:

Pacific Coast Distribution Ltd. is a locally owned company, and a full-service logistics provider for asset-based freight transportation, logistics, long and short-term storage trailers and warehousing distribution services in BC and the Pacific Northwest.

SPECIAL NOTES: THIS JOB IS SUPPLIED BY BEEZNESTS, SPECIAL CONDITIONS MAY APPLY.

Beeznests is building an exclusive database to help students get a paid internship/job. In the meantime, we have also been collaborating with the government program ICTC WIl digital, where they will pass on all the hiring opportunities to Beeznests directly. We will also refer the students from our database to hiring companies for any paid internship/job opportunities which will significantly increase the chances of your application getting accepted and reviewed by your desired companies.
Upload your resume or any other relevant file. Max. file size: 100 MB. Want a resume template? Check out https://isempower.com/student-resources/