Data Analyst

Cox Automotive Inc

Contract Atlanta, Georgia, United States Posted 2 months ago

 Write a Review Add Vendor   Add Contact  

About Position

Data Analyst (Contract)

$65.00 / Hourly

Atlanta, Georgia, United States

Data Analyst

Contract Atlanta, Georgia, United States Posted 2 months ago

Description

Provide/ Review analytics requirements, validate tagging specifications and perform data validation and UAT to ensure future downstream analyses needed to generate insights (will need to learn and use Cox Automotive Tagging Implementation)
Monitoring reporting and/or ad-hoc analyses using Amplitude dashboards
Provide ad-hoc analyses from Snowflake (SQL Queries) and present analyses in a cohesive insights story
Ability to clearly communicate findings in writing and/or in presentation format
Strong organizational skills and ability to effectively prioritize in a deadline-driven atmosphere
Experience with PXL Tagging - Google Tag Manager

Responsibilities
  • Intermediate SQL programming skills and knowledge of SQL-based relational databases (Snowflake is preferred)
  • Intermediate Web Analytics Knowledge (Amplitude is Preferred tool, Google Analytics or Adobe Analytics ok)
  • Microsoft Office Suite (specifically strong Excel proficiency)
  • BI Tool experience (E.g. Microsoft PowerBI, Domo, Tableau, etc.)

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

Cox Automotive Inc Vendors

( Login to see all the 6 vendors)
Apex Systems Inc
Write a Review

4400 Cox Road
Glen Allen
Virginia
www.ApexSystemsInc.com ( 9 vendors)

Ness Technologies
Write a Review

300 Frank W. Burr Boulevard 7th Floor
Teaneck
New Jersey
www.ness.com ( 3 vendors)

Genpact
Write a Review

1251 Avenue of the Americas Suite 4100
New York
New York
www.Genpact.com ( 3 vendors)

Job Summary

$65.00 / Hourly

Contract

Atlanta, Georgia, United States

Experience Level : Medium

Experience Required : 10 Year/s

Only Any

Posted : 2 months ago

Deadline : February 4, 2025 2 months ago

Job ID : Job0000022073

Cox Automotive Inc

3003 Summit Blvd., Suite 200

