SAS / SQL DATA ANALYST

Eddie Bauer

Contract Bellevue, Washington, United States Posted 5 years ago

 Write a Review Add Vendor   Add Contact  

About Position

SAS / SQL DATA ANALYST (Contract)

$55.00 / Hourly

Bellevue, Washington, United States

SAS / SQL DATA ANALYST

Contract Bellevue, Washington, United States Posted 5 years ago

Description

Data Analyst of Transactional Data using SAS and SQL commands This is a very handson programming position to analyze and report data as meaningful information by delivering the following technical skills Campaign Analysis Warehouse SQL 2005 and 2018Heavy use of SQL to search and extract dataHeavy use of SAS to analyze and represent date in formats useful to the business usersKnowledge of the UNIX environmentExcel automation reportingMS Sales Financial Business Intelligence Reporting Analysis dimensional and relationalKnowledge of SSRS a plusAnalysis of Actuals, Budget and Forecast by creating normalized relational data structuresPower Pivot expert using DAX and data normalizationSQL Reporting Services data metric reporting utilizing SQL and some MDXDeveloped analysis toolCreate complex and aggregate SQL queries into ExcelVBA code automated dynamic Excel reporting sheetsHighly skilled at Ad Hoc request and reporting efficient at understanding the underlying dataSQL server queries publishing in various consumable end user apps like MS ExcelWorked with multiple stake holders to gather requirements and metrics & ROIManagement of data issues between multiple data sources and platformsData cleansing and extraction, report design and implementation of Marketing NumbersDetailed customer response reporting from hand raisers to full purchases, tracking

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

Eddie Bauer Vendors

Wipro Technologies
Write a Review

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

Ajilon Consulting
Write a Review

210 West Pennsylvania Avenue
Towson
Maryland
www.ajilonconsulting.com ( 47 vendors)

Job Summary

$55.00 / Hourly

Contract

Bellevue, Washington, United States

Experience Required : 8 Year/s

Posted : 5 years ago

Deadline : May 21, 2019 5 years ago

Job ID : Job0000016021

Eddie Bauer

15010 NE 36th St

