Job ID #30929: Data Analytics & Reporting Analyst

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 kilometers 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 ID #30929: Data Analytics & Reporting Analyst
• Union: Non-Union
• Job Description ID #: 7800
• Close date: Interested applicants please submit your application online at www.hamilton.ca/city-council/jobs-city by 4:00 p.m. on April 16, 2025.
• Duration: 12 Months This vacancy is for a period of 12 months as a result of a new position.
• Internal applicants should apply with your work e-mail address. External applicants are considered only after the internal posting process has been completed. Only applicants chosen for an interview will be contacted.
  
  

Summary of Duties

Reporting to the Supervisor, Data Services the Data Analytics & Reporting Analyst – Data Services solves data related problems through a quality management lens. Reviewing process and building solutions collaboratively, this role is pivotal for data-driven decision making and supporting our City 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 and Reporting:
• 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.
• Ensures consistent applications, presentations, and interpretations of data.
• 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.
  
  

• 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.
• Considerable experience in ETL process development and data warehousing to design, develop and implement data solutions.
• Advanced problem-solving, critical thinking and time-management skills.
• Advanced knowledge of Microsoft 365, including SharePoint Online.
• Demonstrated experience of quality management principles, performance measurement principles and methods, and logic modelling methodologies, tools and qualitative and quantitative analytical techniques. Demonstrated experience in data visualization techniques, business intelligence software, data preparation, data analysis, and statistical and spatial tool sets (MS Fabric, Power BI, IBM Cognos, ArcGIS, Excel, Tableau etc.).
• Experience with distributed computing/databases and distributed computing language and cloud technologies (e.g., AWS Sagemaker, Azure ML) an asset.
• Experience building solutions with programming languages (e.g. SQL, Python, R, SAS) an asset.
• Strong interpersonal skills with a demonstrated ability to work effectively with others. Ability to display and foster teamwork within the work unit, relate to City Staff and the public in a tactful and courteous manner.
• Must possess excellent interpersonal skills, with well-developed communication skills. Able to articulate messages clearly and efficiently in written word, data reporting and presentations.
• Familiarity with municipal operations, city practices, is considered an asset.
  
  

Disclaimer

Be advised that Human Resources frequently audits resumes of internal/external applicants to ensure/validate information provided is consistent and trustworthy. Falsification of information provided at any time throughout the recruitment process may be grounds for disqualification, and for internal applicants, subject to discipline up to and including termination.

Terms

The City is an equal opportunity employer that is committed to inclusive, barrier-free recruitment and selection processes. Consistent with our Values and Corporate Culture Pillars, the City of Hamilton is committed to providing equitable treatment to all with respect to barrier-free employment and accommodation without discrimination. The City will provide accommodation for applicants in all aspects of the hiring process, up to the point of undue hardship. If you have an accommodation need, please contact Human Resources as soon as possible to make appropriate arrangements.