Data Analyst

3 weeks ago

Edmonton, Canada City of Edmonton Full time

**Data Analyst**

**Job Number***:
**45388**

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.

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

- 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
- Do analysis work in spreadsheets often with hundreds of thousands lines of data
- Create dashboards and reports using Tableau
- 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 test scripts and conducts testing to ensure the data is accurate and the dashboard is functioning properly
- Create documentation for the reports including logic, methodologies and business signoff
- Prepare and present narratives and explanations to accompany statistical data
- Build effective working relationships with the network of stakeholders within the branch
- Prepare monthly reporting and ad hoc analyses for internal and external clients
- Research new reporting styles and techniques including visual presentation best practices and assist with the development of standard practices and processes for data collection
- Identify data issues; work with the business and IT to recommend solutions, initiate resolutions
- Coach and mentor other members of the team to enhance team capabilities
- Perform other related duties as required

**Qualifications**:

- University Degree in Commerce, Computer Science or related discipline (specializing in data analytics, statistical modeling and data visualization) from a recognized educational institution
- Minimum 2 years experience in an operational environment, with a focus on data analysis and data validation as well as performance and financial measurement
- Proficiency with MS Excel, Google Suite, SQL and Tableau is required
- Experience with automated data extraction, analysis and and dashboard building
- Proficiency in modeling, operational and statistical research
- Strong mathematical skills with the ability to interpret data
- Ability to express ideas and concepts effectively, both oral and written
- Ability to work independently under broad direction
- Knowledge of work methods, studies and analytical procedures, practices and terminology related to the Fleet and Facility Services businesses
- 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 will be required
- Demonstrate service excellence, embracing diversity and promoting inclusiveness
- 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 edmonton.ca/our-culture
- Demonstrate the foundational competencies, key behaviours 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 edmonton.ca/our-culture
- Applicants may be tested

For more information, please refer to our COVID-19 Vaccination Policy (bit.ly/3lKwb6j) and COVID-19 Vaccination Procedure (bit.ly/39BICMt).

**_Up to 3 permanent full-time position_**

**Hours of Work**: 40 hours per week; Monday to Friday

**Salary Range**: $36.577 - $45.697 (Hourly); $76,372.780 - $95,415.340 (Annually)

**Talent Acquisition Consultant**: AW/SK

