Systems Analyst II

Main purpose and function

Duties and responsibilities

• Lead architecture, development, deployment, and maintenance of the Databricks warehouse, data pipelines, and analytics solutions.
• Provide senior technical support for custom and commercial applications across diverse platforms and technologies.
• Lead business analysis, solution design, technical specifications, requirements definition, and scalable data product development.
• Design integrations between the data platform and business systems using REST/SOAP APIs.
• Develop quality assurance and control procedures for accurate and complete data and outputs.
• Develop analytics strategies, measures, forecasts, and decision-support products; create visualizations and data products using Power BI or custom development.
• Lead testing preparation and execution for unit, integration, and user testing; debug and rework products as needed.
• Ensure production data solutions are reliable, performant, secure, and available.
• Apply data governance and quality controls and act as divisional data steward.
• Apply process improvement, service design, and performance measurement methods; assess operational and organizational impacts of proposed changes.
• Present findings, maintain stakeholder relationships, and develop user training and documentation.
• Provide day-to-day staff leadership, including assigning work, evaluating performance, coaching, mentoring, and development.

Education and experience

• Bachelor’s degree or diploma in Computer Science or IT and at least five years of related data warehousing and BI implementation and maintenance experience, or equivalent education, training, and experience.
• At least three years of user engagement, requirements gathering, and change management experience.
• Experience supporting strategies for major corporate decisions and identifying performance measures.
• Experience with data management, BI tools, data mining, and reports and dashboards.
• Extensive experience using data analysis, scenario modeling, and creative thinking to address complex business problems.
• Experience facilitating complex multi-stakeholder initiatives and engagements.
• Experience creating and presenting public information and engaging diverse stakeholders.

Knowledge, skills, and abilities

• Scripting and analysis tools include Python, DAX, ArcGIS Python API, and PowerQuery.
• Advanced reporting, BI, statistical analysis, visualization, SQL, and Python knowledge.
• Microsoft Power Platform experience includes Power BI, Power Apps, Fabric, and integration with enterprise data platforms.
• Data warehousing and ETL experience includes Databricks and Informatica; data modeling and SQL platforms include Microsoft SQL Server, Spark SQL, and Oracle.
• Knowledge of mapping, spatial analysis, and GIS in a municipal environment; familiarity with machine learning and predictive analytics is also noted.
• The role calls for project leadership, requirements translation, analytical troubleshooting, process improvement, prioritization, communication, and handling sensitive information.

Salary

• Pay Grade RNG-080: $102,960 to $128,691 per annum.

Employment and start

• Regular full-time employment; position start date is January 2027.
• Application closes November 3, 2026.