M
Medical Review Institute of America
Posted 54 days agoVerified live 2d ago
Business Intelligence Analyst (Remote)
Brief overview
Remote
UndergradOr in progress
2+ yrsMinimum
Microsoft ExcelPower QueryPower PivotVBAMicrosoft Power AppsBusinessObjectsSQLStatistical AnalysisData Modeling and TransformationFinancial ModelingPower BIMicrosoft FabricSnowflake
About the company
M
Medical Review Institute of Americamrioa.com
Medical Review Institute of America, LLC (MRIoA) is the top medical review company in the United States.
Job description
Summary
Medical Review Institute of America is a clinically driven, technology-enabled utilization management company providing expert clinical reviews, regulatory guidance, and actionable insights to healthcare organizations. The Business Intelligence Analyst delivers strategic reporting, develops and monitors KPIs, creates dashboards and board presentations, and translates financial, commercial, and operational data into actionable insights.
Responsibilities
- Deliver strategic reporting and insights to the C-Suite, Executive Management team, and Board of Directors
- Partner with the business’s functional leaders to develop KPIs, provide ongoing reporting, and analyze the business impact of strategic initiatives
- Understand the key levers of the business and devise new ways to segment and analyze the business
- Provide regular updates to the Executive Team on progress towards goals as well as proactively identify insights and recommendations for improvement
- Work cross-functionally to develop and monitor key performance indicators
- Identify trends, outliers, and obscurities in the data and translate them into actionable insights for functional leaders
- Assist in the creation of Board of Directors presentations with the ability to analyze financial, commercial, and operational data
- Create simple and compelling visuals to demonstrate business performance, trends, and progress
- Design and implement reporting solutions enabling stakeholders to manage the business and make effective decisions
- Create and update dashboards that will power operational teams and decorate hallway monitors
- Foster transparency and dedication to continuous improvement throughout the Company by being a steward of the data-driven culture at MRIoA
- Participate in strategic initiatives to facilitate forecasting business impact and analyzing the results of pilots/ implementations
- Ad hoc data retrieval and analysis
Skills
- Advanced Excel skills with the ability to utilize PowerQuery, PowerPivot, and VBA to support company reporting
- Ability to synthesize and communicate data effectively (verbally and visually)
- Knowledge and understanding of Power Apps and integrating usage into production environments
- Fast learner with a passion for taking on challenges
- Team player with the ability to work cross-functionally
- Constantly curious to dig deeper and understand the 'why'
- Self-starter that excels in fast-paced, high-growth environments and does not need direct management
- Advanced knowledge of Business Objects, SQL, and Microsoft Applications, including Excel
- SQL/DBA experience and ability to pull data from reporting servers for analysis
- 2+ years of statistical analysis or data analysis experience
- Experience working with modern data platforms and cloud analytics ecosystems (e.g., Microsoft Fabric, Databricks, or Snowflake), including data modeling, transformation, and analytical querying to support enterprise reporting and insights
- Experience building financial models and translating them into usable tools and simplified insights
- Experience with business intelligence (BI) and BI visualization tools required (e.g., Tableau, Power BI, Domo)
- Bachelor's Degree required
- Experience with private equity, venture capital, investment banking, management consulting, or a growth-stage healthcare or premium consumer business preferred
- Bachelor's Degree in Finance or Accounting preferred
Qualifications
Must Haves
- Advanced Excel skills with the ability to utilize PowerQuery, PowerPivot, and VBA to support company reporting
- Ability to synthesize and communicate data effectively (verbally and visually)
- Knowledge and understanding of Power Apps and integrating usage into production environments
- Fast learner with a passion for taking on challenges
- Team player with the ability to work cross-functionally
- Constantly curious to dig deeper and understand the 'why'
- Self-starter that excels in fast-paced, high-growth environments and does not need direct management
- Advanced knowledge of Business Objects, SQL, and Microsoft Applications, including Excel
- SQL/DBA experience and ability to pull data from reporting servers for analysis
- 2+ years of statistical analysis or data analysis experience
- Experience working with modern data platforms and cloud analytics ecosystems (e.g., Microsoft Fabric, Databricks, or Snowflake), including data modeling, transformation, and analytical querying to support enterprise reporting and insights
- Experience building financial models and translating them into usable tools and simplified insights
- Experience with business intelligence (BI) and BI visualization tools required (e.g., Tableau, Power BI, Domo)
- Bachelor's Degree required
Nice to Haves
- Experience with private equity, venture capital, investment banking, management consulting, or a growth-stage healthcare or premium consumer business preferred
- Bachelor's Degree in Finance or Accounting preferred
Benefits
- Benefits include healthcare, vision, and dental insurance
- A generous 401(k) match
- Paid vacation, PTO, and holidays
- Growth and training opportunities
- An award-winning remote work environment
