Data Platform Analyst at Metro Vancouver
Burnaby, BC — full-time
Position Title: Data Platform AnalystPosition Status: Full-Time RegularDepartment: Corporate ServicesEmployee Group: Teamsters Local 31Location: 4515 Central Boulevard, BurnabySalary Range/ Wage Rate: PG T27 $3,734.48 - $4,413.08 bi-weekly Our Corporate Services Department is seeking a Data Platform Analyst who will support and maintain enterprise data platforms, database systems, and analytics solutions. You will develop and optimize data pipelines, data models, and reporting solutions; administer and monitor database environments; troubleshoot operational issues; and liaise between client departments, technical staff, and vendors to keep data systems reliable, secure, and aligned to business needs. You are a pragmatic, service-oriented data professional with strong technical depth across database administration, data engineering, and analytics, who can translate business requirements into well-governed, supportable data solutions and keep critical enterprise data platforms running dependably. This role: Installs and maintains database systems to ensure a high level of data availability; develops database architecture using established standards; maintains and ensures database and coding standards and quality assurance standards and procedures; assists with planning and coordinating data migration between systems; and assists with the development and maintenance of cloud database components. Develops and maintains ETL (extract, transform, load) processes and data pipelines for data integration across platforms; designs and develops data models for data warehousing and business analytics; assists with data integration and transformation between data sources; supports data warehouse development and maintenance; and monitors and validates data flows to ensure accuracy and consistency. Develops, implements and maintains data analytics solutions using enterprise business intelligence tools; works with business stakeholders to gather requirements, translate, and deliver data analytics solutions; creates and optimizes semantic data models, calculated measures, and data transformations for solutions; and provides training and assistance to business users on self-service analytic tools. Monitors and evaluates technical performance of corporate data systems; identifies and resolves data abnormalities to avoid system outages; recommends replacement of aging systems and opportunities for optimization; assists with the monitoring and administration of cloud data storage solutions; provides technical support for operational issues; and participates in data backup and recovery planning. Serves as a technical resource on various infrastructure and database projects; completes tasks according to project schedules; coordinates with departmental stakeholders to ensure that database standards remain relevant and aligned with business requirements; as required, oversees the work of consultants for compliance with corporate database and applications development stand