About this role
Computer Programmer IIIRequisition ID: 46089 OrganizationVancouver is consistently ranked as one of the world?s most liveable and environmentally sustainable cities. Recognized among BC?s Top Employers and Canada?s Greenest Employers, the City of Vancouver is seeking colleagues who can help advance our core commitments to exceptional public service, sustainability, equity, and an outstanding quality of life for all residents.With a strong commitment to being a City of Reconciliation, we invite you to join our dedicated team and become part of an innovative, inclusive, and engaging workplace. A career with the City of Vancouver and within the broader public service, offers meaningful work where you play a key role in ensuring equitable access to services, upholding ethical governance, and supporting the needs of citizens with integrity and dedication.Main Purpose and FunctionThe primary purpose of Computer Programmer III - Data Engineer is to perform data engineering work in support of capital or long term technology project implementations and requires strong knowledge and skills relating to data ingestion, data storage, processing, modeling, data lake and data warehouse design and implementation, building data pipelines, data integration, data testing, and data orchestration. The incumbent will perform complex programming and analysis work and /or configure, adapt and alter data structures, stores and pipelines for multiple applications built in many development languages to meet complex requirements. The Computer Programmer III - Data Engineer will also work as a project leader in a supervisory capacity with other data specialists and engineers, incorporating best technology solutions and showing leadership in the development of new data integration and ETL/ELT programming and development standards. The Computer Programmer III - Data Engineer works closely with Computer Programmer/ Analyst staff and other members of the Team to achieve the overall objectives of the City, Technology Services (TS), and the public. The Programmer shares knowledge and experience of computer techniques to provide solutions to technical and procedural problems. The incumbent exercises considerable independence of judgement in all technical aspects of work. Specific Duties/Responsibilities Acts as an expert technical resource for data ingestion and pipelines (ETL/ELT development), data modeling, data lake and data warehouse design and implementation and preparing data for analysis efforts with data from multiple platforms, applications and technologies Analyzes highly complex business requirements and suggests solutions that will meet the functional and non-functional requirements including cost, security, and existing investments Generates technical specifications to design or redesign data warehouse, data lake and other enterprise components and applications associated with data delivery Leverages industry best practices to design, test, implement and support solutions Assures quality, security and compliance requirements are met for supported areas Develops ETL/ELT in the context of a project, while ensuring alignment to current and developing architecture Prepares Technical Design and Specification documents Creates implementation instructions and supports deployments Conducts design and peer reviews including individual and team unit testing Oversees technical issues and the work of other developers Works with TS teams to review problems, define and test solutions Participates in the development of architectural framework and design Evaluates and introduces new tools and techniques to the development team Proactively identifies areas for improvement, seek solutions and make recommendations Consults with managerial, engineering, business, and technical personnel to clarify program intent, requirements, identify problems, and suggest changes Performs or directs revision, repair, or expansion of existing IT systems to increase operating effic