Data and Reporting Analyst

Prime Therapeutics LLC

Contract Eagan , Minnesota, United States Posted 2 months ago

 Write a Review Add Vendor   Add Contact  

About Position

Data and Reporting Analyst (Contract)

$55.00 / Hourly

Eagan , Minnesota, United States

Data and Reporting Analyst

Contract Eagan , Minnesota, United States Posted 2 months ago

Skills
Alteryx SQL Python Tableau Power BI preferred
Description

Formulate mathematical or simulation models of problems, including defining operational problems and restrictions.

Perform validation and testing of models, reformulating as necessary.

Define data requirements and gather/validate information.

Collaborate on data analysis and develop decision support software.

Focus on querying, data dumps, and building reports.

Responsibilities
  • SQL (BigQuery, DB2, Salesforce data pulls)
  • Alteryx, Python (Pandas, Numpy, Seaborn), Tableau/PowerBI
  • Healthcare/PBM data experience preferred
  • Stakeholder communication skills essential

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

Prime Therapeutics LLC Vendors

( Login to see all the 4 vendors)
Fujitsu Consulting Group Inc
Write a Review

333 Thornall Street
Edison
New Jersey
www.fujitsu.com ( 17 vendors)

Apex Systems Inc
Write a Review

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

Genesis10
Write a Review

950 Third Avenue
New York
New York
www.genesis10.com ( 5 vendors)

Job Summary

$55.00 / Hourly

Contract

Eagan , Minnesota, United States

Experience Level : Medium

Experience Required : 8 Year/s

Only Any

Posted : 2 months ago

Deadline : January 28, 2025 2 months ago

Job ID : Job000002769

Prime Therapeutics LLC

1305 Corporate Center Drive

651-846-8370

