Job Number: 56389Under 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 Desktop, Tableau Prep, Tableau Server, SAP, M5, PeopleSoft, Tririga, GPS software, Google AppSheets, Microsoft Excel, SQL Developer, Microsoft SQL Server, Visier, and Google Scripts) to collect, organize and blend dataWork with clients to identify scope of work for analyses, dashboards and micro applications. This can include mapping processes and documenting business requirements to ensure that the reporting solution will meet their needsExtract the data from database tables manually through reports or through SQL queries using ODBC connections. Identify data issues; work with the business and IT to recommend solutions, initiate resolutionsDo analysis work in spreadsheets often with hundreds of thousands lines of dataCreate 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 properlyIndependently validate the data for completeness, accuracy and relevance. Then seek validation from a variety of perspectives to continuously improve the accuracy of the analysisCreate documentation for the reports including logic, methodologies and business signoffBuild effective working relationships with the network of stakeholders within the branch. Coach and mentor other members of the team to enhance team capabilitiesResearch new reporting styles and techniques including visual presentation best practices and assist with the development of standard practices and processes for data collectionPerform other related duties as requiredQualifications:University Degree in Business, Commerce, Computer Science or related discipline (specializing in data analytics, statistical modeling and data visualization) from a recognized educational institutionMinimum 2 years experience in an operational environment, with a focus on data analysis and data validation as well as performance and financial measurementSkills required for success:Proficiency with MS Excel, Google Suite, SQL and Tableau is requiredExperience with automated data extraction, analysis and and dashboard buildingProficiency in modeling,



operational and statistical researchStrong mathematical skills with the ability to interpret dataAbility to express ideas and concepts effectively, both oral and writtenAbility to work independently under broad directionKnowledge of work methods, studies and analytical procedures, practices and terminology related to the Fleet and Facility Services businessesAlignment to our Cultural Commitments and Leadership Competencies (https://bit.ly/4brRrXm)Embracing a culture of equity, diversity, reconciliation and inclusionConditions of Employment:This position will work out of a facility that is not accessible via public transportation. A valid Class 5 license and access to personal transportation is recommendedWork Workplace:Note: This position may be eligible for a hybrid work arrangement with the flexibility to work from both home and the worksite as per the Letter of Understanding between the City of Edmonton and Civic Service Union 52The weekly hours of work for this position are currently under review and may change at a future time. Any changes will be made in accordance with the City of Edmonton/Civic Service Union 52 collective agreement and the incumbent will be notified in advanceThe City of Edmonton values applicants with a diverse range of skills, experiences and competencies, and encourages you to apply. We strive to provide reasonable access and accommodations throughout the recruitment process. To request an accommodation, please contact [email protected]. Learn more about our benefits https://bit.ly/COEbenefitsUp to 1 Permanent full-time positionHours of Work: 40 hours per week. Monday-Friday.
Salary Range: $41.177
- $51.444 ( Hourly) $85,977.580
- $107,415.070 (Annual)Recruitment Consultant: NC/SOEdmonton rests in the heart of Treaty Six territory in Alberta and the homel

📌 Data Analyst (Edmonton)
🏢 Edmonton
📍 Edmonton