www.eddiebauer.com

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.31PHP Version2.38sRequest Duration690MBMemory UsageGET {slug}Route
    • Booting (2.09s)time
    • Application (282ms)time
    • 1 x Booting (88.14%)
      2.09s
      1 x Application (11.86%)
      282ms
      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 executed198ms
      • JobController.php#484clientfyi_final15.57msselect * from `jobs` where `job_slug` = 'Job0000016021' limit 1
        Bindings
        • 0: Job0000016021
        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.22msselect `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` = 16799 limit 1
        Bindings
        • 0: 16799
        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_final460μ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` = 16799
        Bindings
        • 0: 1
        • 1: 16799
        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.04msselect `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` = 16799 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 16799
        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_final440μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 16799
        Bindings
        • 0: 1
        • 1: 16799
        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_final9.12msselect DISTINCT email from `job_applications` where `category_id` = 95 and `status` = 1
        Bindings
        • 0: 95
        • 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_final480μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 16021 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 16021
        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_final890μ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_final46.7msSELECT 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_final39.54msSELECT 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
          ecN6IUp9v5r91DlIvmxdgJUTxDN0YJQ6tRSIF5X6
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000016021" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000016021
          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.137.173.170"
  ]
  "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 => "91cd47559ff58b98-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.137.173.170"
  ]
  "x-real-ip" => array:1 [▶
    0 => "172.69.17.155"
  ]
  "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, 07 Mar 2025 21:45:16 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImMyY2xQSXU5NWQ4Nnk3c3QyRE1hRHc9PSIsInZhbHVlIjoiVEUzZlFqWU0yNGNIbkNxTUZCQXJ5WGJzUlczQ09rNmZVdS9OaGs5clJEa0I3b2lrNG0zVnFIUngyVkhUajV2cFVGaHFIR0FOZ28vckV2NFVxVzZ4b0IwT05BZ0QxNkkrR1E3N1dhMEZnN0Z2ZzBsRWJGOVRvbVF6N1FEeHpKakEiLCJtYWMiOiJiOWJmNmE0MDM1ZGRmNTE1OWI0NWVlNjZlOTRlMmUxOTVkNTY3OWFmYTVmZjY2OTQ5NWYwMDhiYmJjZmU1ZTAxIiwidGFnIjoiIn0%3D; expires=Fri, 07 Mar 2025 23:45:16 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImMyY2xQSXU5NWQ4Nnk3c3QyRE1hRHc9PSIsInZhbHVlIjoiVEUzZlFqWU0yNGNIbkNxTUZCQXJ5WGJzUlczQ09rNmZVdS9OaGs5clJEa0I3b2lrNG0zVnFIUngyVkhUajV2cFVGaHFIR ▶"
    1 => "laravel_session=eyJpdiI6Ijhta251d3Q4VEdSNlRhVmRpSGZxNmc9PSIsInZhbHVlIjoiUEVLeStPMENYU1RFc0pyQzZ5bkdRK2thWnk0T0pzUUhWL1F6VFAxakd0Wnd3TmdBaE1zWHhTN21lZHBPSGNOUG1oRXFZdlgyUGk5MzgrejNTRS9wU1hCZ2EzQW16MXFudXNVdWk5a3ZUa1F6bG1QZ3ROQ2lWUSs1L2grZHNwYmUiLCJtYWMiOiIyYWMwMWUwM2ZlNGI4OTFmYWQzMzE5ZGJjYmUwYzcyMzEzYTYxMzZlZDYyMDU1Y2FmNjc3ODNkYTgzY2M5NjVhIiwidGFnIjoiIn0%3D; expires=Fri, 07 Mar 2025 23:45:16 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6Ijhta251d3Q4VEdSNlRhVmRpSGZxNmc9PSIsInZhbHVlIjoiUEVLeStPMENYU1RFc0pyQzZ5bkdRK2thWnk0T0pzUUhWL1F6VFAxakd0Wnd3TmdBaE1zWHhTN21lZHBPSGNOUG1o ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImMyY2xQSXU5NWQ4Nnk3c3QyRE1hRHc9PSIsInZhbHVlIjoiVEUzZlFqWU0yNGNIbkNxTUZCQXJ5WGJzUlczQ09rNmZVdS9OaGs5clJEa0I3b2lrNG0zVnFIUngyVkhUajV2cFVGaHFIR0FOZ28vckV2NFVxVzZ4b0IwT05BZ0QxNkkrR1E3N1dhMEZnN0Z2ZzBsRWJGOVRvbVF6N1FEeHpKakEiLCJtYWMiOiJiOWJmNmE0MDM1ZGRmNTE1OWI0NWVlNjZlOTRlMmUxOTVkNTY3OWFmYTVmZjY2OTQ5NWYwMDhiYmJjZmU1ZTAxIiwidGFnIjoiIn0%3D; expires=Fri, 07-Mar-2025 23:45:16 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImMyY2xQSXU5NWQ4Nnk3c3QyRE1hRHc9PSIsInZhbHVlIjoiVEUzZlFqWU0yNGNIbkNxTUZCQXJ5WGJzUlczQ09rNmZVdS9OaGs5clJEa0I3b2lrNG0zVnFIUngyVkhUajV2cFVGaHFIR ▶"
    1 => "laravel_session=eyJpdiI6Ijhta251d3Q4VEdSNlRhVmRpSGZxNmc9PSIsInZhbHVlIjoiUEVLeStPMENYU1RFc0pyQzZ5bkdRK2thWnk0T0pzUUhWL1F6VFAxakd0Wnd3TmdBaE1zWHhTN21lZHBPSGNOUG1oRXFZdlgyUGk5MzgrejNTRS9wU1hCZ2EzQW16MXFudXNVdWk5a3ZUa1F6bG1QZ3ROQ2lWUSs1L2grZHNwYmUiLCJtYWMiOiIyYWMwMWUwM2ZlNGI4OTFmYWQzMzE5ZGJjYmUwYzcyMzEzYTYxMzZlZDYyMDU1Y2FmNjc3ODNkYTgzY2M5NjVhIiwidGFnIjoiIn0%3D; expires=Fri, 07-Mar-2025 23:45:16 GMT; path=/; httponly ◀laravel_session=eyJpdiI6Ijhta251d3Q4VEdSNlRhVmRpSGZxNmc9PSIsInZhbHVlIjoiUEVLeStPMENYU1RFc0pyQzZ5bkdRK2thWnk0T0pzUUhWL1F6VFAxakd0Wnd3TmdBaE1zWHhTN21lZHBPSGNOUG1o ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "ecN6IUp9v5r91DlIvmxdgJUTxDN0YJQ6tRSIF5X6"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/Job0000016021"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-03-07 21:45:16GET/Job0000016021311140