Sr. Data Analyst

Senior Data Analyst Opening

PSD Citywide develops meaningful, data-rich business intelligence and insight for public sector organizations. Our technical and consulting capabilities in infrastructure and capital asset management, long-term financial planning and policy research enable not only the design of rational and flexible organizational strategies but also their execution and ongoing assessment. PSD's service areas are configured to meet the three essential needs for governments: policy research and analysis, high-performance technology, and credible data. Through our infrastructure consulting and advisory practice, we work with decision-makers to refine organizational systems, programs and processes for better corporate outcomes. 

Currently, we are in the process of expanding our team and are searching for a Sr. Data Analyst (GIS Systems) to join our Implementation team. 

Role Description

The successful candidate will implement client data to PSD's GIS and Permitting software modules in a timely and accurate manner by analyzing, formatting and uploading data. Experience with PSD Citywide software is integral to this position and requirement of the role. 

Job Duties:

• Collecting, integrating and manipulating client supplied infrastructure data in Excel and our proprietary software program
• Advising clients on industry best practices related to municipal asset management
• Analyze, leverage and manipulate significant amounts of client data with high attention to detail and accuracy
• Setting expectations with clients throughout the data implementation process
• Providing support and training to clients
• Managing multiple implementation projects simultaneously; prioritizing effectively to ensure on-time and accurate implementation
• Providing outstanding customer service to PSD clients 
• Provide software testing and support as required - ability to develop and understand stored procedures for CRUD operation and program in C#. 
• Attending onsite meetings at our London head office - living in London Ontario preferred. 
• Communicate with internal and external stakeholders to interpret, document, resolve and/or escalate issues in a timely, professional and customer centered manner
• Demonstrate and apply knowledge of appropriate tools and resources to develop training content for clients.
• Other duties assigned

Qualifications:

• Post-secondary education in GIS
• Bachelors in Civil Engineering
• 1.5-2 years working with PSD Citywide Software modules, specifically GIS or Permitting modules. 
• 1 year working experience or applicable co-op experience.
• Previous experience analyzing data, preference given to those with GIS data analysis experience
• Previous experience working with google maps open data and API, developing web maps from aspx.net framework. 
• Ability to program in Java Script and create heat maps from excel data. 
• Analytical skills backed by high proficiency dealing with data - including Microsoft Excel, Access, etc.
• Technical Expertise in GIS Tools: ArcGIS Pro, ArcGIS Online, Google Earth Pro, Field Maps, and QGIS. 
• Certified in Auto CADD, Esri Arc GIS Python Programming, Intermediate Python for Data Analysis.
• Strong organizational skills, comfortable with multi-tasking and project management abilities
• Previous experience working with PowerBI would be considered an asset 
• Previous experience working in a customer-facing position
• 1.5 years experience with project manage software Kantata

Recruitment Process

All resumes will be reviewed for experience working with key technologies. Only those who qualify will be contacted for an initial screening interview. We strive to provide a quick recruitment process, but to find the right candidate for the job the process may take up to a month to complete. We make every effort to follow up with every candidate regarding the next step in the process.

Phone Interview

If you are invited to a screening interview you will discuss your experience with one of our HR team members. This interview is an opportunity to get to know a little more about the company, the type of work we do and impact we have.

 Virtual Interview

Candidates invited to an in-person virtual interview will meet with the department Manager and a member of the HR team. This will allow the candidate to get to know the team as well as learn more about our processes, culture and growth opportunities we have at PSD. 

Why work with us?

Employee personal and career growth is important to us and we will encourage you to pursue the things you care about.  We have a mentoring program that matches you with a peer in your department for your first three months to ensure you get fully acquainted with your position. We also encourage continuous learning through a Training & Development program allowing our employees to fully explore their interests and contribute to different product and service development teams at PSD.

Employee Benefits

• Competitive Salaries
• Full Benefits Package
• Relocation Assistance Program
• Company Matched RRSP Contributions
• Flex Hours & Paid Time off
• Social and Charity events and initiatives

PSD Citywide is an equal opportunity employer. We are committed to providing accommodations for people with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the recruitment and selection process. Should you require any accommodations, please indicate this when you apply and we will work with you to meet your accessibility needs.