indeed
GIS Business Solutions Analyst
City of Markham
Markham, CAN
Full Time
Mid
Onsite
1 weeks ago
GISArcGISPythonSQLETLPowerBI
Free
Job Fit Check
Base Career helps you apply smarter for this job.
?%
Ready to ScanKey skills for this role
GISArcGISPython
About the Role
The City of Markham is seeking a GIS Business Solutions Analyst to join its Information Technology Services department. The role involves spatial data analysis, GIS solution design, and stakeholder engagement to support data-driven decision making.
Key Skills for This Role
GISArcGISPythonSQLETLPowerBI
Responsibilities
- Perform spatial and data analysis on environmental, demographic, infrastructure, planning related and other City datasets
- Analyze complex information after conceptualizing the business problem and determining the data required
- Produce high quality cartographic outputs, web maps, dashboards and reports for Staff
- Develop analytical models and scripts (e.g., Python, ETL, tools) to support complex spatial, data analysis and reporting
- Conduct detailed spatial, data analytics and reporting
- Support policy analysis, planning, and service delivery with geospatial insights
- Validate data integrity and perform QA/QC processes
- Identify patterns, trends, and anomalies in spatial and non spatial data
- Collaborate with other analysts for data modeling and scenario planning
- Design, develop, and maintain geospatial datasets and non spatial datasets ensuring accuracy, consistency, and adherence to standards
Requirements
- Undergraduate Degree in Computer Science, Geography, Data Science or related discipline
- Five (5) to Seven (7) years of experience in analyzing GIS or other data
- Experience working with ESRI’s ArcGIS software suite (ArcGIS Desktop, ArcGIS Pro, ArcGIS Enterprise, ArcGIS Online, and web GIS applications)
- Experience working with ETL tools to transform and translate data (e.g. Safe Software FME, Power Automate, SSIS)
- Knowledge and proficiency in scripting languages such as Python, SQL, Arcade, ArcPy, as well as workflow tools such as Model Builder
- Experience working with PowerBI or other Enterprise reporting tools
- Understanding of a star schema, multi dimensional models and their principles
- Understanding of data warehouses, and data marts
- Ability to work with ambiguity
- Willingness to learn and leverage new platforms and capabilities
- Proficient with Microsoft 365
Full Job Posting
Job Summary
- This role will report to the Manager, GIS and Data Analytics. Working with departmental staff across the organization to identify and implement Spatial based Data and Reporting solutions (applications, data products, analysis work) that improve business processes, effectiveness and support decision
Key Duties and Responsibilities Data, Spatial Analytics & Reporting
- Perform spatial and data analysis on environmental, demographic, infrastructure, planning related and other City datasets
- Analyzes complex information after conceptualizing the business problem and determining the data required to assist the process
- Produce high quality cartographic outputs, web maps, dashboards and reports for Staff
- Develop analytical models and scripts (e.g., Python,ETL, tools ) to support complex spatial,data analysis and reporting
- Conduct detailed spatial, data analytics and reporting
- Support policy analysis, planning, and service delivery with geospatial insights
- Validate data integrity and perform QA/QC processes
- Identify patterns, trends, and anomalies in spatial and non spatial data
- Collaborate with other analysts for data modeling and scenario planning
Data Management & Quality Assurance
- Design, develop, and maintain geospatial datasets and non spatial datasets ensuring accuracy, consistency, and adherence to standards
- Implement and maintain data validation and quality control procedures
- Support data governance practices and ensure metadata documentation is current
- Evaluates, maintains, and enhances data sets, including advice regarding requirements to assure the quality of contributing data sources
Project Support & Stakeholder Engagement
- Work with business units to advise and educate about data analytics capabilities.
- Work with business units to identify, design and implement data analytics, data reporting, GIS and dashboard solutions
- Collaborate with business units and ITS/GIS staff to streamline business processes and optimize geospatial/data workflows
- Facilitate workshops, training sessions and Community of Practice (CoP) events to increase GIS and data literacy
- Collaborate with Staff to define project requirements and deliver data driven solutions
- Manage and contribute to GIS and data related projects, including scheduling, documentation, and delivery
- Participate in multidisciplinary teams to apply GIS and data analytics in solving organizational challenges
- Gather business requirements through consultations and translate them into technical specifications
- Act as a liaison between technical teams and non technical stakeholders
- Promote the value of data driven decision making across departments
- Support change management during GIS and data related implementations
- Develop, maintain, and enhance reporting on various enterprise platforms such as CRM – Customer Relationship Management, ERP – Enterprise Resource Planning, EAM – Enterprise Asset Management
Strategic Planning & Governance
- Develop GIS, Reporting and Data related policies, standards, procedures, and processes
- Contribute to the implementation of the Corporate GIS Strategic Plan
- Assist in the development and implementation of data standards and processes
- Evaluate emerging GIS and data technologies for strategic alignment
- Liaise with external agencies (York Info Partners, Emergency Operations) on data sharing, system integration, and GIS infrastructure requirements
- Participate in long term planning for enterprise data architecture and governance
- Support open data initiatives and data sharing frameworks
- Monitor compliance with data privacy and security regulations
- Recommend improvements to align with Regional/provincial/federal data best practices
Project & Application Management
- Design, implement, and maintain GIS and Data projects and applications
- Focus on current projects and support integrated GIS and Data functions in enterprise systems
- Manage project timelines
- Prepare documentation including project plans, and post implementation reviews
- Conduct user acceptance testing and support go live activities
- Coordinate with vendors and consultants for specialized implementations
- Ensure that GIS/data projects align with IT service delivery and digital transformation goals
- Configures, maintains, and support GIS web based applications and business system integrations (public and internal)
Technical Administration & System Support
- Assist in configuring the technical components of the Enterprise GIS system (AGOL, ArcGIS Server, etc.)
- Administer GIS related solutions, data, and analysis projects
- Work with technical staff to troubleshoot, resolve issues, and administer corporate GIS/data applications
- Maintain and optimize geodatabases, services, and server infrastructure
- Monitor system performance and plan for upgrades or migrations
- Develop and maintain automation scripts to streamline various workflows and data processing
- Perform version upgrades and patch management of GIS and Data applications
Qualifications
- Undergraduate Degree in Computer Science, Geography, Data Science or related discipline
- Five (5) to Seven (7) years of experience in analyzing GIS or other data
- Certificate in GIS or GISP designation an asset
- Experience working with ESRI’s ArcGIS software suite (ArcGIS Desktop, ArcGIS Pro, ArcGIS Enterprise, ArcGIS Online, and web GIS applications)
- Experience working with ETL tools to transform and translate data (e.g. Safe Software FME, Power Automate, SSIS)
- Knowledge and proficiency in scripting languages such as Python, SQL, Arcade, ArcPy, as well as workflow tools such as Model Builder.
- Experience working with PowerBI or other Enterprise reporting tools
- Understanding of a star schema, multi dimensional models and their principals
- Understanding of data warehouses, and data marts
- Ability to work with ambiguity
- Willingness to learn and leverage new platforms and capabilities
- Proficient with Microsoft 365
Working Conditions
- Work is performed primarily in an office environment.
Conditions of Employment
- Requires a valid "G" class driver's license and a clean driver's abstract.
- Satisfactory completion of a Criminal Record and Judicial Matters Check is required.
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 Markham
Planner I – Parks Planning
Markham, CAN
EntryTemporary
The City of Markham is seeking a Planner I for Parks Planning to provide parks planning and development advice during review of development applications. The role involves evaluating applications, conducting site inspect
YesterdayView →
Supervisor, Community Program - Group Fitness
Markham, KSA
ManagerFull Time
The City of Markham is hiring a Community Program Supervisor for Group Fitness to oversee program delivery, supervise staff, and support budget management. Requires a post-secondary degree, 3+ years supervisory experienc
3 days agoView →
IT Service Desk Support Specialist
Markham, CAN
EntryFull Time
The City of Markham is seeking an IT Service Desk Support Specialist to provide first-level IT support for all City and Library staff. You will handle incidents and service requests via phone, email, and chat, and perfor
1 weeks agoView →