Business Intelligence Analyst

MasonRX, Inc.

New York (NY)

On-site

USD 90,000 - 135,000

Full time

30 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Mason Pharmacy in the Bronx is creating a Business Intelligence Analyst role to build data systems and drive purchasing, inventory, and reimbursement decisions. The analyst reports to the President and will develop time-series forecasts, dashboards, and data pipelines.

The position emphasizes SQL, Python, and BI tools like Power BI or Tableau, with on-site work at 1255 Castle Hill Ave, Bronx, NY.

Qualifications

  • Bachelor’s degree in Data Science, Computer Science, or Business Analytics.
  • SQL and relational database design; Python (Pandas, NumPy); statistical modeling and forecasting; Power BI or Tableau.

Responsibilities

  • Forecast demand and manage inventory with time-series models and safety stock planning.
  • Analyze reimbursement vs. costs by payer, plan, and product; produce monthly margin reports.
  • Design and maintain a MySQL database; build SQL and Python pipelines for reporting; ensure data quality.
  • Create KPIs and dashboards in Power BI, Tableau, and Excel for key operational metrics.

Skills

SQL
Python (Pandas, NumPy)
Forecasting
Data analysis
KPIs & dashboards

Education

Bachelor’s degree in Data Science, Computer Science, or Business Analytics

Tools

MySQL
Power BI
Tableau
Excel

Job description

Build our data systems and use them to improve purchasing, inventory, and reimbursement decisions. The analyst reports to the President.

Location 1255 Castle Hill Avenue, Bronx, NY (on-site)

Type Full-time

Posted January 1, 2026

Mason Pharmacy is an independent retail pharmacy in the Bronx. We are creating a Business Intelligence Analyst position to build our data systems and use them to improve purchasing, inventory, and reimbursement decisions. The analyst reports to the President.

Responsibilities
  • Demand forecasting and inventory: build time-series forecasting models at the drug-product level, set reorder points and safety stock, compare acquisition cost across our four wholesalers, and analyze turnover, expired stock, and shrinkage.
  • Financial reporting: analyze reimbursement against acquisition cost by payer, plan, and product to find underpaid and negative-margin claims; model claim rejection and payment trends; produce monthly margin and payer-mix reporting.
  • Database and automation: design and maintain a MySQL database integrating pharmacy system, wholesaler, and point-of-sale data; build SQL and Python pipelines that replace manual spreadsheet reporting; test and troubleshoot data quality.
  • Dashboards: define KPIs and build dashboards in Power BI, Tableau, and Excel for prescription volume, fill time and accuracy, inventory turnover, and shrinkage; apply statistical process control to operational metrics.
  • Reporting and recommendations: prepare reports, presentations, and what-if analyses for ownership on purchasing, staffing, pricing, and payer participation.
  • Data governance: maintain access controls, de-identify health information in analytical datasets, and follow HIPAA.
Requirements
  • Bachelor’s degree in Data Science, Computer Science, or Business Analytics.
  • SQL and relational database design; Python (Pandas, NumPy); statistical modeling and forecasting; Power BI or Tableau.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

BI Analyst: Inventory, Forecasting & Profitability
BI Analyst: Inventory, Forecasting & Profitability

MasonRX, Inc. • New York (NY)

On-site
USD 90,000 - 135,000
Business Data Analyst
Business Data Analyst

InfinityRx • Village of New Hyde Park (NY)

On-site
USD 80,000 - 100,000
Competitive salary based on experience
Paid time off
Company laptop
+1
Pharmacy Analytics & Business Intelligence Analyst (Labor Pool)
Pharmacy Analytics & Business Intelligence Analyst (Labor Pool)

Riverside Health • Newport News (VA)

On-site
USD 47,000 - 65,000
Pharmacy Business Analyst
Pharmacy Business Analyst

Norman Regional • Norman (OK)

On-site
USD 75,000 - 110,000
Business Process Manager - Data Analytics
Business Process Manager - Data Analytics

Walgreens Co. • Deerfield (IL)

On-site
USD 90,000 - 115,000
Business Intelligence Analyst
Business Intelligence Analyst

Remote Jobs • Lakeland (FL)

On-site
USD 70,000 - 95,000
Pharmacy Inventory Analyst: Optimize Stock & Growth
Pharmacy Inventory Analyst: Optimize Stock & Growth

MasonRX, Inc. • New York (NY)

On-site
USD 55,000 - 85,000
Pharmacy Data And Reporting Analyst
Pharmacy Data And Reporting Analyst

Centerlight Management Services • New York (NY)

On-site
USD 85,000 - 95,000
Pharmacy Data Analyst
Pharmacy Data Analyst

The Health Plan Of West Virginia Inc • Wheeling (WV)

On-site
USD 65,000 - 85,000
Senior Manager Strategy Data Analytics Pharmacy, Westwood, MA. (Hybrid)
Senior Manager Strategy Data Analytics Pharmacy, Westwood, MA. (Hybrid)

Bilh • United States

On-site
USD 110,000 - 170,000