Data Analyst

The College Board

Contract New York, New York, United States Posted 1 year ago

 Write a Review Add Vendor   Add Contact  

About Position

Data Analyst (Contract)

$70.00 / Hourly

New York, New York, United States

Data Analyst

Contract New York, New York, United States Posted 1 year ago

Skills
SQL AWS Athena Lambda Dynamo
Description

9+ years of experience as a Data Analyst

Must have Strong Experience in SQL

Must have Strong Experience in AWS

Must have Strong Experience in Athena

Must have Strong Experience in Lambda

Must have Strong Experience in Dynamo

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

The College Board Vendors

( Login to see all the 4 vendors)
Comsys Information Technology Services Inc
Write a Review

4400 Post Oak Parkway #1800
Houston
Texas
www.comsys.com ( 112 vendors)

Cognizant Technology Solutions Corporation
Write a Review

500 Frank W. Burr Boulevard
Teaneck
New Jersey
www.Cognizant.com ( 50 vendors)

Datanomics Inc
Write a Review

200 Centennial Avenue Suite 140
Piscataway
New Jersey
www.datanomics.com ( No vendors )

Job Summary

$70.00 / Hourly

Contract

New York, New York, United States

Experience Level : Medium

Experience Required : 7 Year/s

Only Any

Posted : 1 year ago

Deadline : September 5, 2023 1 year ago

Job ID : Job0000009322

The College Board

45 Columbus Avenue

212-713-8000

www.collegeboard.com

