Data and Analytics Specialist

Why Guelph:
**What we offer**
We offer competitive wages and comprehensive benefits to meet the needs of our diverse employees. Many of our positions offer:

- Paid vacation days, increasing with years of service
- Paid personal days;
- Hybrid and flexible work arrangements;
- Defined benefit pension plan with OMERS, including 100-per-cent employer matching;
- Extended health and dental benefits, including Health Care Spending Account;
- Employee and Family Assistance Program;
- Parental leave top up program;
- Learning and development opportunities including tuition assistance
- Employee recognition programs.

Position Overview:
Resumes are being accepted for the temporary position of** Data and Analytics Specialist** within the Information Technology department. Reporting to the GIS and Data Program Manager, this role is primarily responsible for developing the City’s data foundation to implement the Enterprise Data and Analytics program, operationalizing analytics, and delivering data-as-a
- service following industry standard practices and tools.

**Key duties and responsibilities**
- Work closely with clients and other resources to effectively communicate, design, plan, and implement capabilities that provide value to both internal and external customers.
- Design and build data architectures to leverage data as an organizational asset.
- Design comprehensive data solutions that enable clients to appropriately capture, make sense of and action data.
- Ensure delivered solutions fit within overall project plan and schedule.
- Provide feedback to departments and creates structured documentation, including specifications and weekly status reports.
- Advise departments on configuration and implementation options based on best practices.
- Participate in the business requirements gathering process for customizations.
- Lead/support Process Automation initiatives, for interfacing data structures.
- Ensure that all implementation methodology deliverables are complete and on time.
- Perform other tasks related to Data Governance, Master Data Management, Open Data and Database Administration, as required.
- Act as project manager for data projects including generating project status, time, and expense reports as requested by the management.
- Other relevant duties as required.

**Qualifications and requirements**
- Experience related to the duties listed above normally acquired through post-secondary education in computer science, computer programming or closely related field.
- Considerable experience in the design and construction of Data Integration Architectures, ETL/ELT pipelines, preferably with Informatica and Azure Data Technologies.
- Experience working with Data Governance working groups and committees.
- Extensive experience with Power BI and/or other data visualization and analytics tools.
- Progressive experience in the design and deployment of Metadata and Master Data systems for domains like Asset, Customer or Location Master.
- Knowledge of data integration architectures.
- Comprehensive Data Lake and Data Warehouse analysis and design experience, with SQL Server/Oracle databases, ESRI GeoDatabase and NoSQL Databases.
- Proficiency in using.NET technologies, JavaScript frameworks and libraries for data collection, visualization and interaction with SharePoint Online.
- Ability to lead projects and team members under limited supervision.
- Superior organizational and project management skills.
- Experience working with different SDLC methods including Agile, Scrum, Kanban.
- Time management skills in a dynamic delivery environment.

**Hours of work**
35 hours per week, Monday to Friday, between the hours of 8:30 a.m and 4:30 p.m. This position is eligible for hybrid and flexible work arrangement options (as per current corporate policy).

**Pay/Salary**
Non-union Grade: 6: $91,567.41- $114,459.27

**How to apply