MDM (Data IKU & Alteryx )

Novartis Pharmaceuticals Corporation

Contract East Hanover, New Jersey, United States Posted 1 year ago

 Write a Review Add Vendor   Add Contact  

About Position

MDM (Data IKU & Alteryx ) (Contract)

$90.00 / Hourly

East Hanover, New Jersey, United States

MDM (Data IKU & Alteryx )

Contract East Hanover, New Jersey, United States Posted 1 year ago

Skills
Liaison with client on daily to understand the regular and ad-hoc reporting and analytics needs. Collaborate with offshore team to get the deliverables created. Communicate with internal and external stakeholders on a regular basis. Identify areas of business growth within the account. Understand data needs Strong problem solving and troubleshooting skills customer requirements and potential business implications. Garner a thorough understanding of customer requirements and potential business implications and Ability to provide business insights. Manage the end-to-end process set-up by applying best practices. Construct workflow Proven experience in prioritizing and delegating work to meet deadlines objectives and quality metrics. Drive decision making process amongst key stakeholders. Develop customized analytical reports to cater to the client requests. Ability to collaborate customer to understand business requirements and translate that in actionable plan. Effectively communicate project details to clients and internal delivery team via written documents and presentations Build Analytics ready data sets with common view of the patient across Hub Specialty Adherence & Copay programs!
Description

Data management Experience in Commercial Pharma (Specialty Pharmacy Data Experience preferred)
Experience in executing analytics projects in patient analytics, commercial analytics or marketing (Hands on)
Data & Scenario Modeling experience
Working with secondary data sources such IQVIA LAAD data, SHS claims data doing Patient Level analytics.

Responsibilities
  • Data management Experience in Commercial Pharma (Specialty Pharmacy Data Experience preferred)
  • Experience in executing analytics projects in patient analytics, commercial analytics or marketing (Hands on)
  • Data & Scenario Modeling experience
  • Working with secondary data sources such IQVIA LAAD data, SHS claims data doing Patient Level analytics.
  • Data IKU & Alteryx Experience
  • Expert Knowledge SQL
  • Proficient in Microsoft Office (Intermediate -Advance Level)
  • Should Have
  • Pharma Commercial / Analytics Experience
  • Good Project Management Skills, Strong Communication, and stakeholder management skills
  • Analytical thinker - Technically Sound (Good problem-solving abilities)
  • Good working Knowledge SQL (Snowflake)
  • Knowledge of existing PSS Business Rules
  • Ability to build analytics ready data sets that can be used by business users

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

Novartis Pharmaceuticals Corporation Vendors

( Login to see all the 22 vendors)
Ciber Global, LLC
Write a Review

3270 West Big Beaver Road
Troy
Michigan
www.ciber.com ( 34 vendors)

Sogeti USA Corporation
Write a Review

7735 Paragon Road
Dayton
Ohio
www.sogeti.com ( 24 vendors)

Larsen & Toubro Infotech Limited
Write a Review

400 Kelby Street
Fort Lee
New Jersey
www.lntinfotech.com ( 11 vendors)

Job Summary

$90.00 / Hourly

Contract

East Hanover, New Jersey, United States

Experience Level : Medium

Experience Required : 5 Year/s

Only Any

Posted : 1 year ago

Deadline : November 10, 2023 1 year ago

Job ID : Job0000008426

Novartis Pharmaceuticals Corporation

608 Fifth Avenue

212-307-1122

