Requisition ID: 42765 Organization Located on the traditional, ancestral and unceded lands of the xʷməθkʷəy̓əm (Musqueam), Sḵwx̱wú7mesh (Squamish), and səlilwətaɬ (Tsleil-Waututh) Peoples, 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 rewarding workplace. Main Purpose and Function The 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 new 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 Responsibilities Acts 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 endpoints Analyzes highly complex business requirements and suggests solutions that will meet the functional and non-functional requirements including cost, security, and impact on existing investments Establishes, 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 solutions Assures 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 recommendations Consults with managerial, engineering, business, and technical personnel to clarify program intent and requirements, identify problems, and suggest changes Performs or directs revision, repair, or expansion of existing IT systems to increase operating efficiency or adapt to new requirements Assists 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 controls Researches and tests new systems and new features in existing analytical systems, driving innovation and continuous improvement Ensures adherence to data governance policies including quality standards, documentation, access controls and privacy expectations Other duties/responsibilities as assigned Qualifications Education 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 techniques Thorough knowledge of industry best practices in data analytics and Power BI Thorough knowledge of Power BI desktop and service, including data modeling, DAX, Power Query, and advanced visualization techniques Thorough knowledge of the relationship between data modeling and analytics Considerable knowledge of Power BI administration (client settings), workspace and capacity management, security, access controls Knowledge of SSRS or Power BI Report Builder Considerable knowledge of Microsoft Fabric and its use for data integration, data engineering, and data science workflows Knowledge of SQL and experience with database management systems. Knowledge of Microsoft Azure core concepts and administration Knowledge of data development lifecycle Knowledge 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 analytics Working knowledge of statistical analysis and methodologies Ability to communicate principles and techniques for maintaining data ethics, privacy in data, and indigenous ownership , control, access and possession (OCAP) of data Ability 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 lifecycle Ability to translate complex data findings into clear, actionable stories that resonate with diverse audiences. Ability to connect disparate data sources including standard authentication methods Ability to conduct scripting for automation using PowerShell Ability to use python in data analysis or engineering Ability to effectively teach and transfer knowledge to others Practical knowledge of DevOps and DataOps methodologies, patterns, and practices Ability 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 work Ability to collaborate with non-technical stakeholders to gather requirements and translate them into technical solutions Effective time and project management skills to prioritize tasks and meet deadlines Ability to handle business critical and sensitive information Ability to adapt and keep up to date with changes in business and technical landscape Where operationally appropriate and subject to change, the City of Vancouver has a Flexible Work Program. This program allows staff to work remotely 1 - 4 days a week from locations that are a daily commutable distance from their work at a City worksite. At this time this position is eligible to be part of the Flexible Work Program. Business Unit/Department: IT, Digital Strategy & 311 (1070) Affiliation: CUPE 15 Non Pks Employment Type: Regular Full Time Position Start Date: February, 2025 Salary Information: Pay Grade GR-031: $56.27 to $66.55 per hour Application Close: January 3, 2025 At 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 now Once 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. Save