Systems Analyst II - City of Vancouver, Vancouver

Position summary

The Senior Solid Waste Data Systems Analyst is responsible for leading the design, implementation, governance and continuous improvement of the Solid Waste data platform, data products and business intelligence solutions. This position is responsible for technical and business requirements; design, develop, document, test, deploy and support solutions and products that allow the business to automate processes, build solutions, and analyze data. Working closely with Technology Services to develop and maintain the division's Databricks-based data warehouse, the role uses data engineering, analytics, and business intelligence technologies to deliver solutions that support operational, financial, regulatory, and strategic business needs.

Responsibilities

• Works as part of a project team to develop high quality, robust, maintainable business solutions
• Leads the architecture, development, deployment, and maintenance of the division's Databricks data warehouse, data pipelines, and analytics solutions.
• Provides senior technical application support for a wide range of custom and COTS applications developed using a range of platforms, tools, web frameworks, programming languages, operating systems and databases
• Leads business analysis, solution design, and technical specification development for data and analytics initiatives with complex software components and requirements.
• Leads business analysis to identify requirements, define data needs, and develop scalable data products
• Designs and generates technical specifications for complex software components and applications
• Designs and develops integrations between data platform and business systems using REST/SOAP APIs
• Develops and leads quality assurance and control procedures to ensure accuracy and completeness of business data and outputs.
• Develops analytics strategies, performance measures, forecasts, and decision-support products to inform departmental planning and strategic direction.
• Creates data products using PowerBI or custom development of data products, visualizations, and analysis
• Leads and facilitates testing activities for products including preparation of test data, scripts, environments for unit, integration, and user testing. Debugs and reworks as needed.
• Ensures reliability, performance, security, and availability of production data solutions created by the team
• Stays current with developments in advanced analytics, programming languages, data modeling, integration tools, database technologies, data visualization tools, techniques, and best design practices.
• Applies business analysis, process improvement, service design, and performance measurement methodologies to identify and implement operational improvements.
• Assesses operational data, technology, people, policy, governance, and change-management implications of proposed process changes.
• Responsible for applying the City's data governance standards and quality controls and acts as a data steward for the division
• Presents findings to departmental leaders and other stakeholders.
• Develops and maintains effective working relationships with stakeholders in business, operational, technical, and leadership groups.
• Develops and maintains user training and documentation.
• Provides day-to-day leadership and guidance to staff, including hiring, assigning responsibilities, evaluating and reporting on performance, coaching, mentoring, training and development.
• Performs other duties/responsibilities as assigned.

Skills and experience

Candidates must meet specific education, background, technical skills, and behavioral abilities to qualify for this Vancouver technology opportunity.

• 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 as well as engagement involving a diverse range of stakeholders.
• 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 and GIS in a municipal environment.
• 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 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, user experience, design and accessibility principles.
• Ability to analyze and synthesize data from multiple data sources and formats.
• Familiarity with machine learning, predictive analytics, or related emerging technologies.
• Ability to handle business critical and sensitive information while communicating ideas clearly in written and verbal form.