Celonis Data Analyst

Citigroup Inc

Contract Warren, New Jersey, United States Posted 1 year ago

 Write a Review Add Vendor   Add Contact  

About Position

Celonis Data Analyst (Contract)

$60.00 / Hourly

Warren, New Jersey, United States

Celonis Data Analyst

Contract Warren, New Jersey, United States Posted 1 year ago

Description

A person that can build analysis views and dashboards in the Celonis front end using the drag-and-drop feature & Celonis’ PQL coding language.
This person is also the point of contact with the business stakeholders through the Business Liaison to understand their exact needs (views, KPIs, etc.) and work collaboratively to build relevant components
Conduct data validation sessions to ensure what the team sees in Celonis is meaningful and reflects the raw data in an accurate transformed manner. These validations are done by collaborating with the business stakeholders.
Ability to wireframe a view / dashboard before building it to gain alignment from the business stakeholders but questioning the exact value story it will and how it will be helpful to accomplish the business team’s goals
Collaborate with a Value Architect to conduct value framing sessions where insights for improvements are found and help build operational elements in Celonis that will help the business in their day-to-day work
Skills required – Celonis’ PQL coding platform

By applying to a job using PingJob.com you are agreeing to comply with and be subject to the PingJob.com Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.

Questions / Comments:

Display Questions / Comments:

No Questions / comments

Citigroup Inc Vendors

( Login to see all the 72 vendors)
TEK Systems
Write a Review

971 Corporate Boulevard
Linthicum
Maryland
www.teksystems.com ( 85 vendors)

Kforce Professional Staffing Firm
Write a Review

1001 E Palm Avenue
Tampa
Florida
www.kforce.com ( 82 vendors)

Wipro Technologies
Write a Review

1300 Crittenden Lane
Mountain View
California
www.wipro.com ( 61 vendors)

Job Summary

$60.00 / Hourly

Contract

Warren, New Jersey, United States

Experience Level : Medium

Experience Required : 7 Year/s

Only Any

Posted : 1 year ago

Deadline : May 16, 2023 1 year ago

Job ID : Job0000002414

Citigroup Inc

399 Park Ave

www.citi.com

