Data Solutions Developer

at  Metro Vancouver

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

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.