Senior Business Intelligence Developer

Join us in enabling trade through Canada's largest port

The Vancouver Fraser Port Authority is an arm’s-length federal agency responsible for the shared stewardship of the lands and waters that make up the Port of Vancouver, Canada’s largest port. Our mandate, as outlined in the Canada Marine Act, is to enable Canada’s trade objectives on behalf of all Canadians, ensuring the safe movement of goods through the Port of Vancouver while protecting the environment and considering local communities.

As an organization with a significant impact on communities and businesses across Canada, the Vancouver Fraser Port Authority is dedicated to diversity, inclusion, and sustainability. We strive to create a workplace that mirrors the richness of our community, empowering all employees to achieve their full potential.

• Develops, enhances and supports complex data solutions, tools and automations, partnering closely within internal business units and technical teams.
• Involves working on multiple enterprise initiatives focused on the implementation of new or enhanced systems, solutions and processes.
• Translates business requirements into technical specifications and implements secure, scalable, and compliant data and analytics solutions.

• Work with business stakeholders and internally across the department to scope initiatives, including functional and technical deliverables, cost estimates, resource requirements, and expected benefits.
• Participate in analysis, planning and development of detailed roadmaps for modernization of the VFPA enterprise data platform.
• Share technical ownership of the organization's data platform with team members, supporting both on‑premises and cloud‑based environments.
• Work closely within the information services team and as part of project teams to design, implement, and test data models and data management systems.
• Contribute to the definition and evolution of enterprise data models, standards, and metadata practices to support consistent, governed use of data across the organization.
• Implement and maintain technical data quality checks and validation controls within the modern data platform, analytical models, and semantic layers, based on defined business rules and governance standards.
• Support the full analytics lifecycle including data design, data integration, validation and reporting using Agile or Waterfall methodologies.
• Ensure upgrades and changes to VFPA’s data infrastructure align with IS department’s service level standard.
• Research new technologies, implement proofs of concept/MVPs and make recommendations to build scalable and supportable infrastructure, as appropriate.
• Perform root‑cause analysis for service interruption and develop solutions to complex technical problems and take appropriate urgent actions.
• Support the maintenance of data infrastructure: database servers, performance monitoring, security configuration, database software (SQL): installation, patching, upgrades, decommissioning etc.
• Assist with data backup, recovery, high availability and disaster recovery procedures to ensure business continuity.
• Support implementation of and maintain database security controls (user access, roles and privileges) and audit functions.
• Plan storage and capacity to support ingestion of raw data sources into the VFPA data platform.
• Monitor, tune and optimise database and report performance.
• Create or modify database objects, procedures, and scripts as needed to support analytics and data platform requirements.
• Provide secondary support for database platform administration in collaboration with the primary DBA to ensure operational continuity.
• Configure, perform and monitor system level backups and restore via enterprise level backup solutions.
• Participate in the analysis, and documentation of analytics solutions from design through to implementation.
• Create, enhance and document conceptual, logical and physical database models to support analytics, reporting and enterprise data consistency.
• Develop data transformation and integration logic to deliver curated datasets and analytical models that support enterprise reporting and decision‑making.
• Implement automated…