Data Analyst

Post Holdings

Full Time Lakeville , Minnesota, United States Posted 1 year ago

 Write a Review Add Vendor   Add Contact  

About Position

Data Analyst (Full Time)

$0.00 / Hourly

Lakeville , Minnesota, United States

Data Analyst

Full Time Lakeville , Minnesota, United States Posted 1 year ago

Skills
Collaborate with our client's business and IT teams to map and troubleshoot integrations ensuring smooth data flow throughout their organization. Produce data collection and load specifications executing data loading processes with meticulous attention to accuracy and data integrity. Demonstrate proficiency in mapping data from source systems to destination systems including expert data cleansing techniques to maintain the highest data quality. Support and facilitate the smooth transition of data into multiple target systems enabling our client to utilize data effectively. Conduct data cleansing harmonization and enrichment activities to enhance data quality and usability ensuring our client's data is of the utmost quality. Plan periodic and ongoing data refreshes for transactional and non-transactional data keeping our client's insights up-to-date and relevant. Contribute to planning and execution for multiple testing cycles leading to the final conversion into production environments for our valued client. Assist in the analysis and design of data-related integrations providing valuable insights to optimize our client's data strategy.
Description

Our client is seeking an experienced Data Analytics Specialist to join their team and play a pivotal role in contributing to their success. As a Data Analytics Specialist, you will collaborate closely with our clients and their various teams to understand and identify their data-related requirements, ensuring seamless incorporation into their work plan. Your expertise will be vital in providing valuable insights and contributing to the overall project plan. You will work hand-in-hand with project managers and the Information Management Office (IMO) to provide routine updates on progress, issues, and risk

Responsibilities
  • 5+ years of experience in data analytics, data engineering, or a similar role.
  • 2+ years of experience working with data architecture principles and practices.
  • Proficiency in data analysis tools/programming languages such as Python, R, SQL, and similar, with data visualization experience.
  • Familiarity with tools and concepts related to data and analytics, such as dimensional modeling, ETL, data warehousing, and structured, unstructured, and transactional data.
  • Strong expertise in data validation and cleansing techniques, ensuring our client's data is accurate and reliable.
  • Demonstrated ability to collaborate effectively with our esteemed clients at all levels throughout their organization.
  • Logical problem-solving skills with the ability to present recommendations clearly in verbal, written, and graphical form.
  • Preferred Experience (not mandatory):
  • Experience in implementing Master Data Management (MDM) solutions.
  • Must HAVE Familiarity with Boomi and JDE.
  • Hands-on experience with agile and waterfall methodologies.

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

Post Holdings Vendors

Genesis10
Write a Review

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

Job Summary

Full Time

Lakeville , Minnesota, United States

Experience Level : Medium

Only Any

Posted : 1 year ago

Deadline : August 31, 2023 1 year ago

Job ID :

Post Holdings

2503 S. Hanley Road

314.644.7600

