Senior Analyst, Business Intelligence - Columbus, OH

Key Skills

Alteryx, Analytical and Problem solving, Automation, Business Intelligence, Effective communication skills, Leadership, Machine learning techniques, Microsoft-Excel, PowerBI, Powerpoint, Project management, Python Programming, R Programming, SAS, SQL, Statistical modeling, Tableau

Job Description

About Abbott

Abbott is a global healthcare leader, creating breakthrough science to improve people’s health. We’re always looking towards the future, anticipating changes in medical science and technology.

Working at Abbott

At Abbott, you can do work that matters, grow, and learn, care for yourself and family, be your true self and live a full life. You’ll also have access to:

• Career development with an international company where you can grow the career you dream of .
• Free medical coverage for employees* via the Health Investment Plan (HIP) PPO
• An excellent retirement savings plan with high employer contribution
• Tuition reimbursement, thestudent debt program andeducation benefit - an affordable and convenient path to getting a bachelor’s degree.
• A company recognized as a great place to work in dozens of countries around the world and named one of the most admired companies in the world by Fortune.
• A company that is recognized as one of the best big companies to work for as well as a best place to work for diversity, working mothers, female executives, and scientists.

The Opportunity

This is a highly technical and hands-on role within the CRM Analytics and Reporting team. You will be a true master of complex CRM database and cutting-edge data scientist toolbox. You will be working with extensive internal and external partners in a highly matrixed organization and navigating through challenging processes. The core expectation is to meet various reporting, list management and advanced analytics needs for various Abbott Nutrition Brands. Key functions are: (A) to build, automate and update CRM dashboards for B2C marketing performances; (B) to track marketing campaign KPIs, extract and communicate insights of postmortem results to strategic stakeholders; (C) to manage the CRM audience/list using Data Science programming tools to support acquisition, growth and retention tactics.

What You’ll Work On

• Responsible for large scale data cleaning and synthesizing from various databases or sources. 

• Responsible for writing SQL/Python scripts for analytics and reporting tasks by transforming customer behavior/demographic data into actionable insights or campaign lists.

• Create, disseminate, maintain, and enhance standard marketing and operational reports and analyses.
• Ad-hoc analyses, deep dives and potential machine learning models pending on business needs.
• Collaborate in a cross-functional team as CRM data SME with both technical and non-technical teammates. 
• Synthesize findings, craft deliverable document and present recommendations to stakeholders including senior leaders.
• Develop, implement and document the requirements to enhance existing database reporting capabilities while working with external vendors to acquire, manage and utilize customer data.

Required Qualifications

• Must be able to self-learn, self-motivated, and have excellent analytical thinking, problem-solving skills.
• 2+ years of data visualization experience in an industry setting.
• 2+ years of hands-on industry experience with SQL and Python are a must.
• Basic statistical modeling or machine learning experience required (knowledge of design of experiment is a plus).
• Relevant business experience required in B2C marketing organization with demonstrated understanding of marketing database and marketing strategies.
• Strong verbal and written communications skills including the ability to translate complex data and findings into actionable insights and present to various audiences including senior leadership.
• Technical Skills: 
• Must have at least intermediate level coding skills in both SQL and Python (Alteryx experience is plus, R/SAS is optional).
• Must have at least one data visualization skill Tableau/Power BI.
• Proficiency with MS PowerPoint and Excel.
• Process automation or cloud computing experience is a plus.
• Superb project management skills. Be comfortable with ambiguous business environment, unstructured/undefined process and multitasking situations.

• Bachelor’s degree required in Data Science, Mathematics, Statistics, Business Analytics, Computer Science or related field.
• Master’s degree quantitative analysis discipline preferred.

The base pay for this position is $71,300.00 – $142,700.00. In specific locations, the pay range may vary from the range posted.