Duties: Conduct budget forecasting, variance analysis, and financial planning to support organizational goals; develop financial models to assess revenue, gross margin, and pharmacy fees across various service lines; design and maintain interactive dashboards in Power BI to monitor KPIs, including volume, revenue, gross margin, Rx fulfillment, and patient engagement metrics; generate reports for monthly, quarterly, and annual performance, with YTD, MTD, MoM, and WoW trend analysis; use historical data to forecast patient volume, prescription fills, and revenue using moving averages and Python-based statistical methods; perform cost and reimbursement analysis, including variance evaluation and 340B program insights; track operational performance metrics, such as patient drop-offs and outreach conversion using platforms; identify discrepancies between datasets (e.g., Denial Details and Open Balance) to improve financial reporting accuracy; clean, validate, and manage large datasets from SQL databases and Excel files to ensure accurate reporting and decision-making; extract, transform, and load (ETL) data using SQL queries; support automation of reporting processes; collaborate with IT and cross-functional teams to enhance data workflows, resolve inconsistencies, and align reporting with business strategies; present data-driven insights to senior leadership with actionable recommendations to improve financial and operational outcomes.
Requirements: · Master’s degree in Finance, Economics (Applied), or Data Intelligence · 6 months of experience using Power BI to build dashboards and reports; using Python for forecasting or data analysis; and using Excel for financial modeling and data analysis.
Hours: 40 hours per week.
Location: 8379 West Sunset Road, Suite 210, Las Vegas, NV 89113
Contact: Sagebrush Health Services, 8379 West Sunset Road, Suite 210, Las Vegas, NV 89113