www.primetherapeutics.com

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.32PHP Version2.37sRequest Duration695MBMemory UsageGET {slug}Route
    • Booting (2.08s)time
    • Application (293ms)time
    • 1 x Booting (87.66%)
      2.08s
      1 x Application (12.34%)
      293ms
      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 executed224ms
      • JobController.php#484clientfyi_final21.02msselect * from `jobs` where `job_slug` = 'data-and-reporting-analyst-1' limit 1
        Bindings
        • 0: data-and-reporting-analyst-1
        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_final81.96msselect `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_final790μsselect * from `users` where `users`.`id` = 17620 limit 1
        Bindings
        • 0: 17620
        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` = 17620
        Bindings
        • 0: 1
        • 1: 17620
        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_final910μ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` = 17620 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 17620
        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_final410μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 17620
        Bindings
        • 0: 1
        • 1: 17620
        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.3msselect 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` = 80071 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 80071
        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_final980μ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_final48.43msSELECT 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_final57.81msSELECT 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
          hlPSxuPRmQ99KyCySzwyove99WX7qtiM2NWK8q1d
          _previous
          array:1 [ "url" => "https://pingjob.com/data-and-reporting-analyst-1" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /data-and-reporting-analyst-1
          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.144.145.77"
  ]
  "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 21:07:34 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkxqVHdjNDZDRFNsVmduVGlDV1RsWlE9PSIsInZhbHVlIjoiVU9RTEluOWlJaTZxd1RMQzdaNGhzR0YwQW92TW40SUdLYWk1UXQ3S3l3bytpVmo3NDFMaythVHdMcEVja0h5ZXdOM1lieEtpYnNIVkNQVTgxRE5pQys0ak13RkhFZHpRMHh5RUdRSVBGY3JCUXdJM1Y5bnVvQ1l0MExmV3ZTUWIiLCJtYWMiOiJiZTBjNmJkNTI4YTA5YzY5MmMyNmE3NzNmMGMxYzg2ODg0ZDg2OWFiNjhjM2ZhZTkzNWI3MWMzZDU3ZGNmNGUxIiwidGFnIjoiIn0%3D; expires=Mon, 21 Apr 2025 23:07:34 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkxqVHdjNDZDRFNsVmduVGlDV1RsWlE9PSIsInZhbHVlIjoiVU9RTEluOWlJaTZxd1RMQzdaNGhzR0YwQW92TW40SUdLYWk1UXQ3S3l3bytpVmo3NDFMaythVHdMcEVja0h5ZXdOM1lie ▶"
    1 => "laravel_session=eyJpdiI6IjVKTjFtSm5yajNkcGg5WU45VEtmTlE9PSIsInZhbHVlIjoiWjRoQkE5cXJkeDJrZzNkM3lYT2h5TXNGZDVxek1CeDNtb3ordlJIVXhEV0QrYkFTS1JwVFJNLzJ5T2J1THpnaTYwNUNEb0lPSW1PVHpvdFo1TFN5ZjJhdTRENnZHL0VEODQ1M2I0d1Bqb3hMNTRESytuc2pYRmVNems5YXhhYTgiLCJtYWMiOiI5Y2UyNzZkNGJjNDE4ZTcxMmNlMzQ3OGE0YjRiMmU2Yzk2ZDIxODVmOGRiYTQ5MWZjMzE5Zjc5NWU0NTlkZWJlIiwidGFnIjoiIn0%3D; expires=Mon, 21 Apr 2025 23:07:34 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IjVKTjFtSm5yajNkcGg5WU45VEtmTlE9PSIsInZhbHVlIjoiWjRoQkE5cXJkeDJrZzNkM3lYT2h5TXNGZDVxek1CeDNtb3ordlJIVXhEV0QrYkFTS1JwVFJNLzJ5T2J1THpnaTYw ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkxqVHdjNDZDRFNsVmduVGlDV1RsWlE9PSIsInZhbHVlIjoiVU9RTEluOWlJaTZxd1RMQzdaNGhzR0YwQW92TW40SUdLYWk1UXQ3S3l3bytpVmo3NDFMaythVHdMcEVja0h5ZXdOM1lieEtpYnNIVkNQVTgxRE5pQys0ak13RkhFZHpRMHh5RUdRSVBGY3JCUXdJM1Y5bnVvQ1l0MExmV3ZTUWIiLCJtYWMiOiJiZTBjNmJkNTI4YTA5YzY5MmMyNmE3NzNmMGMxYzg2ODg0ZDg2OWFiNjhjM2ZhZTkzNWI3MWMzZDU3ZGNmNGUxIiwidGFnIjoiIn0%3D; expires=Mon, 21-Apr-2025 23:07:34 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IkxqVHdjNDZDRFNsVmduVGlDV1RsWlE9PSIsInZhbHVlIjoiVU9RTEluOWlJaTZxd1RMQzdaNGhzR0YwQW92TW40SUdLYWk1UXQ3S3l3bytpVmo3NDFMaythVHdMcEVja0h5ZXdOM1lie ▶"
    1 => "laravel_session=eyJpdiI6IjVKTjFtSm5yajNkcGg5WU45VEtmTlE9PSIsInZhbHVlIjoiWjRoQkE5cXJkeDJrZzNkM3lYT2h5TXNGZDVxek1CeDNtb3ordlJIVXhEV0QrYkFTS1JwVFJNLzJ5T2J1THpnaTYwNUNEb0lPSW1PVHpvdFo1TFN5ZjJhdTRENnZHL0VEODQ1M2I0d1Bqb3hMNTRESytuc2pYRmVNems5YXhhYTgiLCJtYWMiOiI5Y2UyNzZkNGJjNDE4ZTcxMmNlMzQ3OGE0YjRiMmU2Yzk2ZDIxODVmOGRiYTQ5MWZjMzE5Zjc5NWU0NTlkZWJlIiwidGFnIjoiIn0%3D; expires=Mon, 21-Apr-2025 23:07:34 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IjVKTjFtSm5yajNkcGg5WU45VEtmTlE9PSIsInZhbHVlIjoiWjRoQkE5cXJkeDJrZzNkM3lYT2h5TXNGZDVxek1CeDNtb3ordlJIVXhEV0QrYkFTS1JwVFJNLzJ5T2J1THpnaTYw ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "hlPSxuPRmQ99KyCySzwyove99WX7qtiM2NWK8q1d"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/data-and-reporting-analyst-1"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-21 21:07:34GET/data-and-reporting-analyst-1311140