Transit Data and Business Intelligence Analyst

4 days ago

Hamilton, Canada City of Hamilton Full time

**About the City of Hamilton**

**Contribute to the City of Hamilton, one of Canada’s largest cities - home to a diverse and strong economy, an active and inclusive community, a robust cultural and dining scene, hundreds of kilometres of hiking trails and natural beauty just minutes from the downtown core, and so much more. Join our diverse team of talented and ambitious staff who embody our values of sensational service, courageous change, steadfast integrity, collective ownership and being engaged empowered employees. Help us achieve our vision of being the best place to raise a child and age successfully. #BeTheReason**

**JOB POSTING**

JOB ID #: 20073

**Transit Data and Business Intelligence Analyst**
Public Works
Transit
2200 Upper James St., Hamilton, ON

NUMBER OF VACANCIES: 1 Full-Time Temporary

UNION/NON-UNION: Non Union Mgmt Professional

HOURS Of WORK: 35.00 per week
- GRADE: 5
- SALARY/HOUR: $44.762 - $52.350 per hour- Note: See appropriate Collective Agreement or the Non Union Salary Range for details.

STATUS/LENGTH: Temporary Up to 24 months

Job Description ID #: 2819

**Vaccine Verification - **As a condition of employment you are required to provide proof that you are fully vaccinated or provide proof of valid exemption satisfactory to the employer prior to your start date. You must acknowledge and agree to comply with any future vaccine policy requirements as an ongoing condition of employment at the City of Hamilton.

**TRANSIT DATA AND BUSINESS INTELLIGENCE ANALYST**

**SUMMARY OF DUTIES**

Reporting to the Senior Project Manager of Business Support, the Transit Data and Business Intelligence Analyst (Advanced Analytics) uses tools and algorithms to solve data-related problems. Programming and statistics are two key functions, as well as data wrangling and data visualization. The Analyst puts together custom database queries to answer the questions of business users, implements new metrics from existing data, strives to improve data quality, and contributes to correct acquisition of new data.

Besides technical duties, the Analyst also tackles open-ended questions and undirected research in ways that will bring measurable business benefits to the Transit Division. The Analyst develops predictive models for key lead measures / indicators. The Analyst is inquisitive by nature and can relate simultaneously to data, to organizational needs, and to the various Transit audiences, while promoting a customer-centric, data-driven culture.

**GENERAL DUTIES**

KPI, Dashboards, and Reports Development
- Develop and automate reports, performance measures, monitoring tools and benchmarks, solving for the Business Intelligence and analytical needs of full range stakeholders. Work with stakeholders to establish the right metrics for monitoring business processes. Present recommendations to the Transit Leadership Team.
- Conduct external benchmarking on key metrics, analytics practices and tools.

Statistical and Quantitative Analysis
- Use mathematical skills which include knowledge of numbers and figures, to understand relationships between numbers, interpret mathematical information, organize and lead the aggregation of large amounts of data / information, use argumentation and logical thinking, present information visually with diagrams, charts, tables, calculations, work with graphical information, schedule and / or budget, discover / define / analyze trends, measurements, and data analysis

Predictive Modelling
- Mine data and statistics to predict outcomes related to workforce planning and absenteeism, customer behaviour, and preventative maintenance schedules, etc.
- Writes code from scratch when necessary

Data Quality
- Work with modern data quality software (e.g. SAS, Informatica, Oracle) to build analytic models and tools and understand the importance of data quality rules and measures, including the concept of “dimensions” to quantify matters against various characteristics that are required of the data.
- Understand and reconcile gaps, overlaps, and apparent contradictions among data used within reports and reporting tools and work with management to resolve them, suggest workable alternatives and solutions. Assist in the implementation of alternatives.
- Document report specifications to ensure consistency of future reporting.
- Performs formal compliance audits in the divisional section in where appropriate.

Data Visualization
- Work with multivariate data and explore data in a tool such as Microsoft Power BI, Excel, and Trapeze ViewPoint to understand the shape of data and get revelation of hidden Business Acumen

Work in accordance with the provisions of applicable Health and Safety legislation and all City of Hamilton corporate and departmental policies and procedures related to Occupational Health and Safety.

Perform such other duties, which are related to the normal job function.

