Data Analytics Coordinator

PRPA; Prince Rupert; On-site; CAD 76,000 - 96,000; Full time

Job summary

A regional port authority in British Columbia is seeking a Data Analytics Coordinator to support data management processes. Responsibilities include ensuring data integrity, maintaining reports, and training staff on reporting tools. Candidates should have 3-5 years of relevant experience and strong analytical skills. This full-time role offers a competitive salary range of $76,166 to $95,208.

Benefits

Inclusive work culture

Professional development opportunities

Qualifications

• 3-5 years of experience in data-related roles.
• Experience with reporting tools and software.
• Knowledge of relational database structures.

Responsibilities

• Act as primary data steward for all data forms.
• Load data assets into data warehouses.
• Support and maintain the data warehouse.
• Train staff in end user reporting tools.

Skills

Adobe Analytics

Data Analytics

SQL

Attribution Modeling

Power BI

R

Regression Analysis

Data Visualization

Tableau

Data Mining

SAS

Analytics

Education

College diploma in Analytics

Computer Science

Data Science

Statistics

Mathematics

Information Technology

Tools

Power BI

Informatica

SSRS

SSIS

Safe FME

MS Office

ArcGIS

Job description

Position Summary

The Data Analytics Coordinator plays a supporting role as a steward of PRPAs data warehouses from data ingestion through to the creation and maintenance of reports. They are responsible for ensuring the quality and integrity of data used for various activities from infrastructure planning to business development.

Position Accountabilities

• PRPAs primary data steward for all forms of data including geospatial (GIS) data which support day-to-day operations at PRPA.
• Load data assets into PRPAs data warehouses following best practices.
• Support and maintain PRPAs data warehouse.
• Maintenance of reports and dashboards.
• Training of PRPA staff in end user reporting tools available for accessing PRPAs data.

Working Conditions

Works predominantly in an office environment.

Regular full-time position (37.5 hours per week). Regular working hours are Mondays to Fridays 8:00 AM to 4:30 PM with 1 hour unpaid lunch break.

Job Specifications

Formal Education

• College diploma in Analytics Computer Science Data Science Statistics Mathematics or Information Technology.

Related Experience

• Three to five years experience in the industry.

Other Requirements

• Experience with reporting tools and software including SSRS PowerBI Informatica.
• Experience with SSIS or other data ingestion and transformation tools.
• Experience using Safe FME for processing geospatial data.
• Experience with report writing organizing and presenting data in support of decision making.
• Demonstrates statistical and empirical analytical skills
• Knowledge of relational database structures theories principles and practices is an asset.
• Knowledge of ETL methodologies T-SQL and ArcGIS is an asset.
• Familiar with the transportation and logistics industry.
• Demonstrates ability to learn new skills and acquire industry knowledge.
• Good spoken and written communication skills.
• Strong problem solving and organizational skills.
• Accuracy and attention to detail with an analytical eye.
• Superior judgment and tact in dealing with sensitive issues and confidential information.
• Demonstrates ability to manage multiple projects concurrently and to effectively handle changing priorities.
• Enthusiastic and self-motivated. Works well individually as well as in a team environment.
• Creative and intuitive thinker.
• Demonstrates commitment to the Ports Vision.
• Resilient. Embraces change and thrives on change.
• Proficient in MS Office especially Microsoft Word Excel Visio and PowerPoint; some exposure to MS Access and Project.
• Able to obtain security clearance under Transport Canadas Security Clearance Program.
• Possess a valid Class 5 Drivers Licence.

The base salary range for this role is $76166.00 to $95208.00

Equity Diversity Inclusion and Belonging are at the heart of PRPAs culture and play a vital role in our growth strategy. We are committed to ensuring that everyone feels a sense of belonging and can contribute to their maximum potential. Our differences are the reason great things happen here. If you are an applicant in need of accommodations or special assistance throughout the interview process please submit a request by email

Individuals of Indigenous descent are strongly encouraged to apply.

Required Experience

Key Skills

Adobe Analytics,Data Analytics,SQL,Attribution Modeling,Power BI,R,Regression Analysis,Data Visualization,Tableau,Data Mining,SAS,Analytics

Employment Type : Full-Time

Experience : years

Vacancy : 1

Monthly Salary: 76166 - 95208