successfactors
Systems Analyst II
City of Vancouver
Vancouver, CAN
Full-time
Mid · 3+ years experience
Onsite
Discovered 5 days ago
databrickspower-bipythonsparksql
Key Skills for This Role
databrickspower-bipythonsparksql
Full Job Posting
Qualifications
- Education and Experience: Bachelor’s degree or diploma in Computer Science or Information Technology and a minimum of five years of related experience with implementation and maintenance of data warehousing and BI solutions leveraging structured and unstructured data, preferably in a municipal environment, or an equivalent combination of education, training and experience Minimum of 3 years of experience with user engagement, requirements gathering and change management. Experience in supporting and developing strategies to support major corporate decisions and identifying performance measures to inform strategic decisions. Experience with data management, business intelligence tools, data mining, designing reports and dashboards to facilitate effective evidence based decision making. Extensive experience in strategically answering complex business problems through data analysis, scenario modeling and creative thinking. Significant experience in supporting and facilitating complex multi-stakeholder initiatives and engagements Experience with the creation and presentation of public information (formal/informal reports, other publications) as well as engagement involving a diverse range of stakeholders. Knowledge, Skills and Abilities: Experience with scripting or programming languages and relevant packages used for analysis, automation and integration, such as Python, DAX, ArcGIS Python API, PowerQuery Advanced knowledge of reporting, business intelligence, statistical analysis, and data visualization techniques using tools such as Power BI, SQL, and Python. Advanced experience designing, developing, implementing, and supporting enterprise reporting and analytics solutions Advanced knowledge and experience with Microsoft Power Platform technologies, including Power BI, Power Apps, and Fabric, and their integration with enterprise data platforms Advanced skills and experience in working with Data Warehousing software and performing ETL processes in tools such as Databricks and Informatica Strong skills with data modelling and data warehouses. Advanced skills in SQL development, query optimization, and database design using platforms such as Microsoft SQL Server, Spark SQL, and Oracle. Experience leading data or technology projects through the full project lifecycle Experience working with operational stakeholders to translate business requirements into technical solutions. Knowledge of mapping and spatial analysis techniques. Knowledge of GIS in a municipal environment and understanding of its relationship with other business systems. Experience leading or supervising technical staff Ability to simultaneously manage multiple organizational priorities, projects, and deadlines. Ability to initiate business process improvements, supporting strategic decisions and change initiatives for a large organization. Ability to apply analytical, business and data management assessment skills and methodology to achieve a comprehensive multi-layered understanding of the related analytical and business processes and tools. Ability to strategically answer complex business questions through data analysis, scenario modeling, data visualizations, and creative thinking. Ability to leverage strong analytical, technical and troubleshooting skills to solve complex problems and perform root cause analysis. Working knowledge in project management Ability to analyze and synthesize data from multiple data sources and formats. Some knowledge of user experience, design and accessibility principles. Familiarity with machine learning, predictive analytics, or related emerging technologies. Ability to handle business critical and sensitive information. Ability to forward think, coupled with the skills of being able to articulate ideas in both written and verbal form. Demonstrated analytical skills and strong organizational abilities. Business Unit/Department : Engineering Services Affiliation: Exempt Employment Type: Regular Full-Time Position Start Date: January 2027 Salary Information: Pay Grade RNG-080: $102,960 to $128,691 per annum Application Close: November 3, 2026 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 . The City of Vancouver acknowledges that it is situated on the unceded traditional territories of the xwməθkwəy̓əm (Musqueam Indian Band), Sḵwx̱wú7mesh Úxwumixw (Squamish Nation), and səlilwətaɬ (Tsleil-Waututh Nation). More about unceded traditional territories 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.
Preferred Qualifications
- Education and Experience: Bachelor’s degree or diploma in Computer Science or Information Technology and a minimum of five years of related experience with implementation and maintenance of data warehousing and BI solutions leveraging structured and unstructured data, preferably in a municipal environment, or an equivalent combination of education, training and experience Minimum of 3 years of experience with user engagement, requirements gathering and change management. Experience in supporting and developing strategies to support major corporate decisions and identifying performance measures to inform strategic decisions. Experience with data management, business intelligence tools, data mining, designing reports and dashboards to facilitate effective evidence based decision making. Extensive experience in strategically answering complex business problems through data analysis, scenario modeling and creative thinking. Significant experience in supporting and facilitating complex multi-stakeholder initiatives and engagements Experience with the creation and presentation of public information (formal/informal reports, other publications) as well as engagement involving a diverse range of stakeholders. Knowledge, Skills and Abilities: Experience with scripting or programming languages and relevant packages used for analysis, automation and integration, such as Python, DAX, ArcGIS Python API, PowerQuery Advanced knowledge of reporting, business intelligence, statistical analysis, and data visualization techniques using tools such as Power BI, SQL, and Python. Advanced experience designing, developing, implementing, and supporting enterprise reporting and analytics solutions Advanced knowledge and experience with Microsoft Power Platform technologies, including Power BI, Power Apps, and Fabric, and their integration with enterprise data platforms Advanced skills and experience in working with Data Warehousing software and performing ETL processes in tools such as Databricks and Informatica Strong skills with data modelling and data warehouses. Advanced skills in SQL development, query optimization, and database design using platforms such as Microsoft SQL Server, Spark SQL, and Oracle. Experience leading data or technology projects through the full project lifecycle Experience working with operational stakeholders to translate business requirements into technical solutions. Knowledge of mapping and spatial analysis techniques. Knowledge of GIS in a municipal environment and understanding of its relationship with other business systems. Experience leading or supervising technical staff Ability to simultaneously manage multiple organizational priorities, projects, and deadlines. Ability to initiate business process improvements, supporting strategic decisions and change initiatives for a large organization. Ability to apply analytical, business and data management assessment skills and methodology to achieve a comprehensive multi-layered understanding of the related analytical and business processes and tools. Ability to strategically answer complex business questions through data analysis, scenario modeling, data visualizations, and creative thinking. Ability to leverage strong analytical, technical and troubleshooting skills to solve complex problems and perform root cause analysis. Working knowledge in project management Ability to analyze and synthesize data from multiple data sources and formats. Some knowledge of user experience, design and accessibility principles. Familiarity with machine learning, predictive analytics, or related emerging technologies. Ability to handle business critical and sensitive information. Ability to forward think, coupled with the skills of being able to articulate ideas in both written and verbal form. Demonstrated analytical skills and strong organizational abilities. Business Unit/Department : Engineering Services Affiliation: Exempt Employment Type: Regular Full-Time Position Start Date: January 2027 Salary Information: Pay Grade RNG-080: $102,960 to $128,691 per annum Application Close: November 3, 2026 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 . The City of Vancouver acknowledges that it is situated on the unceded traditional territories of the xwməθkwəy̓əm (Musqueam Indian Band), Sḵwx̱wú7mesh Úxwumixw (Squamish Nation), and səlilwətaɬ (Tsleil-Waututh Nation). More about unceded traditional territories 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.
About City of Vancouver
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at City of Vancouver
Civil Engineer I - Liquid Waste Management Engineer
Vancouver, CAN
MidFull-time
Discovered 3 days agoView →
Library Public Service Associate I
Vancouver, CAN
Discovered 2 days agoPart-time
Library Public Service Associate I
Vancouver, CAN
Discovered 2 days ago
Engineering Assistant - Ops Support
Vancouver, CAN
Discovered 3 days agoFull-time
Civil Engineer I - Liquid Waste Management Engineer
Vancouver, CAN
Discovered 3 days agoFull-time
City Photographer
Vancouver, CAN
Discovered 3 days agoFull-time
Journeyperson - Metal Fabricator
Vancouver, CAN
Discovered 3 days agoFull-time
District Building Inspector
Vancouver, CAN
Discovered 3 days agoFull-time
Building Code Specialist
Vancouver, CAN
Discovered 4 days agoFull-time