Data Analyst Job Listing at City of Edmonton in Edmonton, AB (Job ID 52586)

Description

Under the direction of the Manager, Fleet and Facility Analytics, this position provides analytical support for the Fleet & Facility Services branch by building data sources, developing Tableau dashboards and doing analyses in spreadsheets. The position will be responsible for all aspects of research, data collection, data validation, modeling, blending, reporting and analysis for various client groups.

The position is expected to learn about the branch business and use this knowledge to work with representatives to identify specific reporting requirements. This means learning the associated processes within the business, as well as understanding the underlying data structure for the specified technologies used by the branch. Using this knowledge, the position is a partner with the business, providing initial analysis on the results. The reports are significant aid to the business as they enable various business areas to make data driven decisions.

What will you do?

• Use a variety of systems (Tableau, SAP, M5, PeopleSoft, Tririga, GPS software, Google Sheets, Microsoft Access, Microsoft Excel, SQL Developer, Microsoft SQL Server) to collect, organize and blend data 
• Work with clients to identify scope of work for analyses, dashboards and reports. This can include mapping processes and documenting business requirements to ensure that the reporting solution will meet their needs
• Extract the data from database tables manually or through ODBC connections. Identify data issues; work with the business and IT to recommend solutions, initiate resolutions
• Do analysis work in spreadsheets often with hundreds of thousands lines of data
• Create dashboards and reports using Tableau. Creates test scripts and conducts testing to ensure the data is accurate in the dashboard and that the actions, filters and visuals dashboard are functioning properly
• Independently validate the data for completeness, accuracy and relevance. Then seek validation from a variety of perspectives to continuously improve the accuracy of the analysis 
• Create documentation for the reports including logic, methodologies and business signoff 
• Build effective working relationships with the network of stakeholders within the branch. Coach and mentor other members of the team to enhance team capabilities
• Research new reporting styles and techniques including visual presentation best practices and assist with the development of standard practices and processes for data collection 
• Perform other related duties as required