Data and Analytics Specialist

2 months ago


Guelph, Canada The City of Guelph Full time

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



  • Guelph, Canada University of Guelph Full time

    **Department**: Lang-Office of the Dean Lang SBE This position is represented by the agreement between the Professional Staff Association and the University of Guelph Temporary full-time from 12/16/2024 to 05/16/2025 Temporary Absence of the Regular Incumbent **General Purpose** Reporting to the Director, Accreditation, Curriculum Development, and...


  • Guelph, Ontario, Canada MEDA Engineering and Technical Servicess, LLC Full time

    MEDA Engineering and Technical Services, LLC is looking for an experienced HR Technology Implementation Specialist to join our team. As a key member of our HR department, you will be responsible for implementing and utilizing HR technology systems to drive process improvement and increase efficiency.Responsibilities:Implement and utilize HR technology...


  • Guelph, Canada Linamar Corp Full time

    **Data and Analytics BI Analyst** The Data and Analytics BI Analyst, position, under general supervision, is responsible for creating and maintaining data models, creating data visualization that provide meaningful insight and monitoring pipelines to ensure data quality and reliability. Additional responsibilities include automating workflows, ensuring data...


  • Guelph, Ontario, Canada Elby Professional Recruitment Full time

    Elby Professional Recruitment is seeking a highly skilled Data-Driven Sales Insights Specialist to join our team in Guelph. This exciting opportunity will involve working cross-functionally with various departments to drive sales targets through revenue analysis.This hybrid role requires you to be in the office for 3 days a week and offers a competitive...

  • Analytical Chemist

    7 months ago


    Guelph, Canada Wellington Laboratories Inc. Full time

    Education: - Expérience: **Education**: - Master's degree - or equivalent experience **Tasks**: - Develop and conduct programs of analysis to ensure quality control of raw materials, chemical intermediates or final products - Troubleshoot and make minor adjustments to equipment **Analytical techniques**: - Chromatography - Instrumentation - Quantitative...


  • Guelph, Canada Geosyntec Consultants, Inc. Full time

    If you’re looking for a place to grow your career, where you can contribute to a dynamic innovative firm, tackle challenging project work, and collaborate with industry recognized professionals - Geosyntec is the place for you! We are seeking a **GIS / Data Management Specialist **to join our team in our **Guelph, Waterloos, Toronto, Cambridge, Vancouver,...


  • Guelph, Ontario, Canada Linamar Corp Full time

    Job SummaryA successful candidate for this position will have the opportunity to work as a Data Analyst and Process Specialist at Linamar Corp. The role involves complex or extensive scope business analysis work, including business process analysis, gathering information on and interpreting business requirements and models.


  • Guelph, Ontario, Canada MEDA Engineering and Technical Servicess, LLC Full time

    About MEDA Engineering and Technical Services, LLCMEDA Engineering and Technical Services, LLC is a leading Tier 1 manufacturing supplier seeking an HRIS Implementation and Optimization Specialist to drive process improvements that support company strategic objectives.Job Summary:We are looking for a highly skilled and experienced HRIS Implementation and...


  • Guelph, Ontario, Canada MEDA Engineering and Technical Servicess, LLC Full time

    We are seeking a highly skilled Data Driven HR Analytics Professional to join our team at MEDA Engineering and Technical Services, LLC. As a key member of our HR department, you will be responsible for analyzing data to drive business decisions and improving the efficiency of HR systems.Key Responsibilities:Analyze HR data to identify trends and insights...

  • Paid Ads Specialist

    7 months ago


    Guelph, Canada Prosites Inc Full time

    **Paid Ads Specialist-Job Description** **Job Summary** As a Paid Ads Specialist, you will have a focus on data analysis and paid search. You will be immersed in PPC, and proactively identify paid media opportunities on a micro and macro level. You are expected to drive results, consistently improve product and process, while staying up to date on the...


  • Guelph, Ontario, Canada Recurrent Energy Full time

    Job Overview:We are seeking a highly skilled Senior Solar Performance Optimization Specialist to join our team at Recurrent Energy. This is an exciting opportunity for a talented professional to contribute to the growth and success of our organization.The ideal candidate will have a strong background in engineering, data analytics, and solar energy systems....


  • Guelph, Canada Johnson & Johnson Full time

    Description Kenvue is currently recruiting for: **R&D Analytical Assistant Scientist** This position reports to the Manager Analytical and is based in Guelph. **Who we are** At Kenvue, we realize the extraordinary power of everyday care. Built on over a century of heritage and rooted in science, we’re the house of iconic brands - including Neutrogena,...


  • Guelph, Ontario, Canada System1 Full time

    We are seeking a highly skilled and experienced Lead Data Scientist to join our growing Data Analytics team at System1. This role requires a strong background in exploratory data analytics, statistics, data modeling as well as excellent communication and leadership skills.The RoleAnalyze large datasets from search engine marketing campaigns, including...


  • Guelph, Canada Magna International Inc. Full time

    **Job Number**: 62489 **Group**: Magna Exteriors **Division**: Polycon **Job Type**: Permanent/Regular **Location**: GUELPH **Work Style**: **About us** We see a future where everyone can live and move without limitations. That’s why we are developing technologies, systems and concepts that make vehicles safer and cleaner, while serving our communities,...


  • Guelph, Canada Ontario One Call Full time

    **Co-op Data Reporting Analyst**: Build your future at Ontario One Call! **Company Overview**: Ontario One Call acts as the communications link between buried infrastructure owners (our members) and individuals who are planning to dig in the province of Ontario. In 2012, the Ontario Underground Infrastructure Notification System Act was passed, which...


  • Guelph, Ontario, Canada The Mason Group Inc Full time

    The Mason Group Inc is seeking a highly detail-oriented and organized Financial Data Entry Specialist to join our team. This role will be responsible for preparing and processing all accounts receivable invoices and payments, as well as managing unit income reports in accounting software.We offer a competitive salary of $55,000 - $65,000 per year, depending...


  • Guelph, Canada Ontario One Call Full time

    Co-op Data Reporting Analyst Build your future at Ontario One Call! **Company Overview**: Ontario One Call acts as the communications link between buried infrastructure owners (our members) and individuals who are planning to dig in the province of Ontario. In 2012, the Ontario Underground Infrastructure Notification System Act was passed, which stipulates...


  • Guelph, Ontario, Canada Avanti Software Inc. Full time

    At Avanti Software Inc., we're seeking a highly skilled Data Warehouse Architect to join our team in Guelph, Ontario.About the RoleThis is a full-time position with an estimated salary of $80,000 - $110,000 per year. The successful candidate will be responsible for designing and implementing data warehouses, data marts, and cubes using Microsoft Snowflake or...


  • Guelph, Canada Schema App Full time

    **_Location - Remote (within Canada)_** **About Schema App** Schema App is on a mission to translate the world’s web content to be understood by search engines, voice assistants, and chatbots. Schema App is a SaaS platform for a super niche search optimization strategy called Schema Markup and building out customer content knowledge graphs. Our purpose...


  • Guelph, Ontario, Canada MEDA Engineering and Technical Servicess, LLC Full time

    Job DescriptionWe are seeking a highly skilled Compensation and Benefits Specialist to join our team at MEDA Engineering and Technical Services, LLC.This is an exciting opportunity for a seasoned professional to lead the development and implementation of our total rewards strategy, ensuring that our compensation and benefits programs align with industry...