www.postholdings.com

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.31PHP Version3.16sRequest Duration689MBMemory UsageGET {slug}Route
    • Booting (2.72s)time
    • Application (446ms)time
    • 1 x Booting (85.89%)
      2.72s
      1 x Application (14.11%)
      446ms
      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 executed204ms
      • JobController.php#484clientfyi_final25.96msselect * from `jobs` where `job_slug` = 'data-analyst-11' limit 1
        Bindings
        • 0: data-analyst-11
        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_final80.09msselect `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` = 81223 limit 1
        Bindings
        • 0: 81223
        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_final490μ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` = 81223
        Bindings
        • 0: 1
        • 1: 81223
        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_final690μ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` = 81223 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 81223
        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_final330μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 81223
        Bindings
        • 0: 1
        • 1: 81223
        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.17msselect 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_final380μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 82195 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 82195
        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_final830μ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_final44.51msSELECT 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.59msSELECT 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
          0ZrARyt5QJ8SiL2LHWz37aG8Q9lSPaD9m4yvYzEY
          _previous
          array:1 [ "url" => "https://pingjob.com/data-analyst-11" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /data-analyst-11
          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 => "91bcf1f02f88d61d-CDG"
  ]
  "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.71.130.138"
  ]
  "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, 05 Mar 2025 22:10:46 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkJocXB1dld1bEc1d05HLzJvWWNDM0E9PSIsInZhbHVlIjoiTU52RDFTbGVuWWFicm5TN2lpc3c4YWlIN3dHbnA4ZWVMUTZ3QXdzWk4zYm1NempuS3RJc1BXeDdSTWVPL2g5LzZHMmFIWkQ1S05QR2QyOFB5VUVQN0ZrRno1aytKVkZjakd6cXhXdk5YN2xsR2tTaHg1RzN3aUxiWm0xTlVxcFAiLCJtYWMiOiI1ZmQxN2E4MTVmOGYwZDA1YmU3ZGY3YzkwOWM0OWY2ZGUyYjYzMmM1ZGZiODMxNmYzMDNmMWJiMzUxMTAwNDM5IiwidGFnIjoiIn0%3D; expires=Thu, 06 Mar 2025 00:10:47 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkJocXB1dld1bEc1d05HLzJvWWNDM0E9PSIsInZhbHVlIjoiTU52RDFTbGVuWWFicm5TN2lpc3c4YWlIN3dHbnA4ZWVMUTZ3QXdzWk4zYm1NempuS3RJc1BXeDdSTWVPL2g5LzZHMmFIW ▶"
    1 => "laravel_session=eyJpdiI6Ik5lc3pTQW10SmwyUWpqNllzck56OEE9PSIsInZhbHVlIjoiTFFmRmdsMDVvelFRb2xRaGNkdnEzTE9PUWtkblJ2M1gxTk82ZTVEUkpSbUpzcnlLWVRxV0lKanpUY0k5VTdoc2N5VVVmWlA0WXNXQkMvcndIa1BhYnpZcXlnem44bHFRTjdUSUNmbExIK2xvMFQ0LzZrL1B2bC9vVTk1eUl3N1AiLCJtYWMiOiJmMGVhYzg1MTc5ZTQ5NjQzZjExNzRiZmM0ZDRhZmQxNDU2MjJhZjJiZTE4YTNkNmI2MTNlMDRkNjQ0ZTkwOWYxIiwidGFnIjoiIn0%3D; expires=Thu, 06 Mar 2025 00:10:47 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6Ik5lc3pTQW10SmwyUWpqNllzck56OEE9PSIsInZhbHVlIjoiTFFmRmdsMDVvelFRb2xRaGNkdnEzTE9PUWtkblJ2M1gxTk82ZTVEUkpSbUpzcnlLWVRxV0lKanpUY0k5VTdoc2N5 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkJocXB1dld1bEc1d05HLzJvWWNDM0E9PSIsInZhbHVlIjoiTU52RDFTbGVuWWFicm5TN2lpc3c4YWlIN3dHbnA4ZWVMUTZ3QXdzWk4zYm1NempuS3RJc1BXeDdSTWVPL2g5LzZHMmFIWkQ1S05QR2QyOFB5VUVQN0ZrRno1aytKVkZjakd6cXhXdk5YN2xsR2tTaHg1RzN3aUxiWm0xTlVxcFAiLCJtYWMiOiI1ZmQxN2E4MTVmOGYwZDA1YmU3ZGY3YzkwOWM0OWY2ZGUyYjYzMmM1ZGZiODMxNmYzMDNmMWJiMzUxMTAwNDM5IiwidGFnIjoiIn0%3D; expires=Thu, 06-Mar-2025 00:10:47 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IkJocXB1dld1bEc1d05HLzJvWWNDM0E9PSIsInZhbHVlIjoiTU52RDFTbGVuWWFicm5TN2lpc3c4YWlIN3dHbnA4ZWVMUTZ3QXdzWk4zYm1NempuS3RJc1BXeDdSTWVPL2g5LzZHMmFIW ▶"
    1 => "laravel_session=eyJpdiI6Ik5lc3pTQW10SmwyUWpqNllzck56OEE9PSIsInZhbHVlIjoiTFFmRmdsMDVvelFRb2xRaGNkdnEzTE9PUWtkblJ2M1gxTk82ZTVEUkpSbUpzcnlLWVRxV0lKanpUY0k5VTdoc2N5VVVmWlA0WXNXQkMvcndIa1BhYnpZcXlnem44bHFRTjdUSUNmbExIK2xvMFQ0LzZrL1B2bC9vVTk1eUl3N1AiLCJtYWMiOiJmMGVhYzg1MTc5ZTQ5NjQzZjExNzRiZmM0ZDRhZmQxNDU2MjJhZjJiZTE4YTNkNmI2MTNlMDRkNjQ0ZTkwOWYxIiwidGFnIjoiIn0%3D; expires=Thu, 06-Mar-2025 00:10:47 GMT; path=/; httponly ◀laravel_session=eyJpdiI6Ik5lc3pTQW10SmwyUWpqNllzck56OEE9PSIsInZhbHVlIjoiTFFmRmdsMDVvelFRb2xRaGNkdnEzTE9PUWtkblJ2M1gxTk82ZTVEUkpSbUpzcnlLWVRxV0lKanpUY0k5VTdoc2N5 ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "0ZrARyt5QJ8SiL2LHWz37aG8Q9lSPaD9m4yvYzEY"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/data-analyst-11"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-03-05 22:10:47GET/data-analyst-11311140