Business Analyst – Compounding Pharmacy Operations

Ilocatum; Plano (TX); On-site; USD 75,000 - 100,000; Full time

Benefits offered by this job

Medical, dental, vision

401(k)

High visibility with executive领导

Job summary

Ilocatum in Plano, TX is seeking a Business Analyst for Compounding Pharmacy Operations to turn operational, clinical, and financial data into actionable decisions. You’ll build dashboards and KPIs used by leadership to run the business and drive continuous improvement in a fast-growing setting.

The role requires strong SQL, advanced Excel, and experience with BI tools. You’ll translate complex data into clear recommendations for technical and non-technical audiences while ensuring compliance

Qualifications

• 5+ years of professional data analysis.
• Strong SQL and advanced Excel.
• Dashboards in Power BI, Tableau, or Qlik, or similar.
• Bachelor’s in Data Analytics, Business Analytics, Health Informatics, Statistics, or related field.
• Translates complex data into clear recommendations for technical and non-technical audiences.

Responsibilities

• Analyze operational, clinical, and financial data to find trends and inefficiencies.
• Build and maintain dashboards, reports, and KPIs for pharmacy leadership.
• Automate reporting with SQL and Excel.
• Ensure data accuracy and healthcare reporting compliance.
• Support continuous improvement, regulatory reporting, and audits.

Skills

Data analysis experience

Data storytelling

Education

Bachelor’s in Data Analytics / related field

Tools

SQL

Excel (advanced)

Power BI

Tableau

Qlik

Job description

Business Analyst, Compounding Pharmacy Operations

Plano, TX (Dallas-Fort Worth)

Turn operational, clinical, and financial data into decisions for a fast-growing compounding pharmacy. You’ll build the dashboards and KPIs leadership runs the business on.

Must-Haves

• 5+ years of professional data analysis
• Strong SQL and advanced Excel
• Dashboards in Power BI, Tableau, Qlik, or similar
• Bachelor’s in Data Analytics, Business Analytics, Health Informatics, Statistics, or related field
• Translates complex data into clear recommendations for technical and non-technical audiences

What You’ll Do

• Analyze operational, clinical, and financial data to find trends and inefficiencies
• Build and maintain dashboards, reports, and KPIs for pharmacy leadership
• Automate reporting with SQL and Excel
• Ensure data accuracy and healthcare reporting compliance
• Support continuous improvement, regulatory reporting, and audits

Nice-to-Haves

• Healthcare, pharmacy, or pharmaceutical experience
• HIPAA familiarity
• Python, R, or reporting automation
• Master’s in an analytical or healthcare field

What You’ll Get

• $75K to $100K
• Medical, dental, vision, and 401(k)
• High visibility with executive leadership

About the Company

An innovative, rapidly growing compounding pharmacy in Dallas-Fort Worth.