www.coxautoinc.com

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.32PHP Version2.01sRequest Duration695MBMemory UsageGET {slug}Route
    • Booting (1.73s)time
    • Application (281ms)time
    • 1 x Booting (86.06%)
      1.73s
      1 x Application (13.94%)
      281ms
      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 executed209ms
      • JobController.php#484clientfyi_final22.97msselect * from `jobs` where `job_slug` = 'data-analyst-34' limit 1
        Bindings
        • 0: data-analyst-34
        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_final76.23msselect `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_final630μsselect * from `users` where `users`.`id` = 51734 limit 1
        Bindings
        • 0: 51734
        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_final600μsselect 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` = 51734
        Bindings
        • 0: 1
        • 1: 51734
        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_final890μsselect `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` = 51734 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 51734
        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_final320μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 51734
        Bindings
        • 0: 1
        • 1: 51734
        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.91msselect 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_final370μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 22073 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 22073
        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_final670μ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_final49.86msSELECT 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_final45.9msSELECT 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
          JJ9EKNYXPpEEsN0q3bv6PLxae28XxvxcgnmdiVIs
          _previous
          array:1 [ "url" => "https://pingjob.com/data-analyst-34" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /data-analyst-34
          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 => "3.16.165.149"
  ]
  "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 => "Wed, 23 Apr 2025 07:35:26 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImNHQ0JsdUdMaDduUHFOWkVqSDZlcEE9PSIsInZhbHVlIjoiNUJNSUZZZk1YVFJEWmJGd2Y0VGY1L3VhUW5sRW5wQWZGL1gzaWhLMDJqaUt5eGduUzU5elJwTU9Wa1NsM1FPWC85RWZPc1NLc3I0bXMvK2tHSmxMRi9DRk9yN1V3NVlISXptTjc0NTJMbTRERjMwbWJpanNwb2VXRDFVRXpYYVAiLCJtYWMiOiJmNDgyYTM1NDgyNjJjNjQwNDQ3NWRmOGYwOGQ2MjJjZTdkYmExY2FiZDRlM2RkZmVkMGI0YjYzMmMwZTRhMDMxIiwidGFnIjoiIn0%3D; expires=Wed, 23 Apr 2025 09:35:26 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImNHQ0JsdUdMaDduUHFOWkVqSDZlcEE9PSIsInZhbHVlIjoiNUJNSUZZZk1YVFJEWmJGd2Y0VGY1L3VhUW5sRW5wQWZGL1gzaWhLMDJqaUt5eGduUzU5elJwTU9Wa1NsM1FPWC85RWZPc ▶"
    1 => "laravel_session=eyJpdiI6IlR5QTZrT0FGVnJQMkQ0cU02ckNlOFE9PSIsInZhbHVlIjoicXlDQU5oc2VMdVk1alg5a3Zab2lFbzdTOUpWd1hFckZjNHpHZWZSWVJvUTNPd3paM2V0SUxYVHMzdmMvWm9sbFM5b3IrS2hGMEU0RlEraE03cjVlYWNWdE5KZTU3aks1R0VVNk1MTVZnMVNwTjNaZUZJdFhuOWNZZTFBaHA3eFciLCJtYWMiOiIwNGE2NGYzZjgyNzkyMDcyNWIyMTY4ZDU2ODA2MWQyZjdkNTQ5MDEwMjM2YTA3YmY1YTcyMDQwMzM0OTUyMTUxIiwidGFnIjoiIn0%3D; expires=Wed, 23 Apr 2025 09:35:26 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IlR5QTZrT0FGVnJQMkQ0cU02ckNlOFE9PSIsInZhbHVlIjoicXlDQU5oc2VMdVk1alg5a3Zab2lFbzdTOUpWd1hFckZjNHpHZWZSWVJvUTNPd3paM2V0SUxYVHMzdmMvWm9sbFM5 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImNHQ0JsdUdMaDduUHFOWkVqSDZlcEE9PSIsInZhbHVlIjoiNUJNSUZZZk1YVFJEWmJGd2Y0VGY1L3VhUW5sRW5wQWZGL1gzaWhLMDJqaUt5eGduUzU5elJwTU9Wa1NsM1FPWC85RWZPc1NLc3I0bXMvK2tHSmxMRi9DRk9yN1V3NVlISXptTjc0NTJMbTRERjMwbWJpanNwb2VXRDFVRXpYYVAiLCJtYWMiOiJmNDgyYTM1NDgyNjJjNjQwNDQ3NWRmOGYwOGQ2MjJjZTdkYmExY2FiZDRlM2RkZmVkMGI0YjYzMmMwZTRhMDMxIiwidGFnIjoiIn0%3D; expires=Wed, 23-Apr-2025 09:35:26 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImNHQ0JsdUdMaDduUHFOWkVqSDZlcEE9PSIsInZhbHVlIjoiNUJNSUZZZk1YVFJEWmJGd2Y0VGY1L3VhUW5sRW5wQWZGL1gzaWhLMDJqaUt5eGduUzU5elJwTU9Wa1NsM1FPWC85RWZPc ▶"
    1 => "laravel_session=eyJpdiI6IlR5QTZrT0FGVnJQMkQ0cU02ckNlOFE9PSIsInZhbHVlIjoicXlDQU5oc2VMdVk1alg5a3Zab2lFbzdTOUpWd1hFckZjNHpHZWZSWVJvUTNPd3paM2V0SUxYVHMzdmMvWm9sbFM5b3IrS2hGMEU0RlEraE03cjVlYWNWdE5KZTU3aks1R0VVNk1MTVZnMVNwTjNaZUZJdFhuOWNZZTFBaHA3eFciLCJtYWMiOiIwNGE2NGYzZjgyNzkyMDcyNWIyMTY4ZDU2ODA2MWQyZjdkNTQ5MDEwMjM2YTA3YmY1YTcyMDQwMzM0OTUyMTUxIiwidGFnIjoiIn0%3D; expires=Wed, 23-Apr-2025 09:35:26 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IlR5QTZrT0FGVnJQMkQ0cU02ckNlOFE9PSIsInZhbHVlIjoicXlDQU5oc2VMdVk1alg5a3Zab2lFbzdTOUpWd1hFckZjNHpHZWZSWVJvUTNPd3paM2V0SUxYVHMzdmMvWm9sbFM5 ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "JJ9EKNYXPpEEsN0q3bv6PLxae28XxvxcgnmdiVIs"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/data-analyst-34"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-23 07:35:26GET/data-analyst-34311140