Business Intelligence & Automation Analyst

Metro Ambulance is a growing healthcare transportation company providing safe, reliable, and compassionate non‑emergency medical transportation services throughout New Jersey. We are investing in technology, data, and process improvement to help us operate more efficiently, better serve our customers, and make smarter business decisions.

This role will be responsible for transforming data into actionable business insights, building executive dashboards, automating workflows, and helping management make data‑driven decisions. You will work directly with company leadership to develop reporting, analytics, and automation solutions across operations, billing, finance, fleet management, and human resources.

• Design, develop, and maintain Power BI dashboards and reports.
• Create executive‑level KPI dashboards and operational scorecards.
• Develop reports that provide visibility into:
  • Transportation volume and utilization
  • Revenue and collections
  • Payer performance
  • Customer and referral source trends
  • Staffing and overtime
  • Fleet utilization and maintenance
  • Operational productivity
• Extract, transform, and analyze data from multiple systems.
• Develop and maintain SQL queries, views, and data models.
• Build automated data pipelines using Power Query and Microsoft tools.
• Ensure data accuracy, consistency, and reliability.
• Identify trends, opportunities, and operational inefficiencies through data analysis.
• Design and implement business process automations using Microsoft Power Automate.
• Automate recurring reports, notifications, approvals, and workflows.
• Partner with department leaders to streamline manual processes.
• Support development of Power Apps and other low‑code business solutions.
• Work directly with leadership to identify reporting needs and business priorities.
• Translate business requirements into technical solutions.
• Provide recommendations based on data‑driven insights.
• Serve as the internal subject matter expert for reporting, analytics, and automation.

• Bachelor's degree in Information Systems, Data Analytics, Business Analytics, Computer Science, or a related field.
• 3+ years of experience in business intelligence, analytics, reporting, or related roles.
• Strong experience with Power BI, Power Query, SQL, Microsoft Excel, and building dashboards and data visualizations.
• Strong analytical and problem‑solving skills.
• Excellent communication and stakeholder management skills.

• Establish a centralized reporting environment.
• Create executive dashboards used by leadership.
• Automate manual reporting processes.
• Improve visibility into operational and financial performance.
• Develop actionable insights that improve efficiency, profitability, and customer service.

• Competitive salary
• Performance bonus opportunity
• Health benefits
• Paid time off
• Professional development opportunities
• High visibility and direct access to leadership
• Opportunity to shape the company's analytics and automation strategy

Nutley, New Jersey

Full‑Time

$80,000 - $105,000 annually
, commensurate with experience

If you are passionate about data, automation, and helping businesses make smarter decisions, we'd love to hear from you. Please submit your resume along with examples of dashboards, analytics projects, or automation solutions you have developed.

Metro Ambulance is an Equal Opportunity Employer.