Position Title: Data Solutions Developer (Database Admin)

Position Status: Full-Time Regular

Department: Human Resources and Corporate Services

Employee Group: Teamsters Local 31

Location: 4515 Central Boulevard, Burnaby

Salary Range/ Wage Rate: PG T31 $4,119.45 - $4,871.28 bi-weekly

Our Digital Strategy and Architecture team is seeking a Data Solutions Developer who will design, implement, and maintain secure database systems while developing innovative data solutions. Leveraging expertise in data pipelines, data science, complex data queries, and cloud storage, this role ensures efficient, integrated data management across platforms to support our strategic data initiatives.

You are: A collaborative team player and experienced in database administration and are data solutions developer skilled in database design, security, and performance optimization, with a strong foundation in data analytics, cloud-based solutions, and complex data queries.

This role:

• Designs, installs and maintains database systems and database objects and structures to ensure a high level of data availability and system security; develops database architecture; develops, maintains and communicates database and coding standards and quality assurance standards and procedures; plans and coordinates data migration between systems; and ensures efficient storage, retrieval and manipulation of data.

• Develops, implements and maintains data analytics solutions, including on premise and cloud data warehouse, data storage and data pipelines to facilitate efficient data flow and integration across various platforms and services.

• Develops, implements and maintains cloud based data solutions and architecture; implements advanced data replication and synchronization techniques; supports and enhances data science initiatives to ensure optimal performance and alignment with business strategies.

• Monitors and evaluates system performance; resolves technical issues; manages data security; and identifies and resolves data abnormalities to avoid system outages.

• Leads infrastructure and database projects; establishes project schedules and milestones; assigns tasks to team members and provides advice and guidance; monitors progress and performs follow up services as required.

• Collaborates and liaises with internal teams to deliver business technology solutions; assess and mitigates database related security risks and best practices for access controls, encryption and data masking; evaluates new database technologies; designs and implements database related security measures, including data encryption management; and maintains corporate database monitoring solutions.

• Researches, evaluates and recommends information technology solutions related to database and performance measurement tools, backup and recovery processes, system storage and data security and confidentiality; designs, implements and tests backup systems and policies and procedures for data and disaster recovery and data archiving; prepares and presents reports related to information technology and storage solutions as required.

• Provides guidance and assistance to infrastructure and applications staff; shares expertise and best practices in database administration and cloud data management; stays updated on industry trends and emerging technologies; makes recommendations for adoption and integration to existing systems; and oversees the work of consultants for compliance with corporate database and applications development standards as required.

• Performs related work as required.

To be successful, you have:

• Completion of a University degree in computer science, database administration, information technology or related discipline, supplemented by training in data analytic tools, data warehousing, database administration or data science plus considerable related experience; or an equivalent combination of training and experience.

• Thorough knowledge of the principles and techniques associated with database design, management and database security best practices.

• Thorough knowledge of the characteristics and capabilities of the organization’s computer hardware as it relates to the work performed.

• Thorough knowledge of data science methodologies, tools, and techniques, including statistical analysis, machine learning and data visualization to derive actionable insights from large datasets.

• Thorough knowledge of designing, developing and optimizing complex database objects such as views, triggers, stored procedures and functions to ensure efficient data storage, retrieval and performance.

• Considerable knowledge of data warehousing concepts and tools and of data pipeline architecture and developments.

• Considerable knowledge of cloud-based database solutions related to the work.

• Considerable knowledge of data analytic tools and techniques.

• Considerable knowledge of the operations and functions of departments served and their requirements as applied to the work performed.

• Ability to analyze and evaluate various data and information requirements and to prepare recommendations regarding the advisability and feasibility of incorporating changes or additions to the corporate data model.

• Ability to prepare detailed designs for all databases including physical and logical data structures and to control shared usage of data throughout the organization.

• Ability to establish standards and procedures to ensure the integrity, security, availability and recovery of all data.

• Ability to evaluate and monitor the performance of databases and related applications to ensure data integrity, security and optimization of database resources.

• Ability to lead projects for a variety of infrastructure and database projects, establish project schedules, assign and guide the work of team members and monitor progress.

• Ability to establish and maintain effective working relationships with a variety of contacts and to provide advice and assistance on matters related to the work.

• Ability to review the work of consultants for compliance with corporate standards.

• Ability to communicate effectively orally and in writing.

• Ability to read and understand computer programs (ie. R, Python, .Net, SQL).

Our Vision:

Metro Vancouver embraces collaboration and innovation in providing sustainable regional services that contribute to a livable and resilient region and a healthy natural environment for current and future generations.

At Metro Vancouver, we are committed to cultivating a diverse, safe, equitable, and inclusive work environment for all. We strive to attract and retain a talented, diverse workforce that is reflective of the region we serve. If an accommodation is required during the recruitment and selection process, please contact careers@metrovancouver.org for support. Learn more about our commitments to diversity, equity, and inclusion here.

Please follow this link https://metrovancouver.org/about-us/careers to our Careers page where you can submit your application by August 15, 2025.