Request history8.1.31PHP Version2.63sRequest Duration688MBMemory UsageGET {slug}Route
    • Booting (2.36s)time
    • Application (268ms)time
    • 1 x Booting (89.8%)
      2.36s
      1 x Application (10.2%)
      268ms
      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 executed200ms
      • JobController.php#484clientfyi_final8.56msselect * from `jobs` where `job_slug` = 'data-analyst-12' limit 1
        Bindings
        • 0: data-analyst-12
        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_final89.53msselect `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_final940μsselect * from `users` where `users`.`id` = 5688 limit 1
        Bindings
        • 0: 5688
        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_final590μ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` = 5688
        Bindings
        • 0: 1
        • 1: 5688
        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_final1.43msselect `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` = 5688 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 5688
        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` = 5688
        Bindings
        • 0: 1
        • 1: 5688
        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_final11.93msselect 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_final410μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 9322 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 9322
        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_final950μ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_final45.59msSELECT 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_final40.05msSELECT 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
          vcl5mRo4LcE1vnwrVZqpbTrNvqKgpp1rc60WfmPw
          _previous
          array:1 [ "url" => "https://pingjob.com/data-analyst-12" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /data-analyst-12
          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:25 [ "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" ] "cdn-loop" => array:1 [ 0 => "cloudflare; loops=1" ] "priority" => array:1 [ 0 => "u=0, i" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "cf-connecting-ip" => array:1 [ 0 => "3.128.188.223" ] "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" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "cf-visitor" => array:1 [ 0 => "{"scheme":"https"}" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "cf-ipcountry" => array:1 [ 0 => "US" ] "accept-encoding" => array:1 [ 0 => "gzip, br" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "cf-ray" => array:1 [ 0 => "918cce41ff02114d-ORD" ] "connection" => array:1 [ 0 => "close" ] "x-accel-internal" => array:1 [ 0 => "/internal-nginx-static-location" ] "x-forwarded-for" => array:1 [ 0 => "3.128.188.223" ] "x-real-ip" => array:1 [ 0 => "172.69.59.134" ] "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 => "Fri, 28 Feb 2025 01:57:48 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InBCeG8vU0lQbnBlWUVROFloVG1ta0E9PSIsInZhbHVlIjoiTDZZM3ZVYXhvOHZEcGpGOHFKK0cyL0NrQ0pCNDczVXAwTnYrbTkzUGJvakMwWEg1NmhUWHBnTVJLcUdSYVhBUDhZd3dTUldnVCtnMHhsQWUybVZzNGlNQ00xTUhCeTFYbmcvVVdSSFJuVGFrNlRWRVJwUGR6b3lzbkhaRW43MnMiLCJtYWMiOiJkZjFjYjBkNDU3NDFmMmQ2YjBlNjdjNmE3ZWViNWU2NmUzMWU1NjU3ZjgxMzdhOGRjODllN2I4YzMzZGI1MzAwIiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 03:57:48 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6InBCeG8vU0lQbnBlWUVROFloVG1ta0E9PSIsInZhbHVlIjoiTDZZM3ZVYXhvOHZEcGpGOHFKK0cyL0NrQ0pCNDczVXAwTnYrbTkzUGJvakMwWEg1NmhUWHBnTVJLcUdSYVhBUDhZd3dTU" 1 => "laravel_session=eyJpdiI6IjhRN2FnbDFwcGcrYlExem5hdGsyRGc9PSIsInZhbHVlIjoiazB1dzY1THo0bC9HaTFSQVEycUhRYkV6b0drK2pNNURPeDJXQVh1UWVuMUhDSFNvZHBuQ3ZIdk5NSzdqaWJEQnN0VGJlWU5abVBoT3hLbGZKdVhtNys3elVJUTBmbStQLy9jckdmOE5ONTAzMTVqcGl3ZWc2ZE5HUk05Ri9CSWUiLCJtYWMiOiJjY2M1MzNkYzdkOTYzZDM0ZDdmMDkzYzQ0MGQ4NWRlZjJmNjA2NWFhODM0NmRhNzQwNDc0NGY5MGQ4YzRjOTBlIiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 03:57:48 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IjhRN2FnbDFwcGcrYlExem5hdGsyRGc9PSIsInZhbHVlIjoiazB1dzY1THo0bC9HaTFSQVEycUhRYkV6b0drK2pNNURPeDJXQVh1UWVuMUhDSFNvZHBuQ3ZIdk5NSzdqaWJEQnN0" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InBCeG8vU0lQbnBlWUVROFloVG1ta0E9PSIsInZhbHVlIjoiTDZZM3ZVYXhvOHZEcGpGOHFKK0cyL0NrQ0pCNDczVXAwTnYrbTkzUGJvakMwWEg1NmhUWHBnTVJLcUdSYVhBUDhZd3dTUldnVCtnMHhsQWUybVZzNGlNQ00xTUhCeTFYbmcvVVdSSFJuVGFrNlRWRVJwUGR6b3lzbkhaRW43MnMiLCJtYWMiOiJkZjFjYjBkNDU3NDFmMmQ2YjBlNjdjNmE3ZWViNWU2NmUzMWU1NjU3ZjgxMzdhOGRjODllN2I4YzMzZGI1MzAwIiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 03:57:48 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InBCeG8vU0lQbnBlWUVROFloVG1ta0E9PSIsInZhbHVlIjoiTDZZM3ZVYXhvOHZEcGpGOHFKK0cyL0NrQ0pCNDczVXAwTnYrbTkzUGJvakMwWEg1NmhUWHBnTVJLcUdSYVhBUDhZd3dTU" 1 => "laravel_session=eyJpdiI6IjhRN2FnbDFwcGcrYlExem5hdGsyRGc9PSIsInZhbHVlIjoiazB1dzY1THo0bC9HaTFSQVEycUhRYkV6b0drK2pNNURPeDJXQVh1UWVuMUhDSFNvZHBuQ3ZIdk5NSzdqaWJEQnN0VGJlWU5abVBoT3hLbGZKdVhtNys3elVJUTBmbStQLy9jckdmOE5ONTAzMTVqcGl3ZWc2ZE5HUk05Ri9CSWUiLCJtYWMiOiJjY2M1MzNkYzdkOTYzZDM0ZDdmMDkzYzQ0MGQ4NWRlZjJmNjA2NWFhODM0NmRhNzQwNDc0NGY5MGQ4YzRjOTBlIiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 03:57:48 GMT; path=/; httponlylaravel_session=eyJpdiI6IjhRN2FnbDFwcGcrYlExem5hdGsyRGc9PSIsInZhbHVlIjoiazB1dzY1THo0bC9HaTFSQVEycUhRYkV6b0drK2pNNURPeDJXQVh1UWVuMUhDSFNvZHBuQ3ZIdk5NSzdqaWJEQnN0" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "vcl5mRo4LcE1vnwrVZqpbTrNvqKgpp1rc60WfmPw" "_previous" => array:1 [ "url" => "https://pingjob.com/data-analyst-12" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-02-28 01:57:48GET/data-analyst-12311140