**QUALIFICATIONS**
- Post-secondary Bachelor’s degree with an emphasis on business, finan

  • Full Time Manager, Business Intelligence

    7 months ago

    Hamilton, Canada Home and Community Care Support Services Full time

    **Job Description**: **_CARE AND BE CARED FOR - THIS IS YOUR HOME_**: Reporting to the Director, Business Intelligence & Analytics, this position provides leadership in the development and implementation of business intelligence strategies and operations. The Manager, Business Intelligence leads a team of professionals in the development and implementation...

  • Financial Data

    4 days ago

    Hamilton, Canada McMaster University Full time

    **Schedule** 8:30am - 4:30pm **Education Level** Bachelor's degree in Computer Science/Engineering, Business Administration, or a related field of study **Career Level** Requires 3 years of relevant experience preferably in higher education or a not-for-profit sector **Department, Unit or Project Description**: The Financial Systems Support department...

  • Business Analyst

    6 months ago

    Hamilton, Canada Healthcare & Municipal Employees' Credit Union Full time

    **Position Vacancy** **Job Title**: Business Analyst **Job Status**: Regular Full-Time **Location**: Head Office / Hybrid or Remote Work Available **One (1) Vacancy** **Introduction** Are you someone who takes pride in creating efficiencies and wants to develop or improve on existing processes? If you answered yes to both of these questions then...

  • Business Process Analyst

    7 months ago

    Hamilton, Canada Healthcare & Municipal Employees' Credit Union Full time

    **Position Vacancy** **Job Title**: Business Process Analyst **Job Status**: Regular Full-Time **Location**: Head Office / Hybrid or Remote Work Available **One (1) Vacancy** **Introduction** Are you someone who takes pride in creating efficiencies and wants to develop or improve on existing processes? If you answered yes to both of these questions...

  • Business Systems

    7 months ago

    Hamilton, Canada AVL Manufacturing Inc. Full time

    **About us**: The AVL Group of Companies was founded in 1998. Hamilton Metal Works® (H.M.W), the group's founding company, focused primarily on large custom fabrications and machining. In 2006, H.M.W. changed its name to AVL Manufacturing, adding complete assembly, project management, and single-source supply chain services to its portfolio. AVL...

  • Data Analyst

    6 days ago

    Hamilton, Canada St. Joseph's Healthcare Hamilton Full time

    Posting #: **23284** - Openings Remaining: **1** - Full/Part Time: **Full Time** - Reg/Temp/Casual: **Regular** - Union: **Non-Union** - Hours of Work: **Monday to Friday; days** - Time of Day: **Days** - Shift Length: - Open Date: **06/12/22** - Closing Date: **13/12/22** ***: Working as part of a member of the SJHH Dovetale (Epic) data team, the Data...

  • Data Analyst, Healthcare Planning

    1 month ago

    Hamilton, Canada Watershed Management Consulting Full time

    **Data Analyst - Healthcare Planning** **Position**: Data Analyst **Location**: Greater Toronto Area (GTA) / Remote **Employment Type**: Contract (6 months, with potential extension) **Role Overview**: We are seeking a **Data Analyst** with healthcare experience to provide insights and forecasts for the Clinical Services Planning (CSP) project. This role...

  • Business Systems Analyst

    2 days ago

    Hamilton, Canada McMaster University Full time

    **Schedule** Monday - Friday 8:30 a.m. - 4:30 p.m. Overtime may be required during high volume periods throughout the year. **Education Level** Bachelor's degree in Computer Science, Business, or a related field of study. **Career Level** Requires 2 years of relevant experience. **Unit/Project Description**: McMaster University Continuing Education is an...

  • Toronto Junior Business Intelligence Developer

    3 days ago

    Hamilton, Ontario, Canada The Hunny Pot Cannabis Co Full time

    Cannabis Industry Data Analyst PositionThe Hunny Pot Cannabis Co. is seeking a detail-focused Cannabis Industry Data Analyst to join our team in Hamilton. As a key member of our head office team, you will play a pivotal role in gathering, analyzing, and visualizing data to drive informed business decisions.About the RoleWe are looking for a talented...

  • Business Systems Analyst

    7 months ago

    Hamilton, Canada MaxPeopleHR Full time

    **About our client** Mattina Mechanical Ltd (MML) is a well established full-service mechanical contractor with their head office located in Hamilton, Ontario. They continue to grow year over year and have built exceptional industry recognition delivering results for a variety of mechanical services including installation and maintenance for Institutional,...

  • Junior Data Analyst

    2 days ago

    Hamilton, Canada The Hunny Pot Cannabis Co Full time

    **THE HUNNY POT CANNABIS CO.**is the first legal Cannabis store to open in Toronto and is looking to add an enthusiastic **Junior Data Analyst - Reporting** to our head office team in Hamilton. **Overview** We are seeking a motivated and detail-focused Junior Data Analyst to become part of our team. In this role, you will play a key part in gathering,...

  • Junior Data Analyst

    3 days ago

    Hamilton, Canada The Hunny Pot Cannabis Co Full time

    *THE HUNNY POT CANNABIS CO. *is the first legal Cannabis store to open in Toronto and is looking to add an enthusiastic *Junior Data Analyst - Reporting* to our head office team in Hamilton.*Overview*We are seeking a motivated and detail-focused Junior Data Analyst to become part of our team. In this role, you will play a key part in gathering, analyzing,...

  • Junior Data Analyst

    4 days ago

    Hamilton, Canada The Hunny Pot Cannabis Co Full time €21

    THE HUNNY POT CANNABIS CO. is the first legal Cannabis store to open in Toronto and is looking to add an enthusiastic Junior Data Analyst - Reporting to our head office team in Hamilton. Overview We are seeking a motivated and detail-focused Junior Data Analyst to become part of our team. In this role, you will play a key part in gathering, analyzing, and...

  • Business and Info Systems Analyst

    7 months ago

    Hamilton, Canada AVL Manufacturing Inc. Full time

    Since 1998, AVL Manufacturing has been responding to industrial markets with turnkey manufacturing solutions. As an independent Canadian company focused on the design, development, engineering, and integration of renewable & nonrenewable power generation, we are committed to exceeding customer expectations. AVL Manufacturing has now transformed into one of...

  • Business Systems Analyst

    2 days ago

    Hamilton, Canada McMaster University Full time

    **Schedule** Monday - Friday, 8:30 am - 4:30 pm **Education Level** Bachelor's degree in Computer Science, Business, or a related field of study **Career Level** Requires 2 years of relevant experience McMaster University Continuing Education is an ancillary focused on the learning needs of adults who are typically working professionals wanting to study...

  • Retail Merchandiser

    7 months ago

    Hamilton, Canada Counter Intelligence Merchandising Inc. Full time

    **Counter Intelligence Merchandising Inc. **is always seeking to contract with talented, energetic people who are able to provide services to our expanding client base_**. **_We service all retailers across the country including Shoppers Drug Mart, Walmart, Rexall and many more! **Come join our team of merchandisers TODAY!** - **APPLY ONLY if you have...

  • Reline Merchandiser

    1 week ago

    Hamilton, Canada Counter Intelligence Merchandising Inc. Full time

    **Counter Intelligence Merchandising Inc. **is always seeking to contract with talented, energetic people who are able to provide services to our expanding client base_**. **_We service all retailers across the country including Shoppers Drug Mart, Walmart, Rexall and many more! **Come join our team of merchandisers TODAY!** **Looking to hire immediately...

  • Retail Merchandiser

    7 months ago

    Hamilton, Canada Counter Intelligence Merchandising Inc. Full time

    **Counter Intelligence Merchandising Inc. **is always seeking to contract with talented, energetic people who are able to provide services to our expanding client base_**. **_We service all retailers across the country including Shoppers Drug Mart, Walmart, Rexall and many more! **Come join our team of merchandisers TODAY!** - **APPLY ONLY if you have...

  • Retail Merchandiser

    4 days ago

    Hamilton, Canada Counter Intelligence Merchandising Inc. Full time

    **Counter Intelligence Merchandising Inc. **is always seeking to contract with talented, energetic people who are able to provide services to our expanding client base_**. **_We service all retailers across the country including Shoppers Drug Mart, Walmart, Rexall and many more! **Come join our team of merchandisers TODAY!** **Looking to hire immediately...

  • Data Analyst

    4 weeks ago

    Hamilton, Canada YWCA Hamilton Full time

    **Who We Are** Founded in 1889, **YWCA Hamilton** is known as one of Hamilton’s original social innovators and works from a feminist, anti-racist, and anti-oppressive framework. We are dedicated to strengthening women’s and girl’s voices, broadening their choices, building dynamic leadership and providing essential services that promote safe,...