Data Analyst - Edmonton, Canada - City of Edmonton

City of Edmonton

Verified Company

Edmonton, Canada

2 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

Data Analyst

Job Number:

47320

The Policy and Data Quality Unit supports the Assessment and Taxation branch with business systems, Enterprise Resource Planning (ERP) software, data analytics, and business process improvements, all of which have a significant impact on branch operations.

The Data Analyst position is responsible for discovering insights and identifying opportunities through the use of statistical, algorithmic, mining, and visualization techniques.

The position also helps enforce ERP system policies, procedures, and standards.

With a focus on the City of Edmonton's Cultural Commitments to Safe, Helpful, Accountable, Integrated and Excellent, you will:

Identify, analyze, and interpret trends or patterns in complex data sets from TACS, POSSE, SLIM, Google Sheets, MS Excel, Open Data, and other sources. The intent is to improve Assessment and Taxation data gathering, processing and forecasting
Stay up to date and research new techniques for showcasing data. Maintain proficiency in existing and updated visualization and business data tools (e.g. WEBI, Tableau, etc.). Must be able to determine from various means (e.g.business experts, prior reports, etc.) what looks reasonable for output
Prepare guidelines and standards for consistency in report creation
Review and determine all data sets in the branch. Make recommendations for data storage types (e.g. Oracle, Excel, Google, POSSE, SAP, etc.), data refresh, and data extraction methods
Participate in the functional configuration, testing/troubleshooting, and maintenance of assigned ERP systems according to operational and business needs
Support futurestate planning and development of ERP systems
Study existing business processes, materials, flowcharts, etc. as needed
Review and analyze data, identify process (business or technical) improvements that can be implemented by the branch
Perform other related duties as required

Qualifications:

University graduation in Mathematics, Computing Science, Statistics
Advanced skills in working with business intelligence tools such as SAP Web Intelligence, Tableau, or experience with other data discovery, visualization, and/or infographic technologies
Knowledge and experience using Google Workspace, and some Google Apps scripting
Fundamental knowledge of SQL is required. Experience with other data manipulation technology is an asset
Possess an intellectual curiosity for data and how it can be used to drive insights
Passion for transforming large amounts of data into compelling visual stories and/or reports to facilitate analysis and decisionmaking
Ability to balance attention to detail with prioritizing work in order to meet deadlines
Demonstrate excellent written and oral communication skills, including comfortably presenting to technical and business stakeholders at various levels in the corporation
Experience in various business processes to drive improvements in the branch
Ability to work independently and as part of a team
Exceptional analytical and problem solving skills
Knowledge of assessment and taxation functions and municipal government will be an asset
Demonstrate alignment with the Cultural Commitments of Safe, Helpful, Accountable, Integrated and Excellent, fostering an environment for others to do the same. For more information on the City's Cultural Commitments, please visit
Demonstrate the foundational competencies, key behaviors and attributes of the City's six leadership competencies: Courage, Inclusivity, Values-Based Influencer, Collaborative Networker, Systems Thinker and Creative Innovator. For more information on the City's leadership competencies, please visit
Applicants may be tested

_ Up to one (1) permanent full-time position_

Hours of Work:33.75 hours per week; Monday to Friday. The 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 advance.

Salary:
$ $ Hourly); $68, $85, Annually)

Talent Acquisition Consultant:
RM/MZ

Classification Title:
Methods Analyst I

Posting Date:
Aug 9, 2023

Closing Date:
Aug 23, :59:00 PM (MST)

Number of Openings (up to): - Permanent Full-time

Union:
CSU 52

Department:
Assessment and Taxation

Work Location(s): Chancery Hall, 8th Floor, 3 Sir Winston Churchill Square Edmonton T5J 2C3