Data Analytics Coordinator

POSITION SUMMARYAs a Data Analytics Coordinator, you will support Prince Rupert Port Authority staff and act as a steward of PRPA's data warehouses, from data ingestion through to the creation and maintenance of reports. You will be responsible for ensuring the quality and integrity of data used for various activities from infrastructure planning to business development. POSITION ACCOUNTABILITIESAct as PRPA's primary data steward for all forms of data, including geospatial (GIS) data, which support day-to-day operations at PRPA.Load data assets into PRPA's data warehouses following best practices.Support and maintain PRPA's data warehouse.Maintain internal reports and dashboards.Provide training to internal staff in end user reporting tools available for accessing PRPA's data.JOB SPECIFICATIONSFormal EducationCollege Diploma in Analytics, Computer Science, Data Science, Statistics, Mathematics, or Information Technology.Related Experience Three to five years' experience in industry Other RequirementsExperience 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 makingDemonstrates statistical and empirical analytical skillsKnowledge of relational database structures, theories, principles, and practices is an assetKnowledge of ETL methodologies, T-SQL and ArcGIS is an assetFamiliar with the transportation and logistics industryDemonstrates ability to learn new skills and acquire industry knowledge Good spoken and written communication skillsStrong problem solving and organizational skillsAccuracy and attention to detail, with an analytical eyeSuperior 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 Port's 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.Provide proof of full vaccination against COVID-19 with a vaccine approved by Health Canada.Able to obtain security clearance under Transport Canada's Security Clearance Program.Possess a valid Class 5 Driver's License.We provide reasonable accommodation for candidates during the recruitment and selection process and for PRPA employees, as necessary. If you require support applying for this position, please contact us at careers@rupertport.comIndividuals of Indigenous descent are strongly encouraged to apply. Maritime Transportation