**Classification Title***: Met

  • Data Analyst

    1 month ago

    Edmonton, Canada University of Alberta Full time

    **VER Development & Alumni Rel.**: - Competition No. **S113151548** - Posting Date **Jul 21, 2023** - Closing Date **Aug 11, 2023** - Position Type **Full Time - Operating Funded** - Salary Range **$59,408 to $82,223 per year** - Grade **10** - Hours **35** This position is a part of the Non-Academic Staff Association (NASA). This position offers a...

  • Data Analyst

    1 month ago

    Edmonton, Canada Gateway Builders Full time

    We are seeking a highly skilled and motivated Data Analyst to join our growing company. The Data Analyst will play a key role in helping us to make data-driven decisions, optimize our operations, and improve our bottom line. Key Responsibilities: - Collect, clean, and analyze large sets of data from various sources, including project management software,...

  • Analyst, Data

    4 weeks ago

    Edmonton, Canada EPCOR Full time

    Highlights of the job We are hiring a full-time, permanent **Analyst, Data** position working out of Edmonton, AB. The Analyst, Data is responsible for supporting optimal adoption of systems and use of data for decision making across EPCOR Water Services (EWS). The Analyst, Data will utilize business intelligence tools, data pipeline tools, code, data...

  • Data Analyst

    1 week ago

    Edmonton, Canada University of Alberta Full time

    **Department** VER Development and Alumni Relations **Salary range** $60,299.77 to $83,456.99 **Hours per week** 35 **Grade** 10 **Posted date** May 22, 2024 **Closing date** June 5, 2024 **Position Type** Full Time - Operating Funded **Description**: **_This position is a part of the Non-Academic Staff Association (NASA)._** This position offers a...

  • Analyst (Data)

    4 weeks ago

    Edmonton, Canada Alberta Medical Association Full time

    The Alberta Medical Association is currenting recruiting for a full-time **Data Analyst**, with extensive experience in Power BI,to join our Accelerating Change Transformation Team (ACTT). The AMA Accelerating Change Transformation Team (ACTT) supports physicians and other clinical team members, improve care delivery within their practice...

  • Data Analyst

    1 month ago

    Edmonton, Canada Bird Construction Full time

    Data Analyst Where Greatness Grows The greatest achievements in history are borne from the greatness within people - where human potential meets vision, and passion fuels evolution. Unlocking this potential is the most important thing we do at Bird. As a leader in Canadian construction for over 100 years, the impact of our team is etched deeply within the...

  • Data Analyst

    2 days ago

    Edmonton, Canada ATB Financial Full time

    **Our bottom line is different.** There’s something special about working at ATB, and it’s been recognized on every top employer list that matters. Maybe it’s our exceptional culture where your total wellness is supported through market-leading benefits and you’re free to bring your whole self to work. Maybe it’s our commitment to a growth mindset...

  • Data Analyst

    4 days ago

    Edmonton, Canada Litco Law Full time

    Business Applications and Technology Services – Data Analytics / At Litco Law, we are known for our extraordinary and unsurpassed firm culture – and for the people behind that culture. We’ve been recognized as a Canadian Top Employer and as one of Canada’s Most Admired Corporate Cultures and know that this kind of success only happens when...

  • Data Analyst

    4 days ago

    Edmonton, Canada Litco Law Full time

    Business Applications and Technology Services – Data Analytics / At Litco Law, we are known for our extraordinary and unsurpassed firm culture – and for the people behind that culture. We’ve been recognized as a Canadian Top Employer and as one of Canada’s Most Admired Corporate Cultures and know that this kind of success only happens when...

  • Data Solutions Analyst

    1 month ago

    Edmonton, Canada Government of Alberta Full time

    **Job Information** Job Requisition ID: 53303 Ministry: Treasury Board & Finance Location: EDMONTON Full or Part-Time: Full Time Hours of Work: 36.25 hours per week Permanent/Temporary: Ongoing Scope: Open Competition Closing Date: February 12, 2024 Classification: Program Services 4 **Salary**: $ 2,757.39 to $3,604.16 bi-weekly ($71,967 - $ 94,068...

  • Data Platform Analyst

    1 month ago

    Edmonton, Canada Government of Alberta Full time

    **Job Information**: Job Requisition ID: 45419 Ministry: Technology and Innovation Location: Edmonton Full or Part-Time: Full-Time Hours of Work: 36.25 hours per week Regular/Temporary: Regular Scope: Open Competition Closing Date: August 28, 2023 Classification: Systems Analyst Level 2 (Opted Out & Excluded ) **About Us**: The Data, Privacy and...

  • Data Analyst

    1 month ago

    Edmonton, Canada ATCO Group Full time

    **Position**:Data Analyst** **Division: Operational Technology, Natural Gas** **Location**:Edmonton, AB** **Description**: This role will provide the leadership team with focused, timely assessments and recommended actions to increase the strategic impact/overall benefits. The incumbent will provide advice through data modeling and develop and implement...

  • Data Analyst

    1 week ago

    Edmonton, Canada University of Alberta Full time

    **Department** Faculty of Medicine & Dentistry - Department of Emergency Medicine **Salary range** $60,299.77 to $83,456.99 **Hours per week** 35 **Grade** 10 **Posted date** May 22, 2024 **Closing date** June 5, 2024 **Position Type** Full Time - Trust Funded **Description**: This position is a part of the Non-Academic Staff Association (NASA). This...

  • Data Operator and Analyst

    1 month ago

    Edmonton, Canada PIP360 AIMS Full time

    **Job Purpose** **Duties & Responsibilities** The day-to-day contributions include practical solutions to engineering problems in the area of automated condition monitoring of industrial assets, data processing and analysis algorithms, and software implementations of these algorithms, client reports, and technical documentation. The Data Operator and...

  • Data Analyst

    4 weeks ago

    Edmonton, Canada City of Edmonton Full time

    **Data Analyst / Methods Analyst I** **Job Number***: **45352** The Planning and Permitting team is responsible for the oversight and execution of strategic planning, business and program development, project management, business intelligence / analytics and stewardship of key performance indicators on behalf of the Traffic Operations section. Reporting...

  • Data Analyst

    4 weeks ago

    Edmonton, Canada City of Edmonton Full time

    Data Analyst / Methods Analyst I Job Number : 45352 The Planning and Permitting team is responsible for the oversight and execution of strategic planning, business and program development, project management, business intelligence / analytics and stewardship of key performance indicators on behalf of the Traffic Operations section. Reporting to the...

  • Data Analyst/Programmer

    1 month ago

    Edmonton, Canada Recooty Full time

    The Data Analyst / Programmer fulfils a dual role primarily focused on working with large data sets to answer business questions, availing the results of transformations and analysis to management and users through various reporting tools. The Data Analyst / Programmer is also involved in programming and troubleshooting/maintaining/testing software to...

  • Data Analyst/Programmer

    1 month ago

    Edmonton, Canada Recooty Full time

    The Data Analyst / Programmer fulfils a dual role primarily focused on working with large data sets to answer business questions, availing the results of transformations and analysis to management and users through various reporting tools. The Data Analyst / Programmer is also involved in programming and troubleshooting/maintaining/testing software to...

  • Data Analyst/Programmer

    1 month ago

    Edmonton, Canada Recooty Full time

    The Data Analyst / Programmer fulfils a dual role primarily focused on working with large data sets to answer business questions, availing the results of transformations and analysis to management and users through various reporting tools. The Data Analyst / Programmer is also involved in programming and troubleshooting/maintaining/testing software to...

  • Data Product Delivery Analyst

    4 weeks ago

    Edmonton, Canada Government of Alberta Full time

    **Job Information**: Job Requisition ID: 35804 Ministry: Technology and Innovation Location: Edmonton (remote work available) Full or Part-Time: Full Time Hours of Work: 36.25 hours per week Regular/Temporary: Permanent Scope: Open Competition Closing Date: January 6, 2023 Classification: Opted Out & Excluded Systems Analyst Level 3 **About...