Request history8.1.32PHP Version2.14sRequest Duration695MBMemory UsageGET {slug}Route
    • Booting (1.88s)time
    • Application (264ms)time
    • 1 x Booting (87.7%)
      1.88s
      1 x Application (12.3%)
      264ms
      3 templates were rendered
      • frontend.job-viewjob-view.blade.php#?blade
      • admin.flash_msgflash_msg.blade.php#?blade
      • layouts.themetheme.blade.php#?blade
      uri
      GET {slug}
      middleware
      web
      controller
      App\Http\Controllers\JobController@view
      namespace
      prefix
      where
      as
      job_view
      file
      app/Http/Controllers/JobController.php:482-507
      11 statements were executed193ms
      • JobController.php#484clientfyi_final2.75msselect * from `jobs` where `job_slug` = 'celonis-data-analyst' limit 1
        Bindings
        • 0: celonis-data-analyst
        Backtrace
        • app/Http/Controllers/JobController.php:484
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • User.php#78clientfyi_final83.35msselect `id`, `company` from `users` where `user_type` in ('employer', 'agent') order by `id` desc
        Bindings
        • 0: employer
        • 1: agent
        Backtrace
        • app/Models/User.php:78
        • app/Http/Controllers/JobController.php:491
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • JobController.php#493clientfyi_final570μsselect * from `users` where `users`.`id` = 16790 limit 1
        Bindings
        • 0: 16790
        Backtrace
        • app/Http/Controllers/JobController.php:493
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • Vendor.php#57clientfyi_final1.12msselect count(*) as aggregate from `vendors` inner join `users` on `vendors`.`vendor_id` = `users`.`id` inner join `states` on `users`.`state_id` = `states`.`id` inner join `countries` on `states`.`country_id` = `countries`.`id` where `vendors`.`approve_status` = 1 and `vendors`.`employer_id` = 16790
        Bindings
        • 0: 1
        • 1: 16790
        Backtrace
        • app/Models/Vendor.php:57
        • app/Http/Controllers/JobController.php:495
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • Vendor.php#57clientfyi_final3.18msselect `vendors`.*, `users`.`website`, `users`.`company`, `users`.`address`, `users`.`city`, `states`.`state_name`, `countries`.`country_name`, (SELECT (SUM(ratings)/COUNT(id)) FROM reviews WHERE reviews.employer_id = vendors.vendor_id AND reviews.approve_status = 1) as review_rating, (SELECT COUNT(id) FROM reviews WHERE reviews.employer_id = vendors.vendor_id AND reviews.approve_status = 1) as review_count, (SELECT COUNT(id) FROM vendors as b WHERE b.employer_id = vendors.vendor_id) as vendor_count from `vendors` inner join `users` on `vendors`.`vendor_id` = `users`.`id` inner join `states` on `users`.`state_id` = `states`.`id` inner join `countries` on `states`.`country_id` = `countries`.`id` where `vendors`.`approve_status` = 1 and `vendors`.`employer_id` = 16790 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 16790
        Backtrace
        • app/Models/Vendor.php:57
        • app/Http/Controllers/JobController.php:495
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • JobController.php#500clientfyi_final370μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 16790
        Bindings
        • 0: 1
        • 1: 16790
        Backtrace
        • app/Http/Controllers/JobController.php:500
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • job-view.blade.php#17clientfyi_final10.41msselect DISTINCT email from `job_applications` where `category_id` = 39 and `status` = 1
        Bindings
        • 0: 39
        • 1: 1
        Backtrace
        • view::frontend.job-view:17
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • job-view.blade.php#450clientfyi_final350μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 2414 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 2414
        Backtrace
        • view::frontend.job-view:450
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • theme.blade.php#101clientfyi_final790μsselect * from `categories` where `job_count` >= 1 order by `job_count` desc
        Bindings
        • 0: 1
        Backtrace
        • view::layouts.theme:101
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • theme.blade.php#102clientfyi_final47.12msSELECT jobs.state_id,jobs.state_name, COUNT(*) AS numberOfSales FROM jobs JOIN states ON states.id = jobs.state_id GROUP BY jobs.state_id,jobs.state_name ORDER BY COUNT(*) DESC limit 15
        Backtrace
        • view::layouts.theme:102
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • theme.blade.php#103clientfyi_final43.09msSELECT jobs.city_id,jobs.city_name, COUNT(*) AS numberOfcities FROM jobs JOIN cities ON cities.id = jobs.city_id GROUP BY jobs.city_id,jobs.city_name ORDER BY COUNT(*) DESC limit 15
        Backtrace
        • view::layouts.theme:103
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      App\Models\Category
      138Category.php#?
      App\Models\Job
      1Job.php#?
      App\Models\User
      1User.php#?
          _token
          fwUEZ1QijK34QVTS9vtcUx1pVMUAiyh43UpgBH3j
          _previous
          array:1 [ "url" => "https://pingjob.com/celonis-data-analyst" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /celonis-data-analyst
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          []
          
          request_request
          []
          
          request_headers
          0 of 0
          array:18 [ "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "close" ] "x-accel-internal" => array:1 [ 0 => "/internal-nginx-static-location" ] "x-real-ip" => array:1 [ 0 => "13.59.46.202" ] "host" => array:1 [ 0 => "pingjob.com" ] ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:7 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "private, must-revalidate" ] "date" => array:1 [ 0 => "Mon, 21 Apr 2025 16:27:39 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IndhTmJocUNPaDZjVkNmUGNWY1NJYUE9PSIsInZhbHVlIjoiYzlIN0tvclZIUHNZMFMyT2ZYdjhGM2JHeGQzZWZFVjZDRU1tQWZGN0pici8zZEF6ODFIdHNqbDNEMmdud3lxME9oQTEyakF6VlRma3pZSWtJei8raWxBa3ViMy9PQTlnVVZNNHB3cElhQi9YcUlrVUNINTVBMWVMRi9EU0EvbHAiLCJtYWMiOiIwZmFmNTk1OWYzNDMwODQ5YzA0YmQ5YTk0NjA3M2IzNTJiMjBlYjk0MjFiZmMzOTA2YWM2ZTZhMDc1NzNiMDA1IiwidGFnIjoiIn0%3D; expires=Mon, 21 Apr 2025 18:27:39 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IndhTmJocUNPaDZjVkNmUGNWY1NJYUE9PSIsInZhbHVlIjoiYzlIN0tvclZIUHNZMFMyT2ZYdjhGM2JHeGQzZWZFVjZDRU1tQWZGN0pici8zZEF6ODFIdHNqbDNEMmdud3lxME9oQTEya" 1 => "laravel_session=eyJpdiI6IjhWbmJKdlJDNDh1QVYzdEx1d2h2L1E9PSIsInZhbHVlIjoiNmEzcmpLYW9LSDMwd0R2b1BRaWE4QUhNbCt1b2NuUTZVUlM5OWZuNzJtdFNYZTc0dTQ3NnNvbTFObFltMkVrdHQzdHREQkpCaXBXNy8xN1cxSmR6S1N4bGJoZ1k2OWlycHZrOHY2djFwN0lkR0RJTWJaN3lvMDI2RnJub3YvQmsiLCJtYWMiOiI1M2FlYzVkNjliMjE4YmU1NzlhMzRjZjQyNzk3MjZlYjZjMDE2Y2Q4ODI2ODFhODY2ZGU5ZWY4NjNhYmZlMWM3IiwidGFnIjoiIn0%3D; expires=Mon, 21 Apr 2025 18:27:39 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IjhWbmJKdlJDNDh1QVYzdEx1d2h2L1E9PSIsInZhbHVlIjoiNmEzcmpLYW9LSDMwd0R2b1BRaWE4QUhNbCt1b2NuUTZVUlM5OWZuNzJtdFNYZTc0dTQ3NnNvbTFObFltMkVrdHQz" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IndhTmJocUNPaDZjVkNmUGNWY1NJYUE9PSIsInZhbHVlIjoiYzlIN0tvclZIUHNZMFMyT2ZYdjhGM2JHeGQzZWZFVjZDRU1tQWZGN0pici8zZEF6ODFIdHNqbDNEMmdud3lxME9oQTEyakF6VlRma3pZSWtJei8raWxBa3ViMy9PQTlnVVZNNHB3cElhQi9YcUlrVUNINTVBMWVMRi9EU0EvbHAiLCJtYWMiOiIwZmFmNTk1OWYzNDMwODQ5YzA0YmQ5YTk0NjA3M2IzNTJiMjBlYjk0MjFiZmMzOTA2YWM2ZTZhMDc1NzNiMDA1IiwidGFnIjoiIn0%3D; expires=Mon, 21-Apr-2025 18:27:39 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IndhTmJocUNPaDZjVkNmUGNWY1NJYUE9PSIsInZhbHVlIjoiYzlIN0tvclZIUHNZMFMyT2ZYdjhGM2JHeGQzZWZFVjZDRU1tQWZGN0pici8zZEF6ODFIdHNqbDNEMmdud3lxME9oQTEya" 1 => "laravel_session=eyJpdiI6IjhWbmJKdlJDNDh1QVYzdEx1d2h2L1E9PSIsInZhbHVlIjoiNmEzcmpLYW9LSDMwd0R2b1BRaWE4QUhNbCt1b2NuUTZVUlM5OWZuNzJtdFNYZTc0dTQ3NnNvbTFObFltMkVrdHQzdHREQkpCaXBXNy8xN1cxSmR6S1N4bGJoZ1k2OWlycHZrOHY2djFwN0lkR0RJTWJaN3lvMDI2RnJub3YvQmsiLCJtYWMiOiI1M2FlYzVkNjliMjE4YmU1NzlhMzRjZjQyNzk3MjZlYjZjMDE2Y2Q4ODI2ODFhODY2ZGU5ZWY4NjNhYmZlMWM3IiwidGFnIjoiIn0%3D; expires=Mon, 21-Apr-2025 18:27:39 GMT; path=/; httponlylaravel_session=eyJpdiI6IjhWbmJKdlJDNDh1QVYzdEx1d2h2L1E9PSIsInZhbHVlIjoiNmEzcmpLYW9LSDMwd0R2b1BRaWE4QUhNbCt1b2NuUTZVUlM5OWZuNzJtdFNYZTc0dTQ3NnNvbTFObFltMkVrdHQz" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "fwUEZ1QijK34QVTS9vtcUx1pVMUAiyh43UpgBH3j" "_previous" => array:1 [ "url" => "https://pingjob.com/celonis-data-analyst" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-21 16:27:39GET/celonis-data-analyst311140