www.novartis.com

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.31PHP Version2.56sRequest Duration692MBMemory UsageGET {slug}Route
    • Booting (2.29s)time
    • Application (273ms)time
    • 1 x Booting (89.34%)
      2.29s
      1 x Application (10.66%)
      273ms
      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 executed205ms
      • JobController.php#484clientfyi_final8.11msselect * from `jobs` where `job_slug` = 'mdm-data-iku-alteryx' limit 1
        Bindings
        • 0: mdm-data-iku-alteryx
        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_final90.12msselect `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` = 4007 limit 1
        Bindings
        • 0: 4007
        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_final660μ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` = 4007
        Bindings
        • 0: 1
        • 1: 4007
        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.22msselect `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` = 4007 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 4007
        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_final280μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 4007
        Bindings
        • 0: 1
        • 1: 4007
        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.11msselect DISTINCT email from `job_applications` where `category_id` = 40 and `status` = 1
        Bindings
        • 0: 40
        • 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_final360μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 8426 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 8426
        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_final48.07msSELECT 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.35msSELECT 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
          gxq1apbxX2Wjz80Y0ApJUdPglaZKk4UcYvoNlYx7
          _previous
          array:1 [ "url" => "https://pingjob.com/mdm-data-iku-alteryx" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /mdm-data-iku-alteryx
          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 => "13.58.129.138"
  ]
  "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 => "920749b4486561b5-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "13.58.129.138"
  ]
  "x-real-ip" => array:1 [▶
    0 => "172.69.6.175"
  ]
  "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, 14 Mar 2025 22:43:07 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ik1rdXlTSkh4OVpScUNxTkxOMEVUMlE9PSIsInZhbHVlIjoicUdoci9IY3kyaHVtZnZ4TjRqSDFWaE9JS2JmTThQczhZRUxyUmtRNnkrSFdON3Y0cUJ6aFdFb0FvK0djbjNmZlJ2R1Z1T3RELzVlc3FmdnJKZXBFWWpGZlkrZmJWWlgyYzFVQlNiRkFuSW1GTldRMzVxTk5PZFRzSlpJMVFlbG8iLCJtYWMiOiI4ZTVjNDU4NzQ4NzUzMWM0YTU5NDY5Yjg1NTQ4OTczOGFiODZkNmRiNDlhMzM2YzE0MTEzMTdkNTBjNDE1NDZiIiwidGFnIjoiIn0%3D; expires=Sat, 15 Mar 2025 00:43:07 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ik1rdXlTSkh4OVpScUNxTkxOMEVUMlE9PSIsInZhbHVlIjoicUdoci9IY3kyaHVtZnZ4TjRqSDFWaE9JS2JmTThQczhZRUxyUmtRNnkrSFdON3Y0cUJ6aFdFb0FvK0djbjNmZlJ2R1Z1T ▶"
    1 => "laravel_session=eyJpdiI6InBqaFVFQ1NtcFl5d0k3UEEvSDhGZ0E9PSIsInZhbHVlIjoid0w4R2FsYlAyK1VsT0M5S0ZKdUlRN2pQQnJNeGZ5VVQ3UlNVcjRCbmNVRnpnVzV0azJRZS9SNmtXRWoyVDI5U1YreDhkcmxKZ0hFT3JuS1ptZjd2YkQ3dmxtTU9rRU4wMkVMU2trWGdPK1pEU0NFcTcxMm5LN004NkJXWWhCZXUiLCJtYWMiOiJiZDQ3M2IwYmI4NThlYWEzZjYyOWMzNGNiNWMzZGZhMTUxMDk1MTBmN2UwZGI2ZTUwNDQzMjc2NDg2YzUyZjhjIiwidGFnIjoiIn0%3D; expires=Sat, 15 Mar 2025 00:43:07 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6InBqaFVFQ1NtcFl5d0k3UEEvSDhGZ0E9PSIsInZhbHVlIjoid0w4R2FsYlAyK1VsT0M5S0ZKdUlRN2pQQnJNeGZ5VVQ3UlNVcjRCbmNVRnpnVzV0azJRZS9SNmtXRWoyVDI5U1Yr ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ik1rdXlTSkh4OVpScUNxTkxOMEVUMlE9PSIsInZhbHVlIjoicUdoci9IY3kyaHVtZnZ4TjRqSDFWaE9JS2JmTThQczhZRUxyUmtRNnkrSFdON3Y0cUJ6aFdFb0FvK0djbjNmZlJ2R1Z1T3RELzVlc3FmdnJKZXBFWWpGZlkrZmJWWlgyYzFVQlNiRkFuSW1GTldRMzVxTk5PZFRzSlpJMVFlbG8iLCJtYWMiOiI4ZTVjNDU4NzQ4NzUzMWM0YTU5NDY5Yjg1NTQ4OTczOGFiODZkNmRiNDlhMzM2YzE0MTEzMTdkNTBjNDE1NDZiIiwidGFnIjoiIn0%3D; expires=Sat, 15-Mar-2025 00:43:07 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6Ik1rdXlTSkh4OVpScUNxTkxOMEVUMlE9PSIsInZhbHVlIjoicUdoci9IY3kyaHVtZnZ4TjRqSDFWaE9JS2JmTThQczhZRUxyUmtRNnkrSFdON3Y0cUJ6aFdFb0FvK0djbjNmZlJ2R1Z1T ▶"
    1 => "laravel_session=eyJpdiI6InBqaFVFQ1NtcFl5d0k3UEEvSDhGZ0E9PSIsInZhbHVlIjoid0w4R2FsYlAyK1VsT0M5S0ZKdUlRN2pQQnJNeGZ5VVQ3UlNVcjRCbmNVRnpnVzV0azJRZS9SNmtXRWoyVDI5U1YreDhkcmxKZ0hFT3JuS1ptZjd2YkQ3dmxtTU9rRU4wMkVMU2trWGdPK1pEU0NFcTcxMm5LN004NkJXWWhCZXUiLCJtYWMiOiJiZDQ3M2IwYmI4NThlYWEzZjYyOWMzNGNiNWMzZGZhMTUxMDk1MTBmN2UwZGI2ZTUwNDQzMjc2NDg2YzUyZjhjIiwidGFnIjoiIn0%3D; expires=Sat, 15-Mar-2025 00:43:07 GMT; path=/; httponly ◀laravel_session=eyJpdiI6InBqaFVFQ1NtcFl5d0k3UEEvSDhGZ0E9PSIsInZhbHVlIjoid0w4R2FsYlAyK1VsT0M5S0ZKdUlRN2pQQnJNeGZ5VVQ3UlNVcjRCbmNVRnpnVzV0azJRZS9SNmtXRWoyVDI5U1Yr ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "gxq1apbxX2Wjz80Y0ApJUdPglaZKk4UcYvoNlYx7"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/mdm-data-iku-alteryx"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-03-14 22:43:07GET/mdm-data-iku-alteryx311140