Business Analyst

City Of Edmonton; Edmonton; Hybrid; CAD 38,000 - 49,000; Full time

Job summary

Join the City of Edmonton as a Business Analyst, where you will utilize your skills in data analysis and process improvement to enhance municipal operations. This role involves data extraction, validation, and performance tracking to inform strategic decisions and improve services. If you have a Bachelor's in a relevant field and 2 years of experience, we encourage you to apply for this opportunity in a dynamic work environment that values equity and inclusion.

Qualifications

• Minimum 2 years of experience in data analysis and performance tracking.
• Experience in data visualization and creating dashboards.

Responsibilities

• Extract data and conduct audits for accuracy and consistency.
• Conduct research and analyze municipal best practices.
• Translate data into actionable insights through visualization.

Skills

Data extraction

Data validation

Data analysis

Data visualization

Data storytelling

Quantitative research

Qualitative research

Statistical techniques

Collaboration

Problem solving

Education

Bachelor's degree in business administration or related field

Tools

MS SQL

Oracle SQL

Tableau Desktop

Tableau Public

Job description

Help us shape the future of Edmonton! Are you a highly motivated person looking to make a difference? Do you have a passion for data analysis, data storytelling, performance measurement, and business process improvement? If so, then we want to hear from you.

The Department Strategy section is responsible for coordinating analytics, reporting, business planning, and strategy development for the Office of the City Manager and Financial and Corporate Services Departments. As a Business Analyst, you will play a key role in supporting these activities by providing expertise in research, qualitative and quantitative analysis and providing recommendations on business process improvement.

What will you do?

• Data Extraction and Validation: Extract data from various systems and conduct audits to ensure accuracy, quality and consistency across all sources
• Research and Data Analysis: Conduct research, environmental scans, benchmarking, identify trends, and analyze issues related to municipal best practices and performance. Perform data analysis and generate comprehensive reports to support data-driven decision making and provide actionable recommendations
• Data Storytelling: Translate raw data into compelling narratives by making complex information comprehendable, accessible and actionable for the audience
• Performance Measures Tracking: Monitor and evaluate performance metrics to ensure alignment with organizational goals and identity areas of improvements
• Data Visualization and Presentation: Report and visualize complex data, develop and maintain interactive dashboards for performance management reporting, create presentation materials with data visualizations
• Process Mapping and Analysis: Develop process maps and analyze existing business processes to identify areas for improvement
• Collaboration and Communication Collaborate with cross-functional teams to translate data insights into actionable strategies and provide support for their successful implementation
• Other duties as required

Qualifications

• Bachelor's degree in business administration, management information systems, management, economics, statistics, or a related field
• 2 years of diversified and progressive experience in the area of data analysis, performance tracking, and business process improvement with a focus on extracting insights, visualizing complex data, creating dashboards and enabling data-driven decision making

Assets:

• Experience with data extraction/querying tools such as MS/Oracle SQL and data visualization tools including Tableau Public and Desktop

Skills required for success:

• Proficiency in data extraction, validation and analysis, including statistical techniques and data manipulation
• Strong skills in data storytelling, visualization and presentation, with the ability to create dashboard and reports
• Excellent written and verbal communication skills to present findings and support decision making
• Analytical and problem solving skills to identify areas of improvement
• Collaboration and relationship building skills to work effectively with various levels across departments
• .Ability to work independently and as part of a team
• Ability to manage multiple priorities and meet deadlines
• Alignment to our Cultural Commitments and Leadership Competencies (https://bit.ly/4brRrXm)
• Embracing a culture of equity, diversity, reconciliation and inclusion
• Applicants may be tested
  

Work Environment:

• 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 52.
• 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.

The 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 [e-mail]. Learn more about our benefits https://bit.ly/COEbenefits

Up to 1 Permanent Full time position

Hours of Work: 40 hours per week
Salary Range: $38.908 - $48.609 (Hourly); $81,239.90 - $101,495.59 (Annually)
Salary ranges are in the process of being updated in accordance with the recently ratified collective agreement between the City and CSU 52and will be forthcoming shortly.

Talent Acquisition Consultant: SM / SB

Classification Title: Methods Analyst I - 8hrs
Posting Date: Jun 27, 2025
Closing Date: July 11, 2025 11:59pm (MDT)
Number of Openings (up to): 1 - Permanent Full-time
Union: CSU 52
Department: Office of the City Manager
Work Location(s): Century Place, 12th Floor, 9803 - 102A Avenue Edmonton T5J 3A3