Data Management Lead

at  Metro Vancouver

Department: Human Resources and Corporate Services
Employee Group: Teamsters Local 31
Location: 4515 Central Boulevard, Burnaby
Salary Range/ Wage Rate: PG T33 $4,475.43 - $5,303.38 bi-weekly

THIS ROLE:

• Leads, assigns, directs and oversees the database administration team to ensure optimal performance, uptime, security, and efficiency of database systems; plans and incorporates new technologies for database infrastructure and advancements; oversees the development and enforcement of comprehensive database security policies and adherence to protocols to protect sensitive data from unauthorized access and breaches.
• Oversees the implementation of robust backup and recovery strategies to maintain data integrity and availability in the event of system failures or disasters; plans and guides the integration of new database technologies and tools.
• Leads, assigns, directs and oversees the data analytics team in developing and implementing data analytics initiatives that align with business and user needs; leads the architecting, development and deployment of data related initiatives, including data transformation scripts, data warehouses and data analytic dashboards.
• Acts as a project manager and scrum master for data analytics related initiatives to ensure efficient management of work in progress and new work requests; develops comprehensive project plans for data analytics initiatives, including defining project scope, objectives, time lines and resource requirements; and ensures alignment with business goals and stakeholder expectations.
• Conducts research to identify emerging trends and technologies in data engineering methodologies, processes and technologies to enhance data analytics capabilities; designs, develops, prototypes; and implements data solutions; integrates new technologies and tools into the existing database and analytics infrastructure; tests new ideas and approaches to solve data challenges; focuses on improving scalability, efficiency, security and reliability; and makes recommendations to standardize technologies in data engineering.
• Liaises with client departments and IT to assist in the resolution of service programs and issues; and provides advice and guidance to other staff engaged in projects of less complexity.
• Ensures the ongoing functionality and performance of existing data analytics assets; performs regular maintenance, updates, and optimizations to keep assets operating efficiently; troubleshoots and resolves issues related to data analytics assets; provides timely and effective support to minimize downtime and maintain data integrity; monitors the performance of data analytics assets; generates regular reports on their usage, performance, and any issues encountered; and identifies areas for improvement and innovation.
• Manages the development and implementation of data analytics projects; aligns projects with technical capabilities and strategic goals; researches and evaluates new tools and technologies; plans bi-weekly sprints; creates technical documentation as needed; prepares reports; and makes presentations related to the work performed.
• Stays abreast of the latest industry developments, trends, research and best practices in data collection, storage, management and analysis; and adopts best practices and new technologies for data analysis and product management.
• Perform other related duties as required.

To be successful, you have:

• Completion of a University degree in statistics, computer science, economics, engineering, business, mathematics, or a related field and considerable related experience working with data analytics programs; or an equivalent combination of training and experience.
• Extensive knowledge of various data storage solutions and methods and techniques used in data architecture and data integrations.
• Extensive knowledge of the tools and practices for extracting, transforming, loading data, automating and optimizing data pipelines.
• Extensive knowledge of cloud services and deploying and managing data services in a cloud environment.
• Thorough knowledge of data protection laws and in implementing security measures to protect data integrity and privacy.
• Thorough knowledge of the principles and practices of administrative management and project management and of business and business systems planning principles, methods and standards.
• Thorough knowledge of problem definition and analysis related to business processes and systems planning.
• Thorough knowledge of the equipment, methods and techniques used in computerized data processing operations.
• Considerable knowledge of the functions of departments served and their requirements in information technology.
• Ability to ensure optimal performance, security and availability of database systems by guiding and supporting the database administration team.
• Ability to lead, assign and oversee the work of the database team, data analytics team, technical supporting roles, vendors and stakeholders.
• Ability to assist in the development of corporate stands and to perform other administrative tasks related to the work.
• Ability to plan and integrate new database technologies while mentoring team members and fostering their professional growth.
• Ability to operationally develop and execute data analytics projects that align with the organization’s overall objectives.
• Ability to act as project manager regarding the development and implementation of work being performed and to deploy and manage data services in a cloud environment.
• Ability to work independently and collaboratively in a fast-paced and dynamic environment under minimal supervision.
• Ability to think strategically and creatively and to solve complex problems.
• Ability to leverage modern data analytics platforms such as Microsoft Fabric to create and manage data lake, data engineering, data integration and data science projects using the latest technology.
• Ability to use native connectors or create custom data connectors to connect to data sources on premises and in a cloud based environment.
• Ability to perform large scale data transformation and democratize data through the Lakehouse using Data Engineering in modern data analytics platforms such as Microsoft Fabric.
• Ability to build and deploy machine learning models, to create and share interactive reports and dashboards and to apply and enforce data governance, security, and compliance.
• Ability to document, analyze and assess a variety of information, identify priorities and resources and propose alternative business processes.
• Proficient in SQL, database technologies, database administration tasks and other data analysis tools and techniques.
• Driver’s Licence for the Province of British Columbia.