Job Description :
Title: Scientific Analyst
Location: Princeton, NJ 08543
Duration: 6 months
Comments:
Strong proficiency in Data Visualization tools (Spotfire, Tableau, PowerBi etc and specifically able to create, manage and evolve a PowerBi dataset
Deep experience in MS Excel including the ability to create Macros & use VBA, formulas and data merging/comparison techniques knowledge of the data model, expert knowledge of pivot tables and pivot charts and general understanding of coding practices
Strong proficiency in PowerQuery and related dataset transformations
Experience with leveraging Excel files, SharePoint lists, and other data sources to populate & keep updated a PowerBi dataset
Experience leveraging SharePoint lists & libraries for the purpose of collecting & aggregating data (including InfoPath & Forms) in addition to the ability to customize the site’s web parts and pages
Job Description:
This role serves as a reporting analyst / data scientist to develop, merge, compare, update and report through data visualization on overlapping or disparate data sets. The analyst will need to have strong data analytic abilities, be able to solicit requirements from end users and understand how to keep data and priorities organized in order to provide clear insights for the current business need.
Required Skills & Experience:
Strong proficiency in MS Excel, Word, PowerPoint, Outlook
Deep experience in MS Excel including the ability to create Macros & use VBA, formulas and data merging/comparison techniques knowledge of the data model, expert knowledge of pivot tables and pivot charts and general understanding of coding practices
Strong proficiency in PowerQuery and related dataset transformations
Experience with leveraging Excel files, SharePoint lists, and other data sources to populate & keep updated a PowerBi dataset
Experience leveraging SharePoint lists & libraries for the purpose of collecting & aggregating data (including InfoPath & Forms) in addition to the ability to customize the site’s web parts and pages
Strong proficiency in Data Visualization tools (Spotfire, Tableau, PowerBi etc and specifically able to create, manage and evolve a PowerBi dataset
SQL or related database experience required (e.g., ability to query tables, SQL reporting services, etc
Workflow experience required (SharePoint designer, Microsoft Flow and related tools)
Facilitation and meeting management skills; Strong communicator via all media: collaboration technologies (SharePoint, Skype, Microsoft Teams etc and presentations written, emails, verbal – with a wide variety of audiences
Manages multiple sometimes conflicting priorities, challenges the status quo, and exercises diplomacy all while maintaining a high comfort level for ambiguity
Experience managing, configuring or heavily using enterprise commercial Project & Portfolio management & collaboration tools a plus
At least 5 years of prior experience working in a Business or Data Analyst capacity; ideally in the Pharmaceutical Industry
Proven ability in gathering, tracing, translating and managing complex requirements, business rules, and data
Excellent oral and written communication skills including technical writing / documentation; organizes and presents ideas in a convincing and compelling manner
Demonstrated ability to use structured problem solving and available tools to quickly evaluate problems, identify root causes, create action plans, assess impact and develop resolution options
Action oriented and demonstrates accountability for results and acts with integrity and develops credibility
Demonstrates strong analytical skills, process knowledge and lateral thinking. Metric/KPI capture, analysis, and reporting
Exceptional interpersonal skills; able to communicate effectively with both technical and non-technical teams; able to provide technical leadership
Demonstrate ability to be teachable, a quick-learner, adapt in a fast-paced environment and work independently when needed
Excellent teamwork and interpersonal skills, with the ability to communicate and collaborate with employees and management at all levels.
Applications:
ServiceNow
Excel & PowerQuery
Spotfire
Tableau
PowerBi
SharePoint & SharePoint Designer
Microsoft Flow