Data Analytics and Reporting Analyst

**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 #: 20349

Data Analytics and Reporting Analyst
Public Works
Corporate Asset Management
100 King Street West

NUMBER OF VACANCIES: 2 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: Full-Time Temporary (for up to 24 months)

Job Description ID #: 7633

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.

**SUMMARY OF DUTIES**

Reporting to the Senior Project Manager, Innovation, the Data Analytics and Reporting Analyst solves data related problems through a quality management lens. Reviewing process and building solutions collaboratively with the Public Works and Corporate Asset Management teams this role is pivotal for data-driven decision making and supporting our operational groups with timely and consistent reporting. The Analyst leverages their inquisitiveness with their system-thinking to build models, architecture and processes to communicate with internal and external audiences, promoting a customer-centric, data-driven culture.

**GENERAL DUTIES**

**Process and Relationship Management**:
Collaboratively develop, recommend, and implement policies, procedures, and business processes to ensure data integrity, reflecting operational requirements and needs.

Proactive relationship management with internal stakeholders through meeting facilitation and correspondence.

Involved in business process reviews, improvement initiatives, providing strategic and process improvement advice to support finance and business operations from a quality management lens.

Makes recommendations for improvements to processes, including efficiency improvements, modification/elimination/development of tools, and the introduction and use of technology.

Establishes understanding of processes and data required to support operational and emerging needs.

Supports others in the daily use of data and information systems to educate compliance with data and information policies.

Develops training materials and user-guides for data governance-related solutions and technologies. Promotes adoption of data governance and information management standards to help build an engaged data-driven culture.

Proactively escalates data governance and information management insights that drive strategic and tactical business opportunities.

**Data Management**:
Leverages technology to drive user-centric, cost-efficient, accessible, and flexible solutions to enable ETL (Extract, Transform, Load (Data)) process development and support data needs.

Monitor data captured through diagnostic reports to ensure quality, timeliness, validity, and quantity of information.

Identify data gaps, enable data collection, and data modeling that creates value and reflects operational reality.

Makes credible/standard data and information available, ensuring accurate and effective translation of information from complex datasets and easy to understand materials for non-technical audience (e.g. staff, council, members of public).

Establishes appropriate levels of document control with process definition and process approval, review, revision and access control, change requests etc.

Provide QA/QC from a quality management lens, building consistent monitoring and maintenance on multivariate data from multiple sources.

Perform other duties as assigned which are related to the major responsibilities of the job.

**QUALIFICATIONS**

1. Education related to the duties outlined above, normally accompanied by a University Degree or College Diploma in Social Sciences, Engineering, Computer Sciences, Planning, Finance, Business, Economics or related field.

2. Considerable experience in ETL process development and data warehousing to design, develop and implement data solutions.

3. Advanced problem-solving, critical thinking and time-management skills.

4. Advanced knowledge of Microsoft O365, including SharePoint Online.

5. Demonstrated experience o