Abbott - Analyst - Market Insights

Job Responsibilities - 

1. Build and maintain different data masters from various sources

2. Construct analytical models to forecast sales

3. Building periodic dashboards and reports: primarily on Excel

4. Interact with external market research agencies to understand their data sets and harmonize it with internal data sets for better business comprehension.

5. Analyze Data to Draw Both Qualitative and Quantitative Conclusions and convert findings into reports

Experience & Qualifications - 

- Bachelor or Master in Statistics/ Mathematics/ Econometrics/Economics.

- MBAs will be given preference only in addition to the above.

- 3-4 years in Analytics and MIS profile

- Should have worked in a CPG or Market Research or Analytics firm

Key Skills required:

- Advance excel and should be well versed with proficient in using the functions like VlookUp, Match, Index and statistical functions

- Should be comfortable in conditional formatting in excel along with good command over Pivot tables and charts (including options like slicer).

- Ability to write macros on VB and Access

- Advanced Power point skills (including add-ons like Think-cell)

- Should have worked on various time-series forecasting techniques, regression and price-sensitivity analysis.

- Experience in working with Power BI / Tableau preferred

- Experience in working with languages like SQL, Python and R preferred