About the Company
Our client is a healthcare services organization specializing in Non-Emergency Medical Transportation (NEMT). The company partners with health plans, Managed Care Organizations, and government payors to coordinate medical transportation for members across multiple states, ensuring timely, reliable access to healthcare appointments. With a strong focus on data-driven operations, provider network management, and member experience, the organization plays a critical role in connecting underserved populations to essential care.
About the Role
The Financial Data Analyst supports financial and operational reporting, focusing on trip data, claims, provider payments, member utilization, and cost performance. The role combines financial analysis with hands-on data management using Excel, Power Query, SQL, and Power BI to build reliable reports and dashboards.
Responsibilities
- Extract, clean, and combine data from claims systems, trip management platforms, and financial systems using Power Query and SQL.
- Validate data accuracy and reconcile operational data with financial records.
- Build and maintain dashboards in Power BI and Excel to track financial and operational KPIs.
- Automate recurring reports such as trip summaries, mileage reports, and provider payment analysis.
- Analyze trip volume, mileage, reimbursement rates, and provider payments.
- Support monthly close, variance analysis, and financial reporting activities.
- Track key NEMT performance metrics, including cost per trip, on-time performance, and member utilization.
- Support profitability and contract performance analysis by payor and region.
- Maintain reporting templates and document data sources, definitions, and processes.
- Partner with FP&A, Operations, Provider Relations, and IT on data and reporting requests.
Qualifications
- Bachelor’s degree in Finance, Accounting, Economics, Data Analytics, Healthcare Administration, or related field.
- 2–3 years of experience in financial analysis, data analytics, healthcare operations, or related roles.
- Strong proficiency in Microsoft Excel (pivot tables, Power Query, advanced formulas).
- Intermediate knowledge of SQL (SELECT, JOIN, subqueries, aggregations).
- Experience with Power BI or similar visualization tools preferred. Familiarity with data modeling, ETL concepts, financial modeling, and data validation.
- Experience working with large datasets is a plus.
Education:
Experience:
- Databases: 2 years (Required)
Location:
- Miami, FL 33142 (Required)
Work Location: In person