Strategy Analytics Lead: Data Dashboards & Insights

Red Oak Sourcing; Foxborough (MA); Hybrid; USD 78,000 - 109,000; Full time

Benefits offered by this job

Hybrid schedule

Office collaboration days

Job summary

Red Oak Sourcing is seeking a data analyst for the Strategy & Analytics team to design Tableau/Salesforce dashboards, manage SQL databases, automate processes in Python, build data pipelines, and perform at hoc analytics to inform daily generic pharmaceutical sourcing strategy as well as longer-term decisions made by the Executive Leadership Team.

Success in this role requires strong analytics skills, experience with key data tools, and the ability to work collaboratively across business

Qualifications

• Expertise in key analytics and data visualization tools such as Excel, SQL, Tableau and Salesforce
• Proficiency in Python and basic understanding of statistical methods (sampling, regression, distributions, etc.)
• 2-3 years of experience in a related field (e.g., healthcare analytics, data science, statistics etc.)
• A bachelor’s degree in quantitative or technical field preferred (e.g., data science, applied analytics, statistics, operations research, mathematics, engineering, etc.)
• Experience with web scraping and process automation
• Experience with relational databases and knowledge of database management fundamentals
• Expertise in building PowerPoint presentations preferred
• Exposure to other programming languages is a plus (e.g. R)
• Strong analytical and quantitative problem-solving skills
• Ability to connect disparate data and information to identify themes and trends
• Strong written and oral communication skills and the ability to clearly present results of complex analyses
• Ability to work with variety of stakeholders, particularly executives, and communicate effectively
• Intellectual curiosity, willingness to learn the industry, and tools to grow in your career

Responsibilities

• Analytics & Insights: Understand product, supplier, and industry dynamics; perform ad hoc analyses and oversee recurring deliverables; translate data into insights; design dashboards.
• Data Infrastructure: Learn proprietary data infrastructure; collect, clean, validate, and process data; design data pipelines and ETL/storage approaches.
• Cross-functional Support: Meet with business users; drive projects; support supplier meetings with portfolio assessments; model purchasing methodologies.
• Executive Presentations: Research regulatory/business topics; build visuals; craft narratives; deliver executive-facing presentations.

Skills

Excel

SQL

Tableau

Salesforce

Python

Web scraping

Process automation

PowerPoint

R

Education

Bachelor's degree in quantitative field

Tools

SQL

Tableau

Salesforce

Python

Job description

Red Oak Sourcing is seeking a data analyst for the Strategy & Analytics team to design Tableau/Salesforce dashboards, manage SQL databases, automate processes in Python, build data pipelines, and perform at hoc analytics to inform daily generic pharmaceutical sourcing strategy as well as longer-term decisions made by the Executive Leadership Team.

Success in this role requires strong analytics skills, experience with key data tools, and the ability to work collaboratively across business