05 Oct
|
City of Vancouver
|
Toronto
05 Oct
City of Vancouver
Toronto
Last updated: 21 hours agoLocated on the traditional, ancestral and unceded lands of the xʷməθkʷəy̓əm (Musqueam Indian Band), Sḵwx̱wú7mesh Úxwumixw (Squamish Nation), and səlilwətaɬ (Tsleil-Waututh Nation), Vancouver has a commitment to becoming a City of Reconciliation. Vancouver consistently ranks as one of the world’s most liveable and environmentally sustainable cities. Named among Canada's Top 100 Employers, BC's Top Employers, and Canada's Greenest Employers, the City of Vancouver seeks colleagues who can help shape and embody our core commitments to sustainability, reconciliation, equity and outstanding quality of life for all residents.Consider joining our committed team of staff and being part of an innovative, inclusive and engaging workplace. Working at the City of Vancouver and within the public service can be a rewarding career where you play a key role in ensuring impartial and equitable access to services, upholding ethical governance, and addressing the needs of citizens with integrity and dedication.Main Purpose and FunctionThe Computer Programmer III – Analytics is responsible for advanced programming and analytics work, system configuration, and data management while leading the development of analytics solutions for various platforms. This position supports capital technology projects and promotes data‑driven decision‑making across the City of Vancouver. The position requires depth and breadth of knowledge and skills relating to data ingestion and processing, data warehousing, data modeling, and data visualization. The position performs 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 – Analytics will also work as a project leader in a supervisory capacity with other data specialists, incorporating best technology solutions and showing leadership in the development of current analytical and reporting 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 position exercises considerable independence of judgement in all technical aspects of work.Specific Duties and ResponsibilitiesActs as an expert technical resource for development of data analytical products including dataflows, semantic models, reports, and dashboards that connect to disparate data sources including on-premise and cloud warehouses, information systems and API endpointsAnalyzes highly complex business requirements and suggests solutions that will meet the functional and non‑functional requirements including cost, security, and impact on existing investmentsEstablishes, documents, shares,
and monitors best practices for enterprise and self‑service analytics that include the use of source control systems, automated deployment pipelines, templates, content certification, resource organization and governance.Plans and provides cost and effort estimates for analytical solutionsAssures quality, security, and compliance requirements are met for supported areas.Acts in a team lead capacity to supervise the work of junior technical staff. Oversees technical issues and the work of other developers.Proactively identifies areas for improvement, seeks solutions and makes recommendationsConsults with managerial, engineering, business, and technical personnel to clarify program intent and requirements, identify problems, and suggest changesPerforms or directs revision, repair, or expansion of existing IT systems to increase operating efficiency or adapt to new requirementsAssists in the training and development of other members of the team and partners throughout the business as part of the centre for enablement – analytics.Recommends, designs, implements, and monitors access control protocols for analytics, including workspace, object‑level and row‑based access controlsResearches and tests new systems and new features in existing analytical systems, driving innovation and continuous improvementEnsures adherence to data governance policies including quality standards, documentation, access controls and privacy expectationsOther duties/responsibilities as assignedQualificationsEducation and Experience:Completion of grade 12, (University Program), preferably a bachelor’s degree with major courses in Computer Science or a related discipline. Considerable related experience in computer programming and analysis, or an equivalent combination of training and experience.Knowledge, Skills and Abilities:Thorough knowledge of computer programming and analysis techniquesThorough knowledge of industry best practices in data analytics and Power BIThorough knowledge of Power BI desktop and service, including data modeling, DAX, Power Query, and advanced visualization techniquesThorough knowledge of the relationship between data modeling and analyticsConsiderable knowledge of Power BI administration (client settings), workspace and capacity management, security, access controlsKnowledge of SSRS or Power BI Report BuilderConsiderable knowledge of Microsoft Fabric and its use for data integration, data engineering, and data science workflowsKnowledge of SQL and experience with database management systems.Knowledge of Microsoft Azure core concepts and administrationKnowledge of data development lifecycleKnowledge of data warehousing concepts, architectures,
and best practices including different frameworks such as Kimball, Inmon, Data mesh, and data vault.Knowledge of the patterns and tools needed to support different analytics frameworks including descriptive, diagnostic, predictive, prescriptive, and cognitive analyticsWorking knowledge of statistical analysis and methodologiesAbility to communicate principles and techniques for maintaining data ethics, privacy in data, and indigenous ownership, control, access and possession (OCAP) of dataAbility to engage with City staff across all lines of business to understand their needs and concerns, translate those into actionable analytics and keep them involved throughout the project lifecycleAbility to translate complex data findings into clear, actionable stories that resonate with diverse audiences.Ability to connect disparate data sources including standard authentication methodsAbility to conduct scripting for automation using PowerShellAbility to use python in data analysis or engineeringAbility to effectively teach and transfer knowledge to othersPractical knowledge of DevOps and DataOps methodologies, patterns, and practicesAbility to work independently, taking initiative, while also knowing when to seek feedback or collaborate.Strong attention to detail to ensure accuracy and quality in all aspects of workAbility to collaborate with non‑technical stakeholders to gather requirements and translate them into technical solutionsEffective time and project management skills to prioritize tasks and meet deadlinesAbility to handle business critical and sensitive informationAbility to adapt and keep up to date with changes in business and technical landscapeBusiness Unit/Department : IT, Digital Strategy & 311 (1070)Affiliation : CUPE 15 Non PksEmployment Type : Temporary Full TimePosition Start Date : April, 2026Position End Date : August, 2026Salary Information : Pay Grade GR-031: $58.24 to $68.88 per hourApplication Close : April 3, 2026At the City of Vancouver, we are committed to recruiting a diverse workforce that represents the community we so proudly serve. Indigenous peoples, people of colour, 2SLGBTQ+ persons including all genders and persons with disabilities are encouraged to apply. Accommodations will be provided upon request during the selection process. Learn more about our commitment to diversity and inclusion.Before you click Apply nowOnce you start your application you can save your work and leave the applications page, however please remember to submit your profile to the specific job requisition before the posting closing date.In addition to uploading your cover letter and resume, part of the application process may include answering application questions related to the preferred requirements of the role which may take approx. 5-10 minutes. Cover letters should express interest and highlight additional information relevant to the position and resumes should include a summary of skills and experience related to the position.#J-18808-Ljbffr
📌 Director Of Programming And Volunteer Engagement - C$58.2 - C$68.9 An Hour (Toronto)
🏢 City of Vancouver
📍 Toronto