Healthcare Administrative Intern

As Mount Sinai grows, so does our legacy in high-quality health care.

Since 1949, Mount Sinai Medical Center has remained committed to providing access to its diverse community. In delivering an unmatched level of clinical expertise, our medical center is committed to recruiting and training top healthcare workers from across the country. We offer the latest in advanced medicine, technology, and comfort in 12 facilities across Miami-Dade (including our 674-bed main campus facility) and Monroe Counties, with 38 medical services, including cancer care, 24/7 emergency care, orthopedics, cardiovascular care, and more. Mount Sinai takes pride in being South Florida's largest private independent not-for-profit hospital, dedicated to continuing the training of the next generation of medical pioneers.

Culture of Caring: The Sinai Way

Our hardworking, tight-knit community of more than 4,000 dedicated employees fosters an environment of care and compassion. Each member plays a vital role in our collective mission to deliver excellent healthcare through innovation, education, and research. At Mount Sinai, we take pride in our achievements, aiming to be a beacon of quality healthcare in South Florida. We welcome all healthcare professionals to join our thriving community and contribute to our pursuit for clinical excellence.

The Ideal Candidate

• Continuously challenges the status quo and provides out of the box solutions to improve existing department processes
• Is very detail oriented and can independently identify discrepancies between two different reports and work to resolve the issue
• Has a knack for solving complex data problems
• Can handle working on multiple projects simultaneously
• Has developed multiple MS Access databases using all db objects: Tables, Forms, Queries, Reports, Macros
  
  

Responsibilities

• Provides data support to the Project Management Office and management team with respect to Labor and Productivity Management, Supply Chain, Revenue and Growth, Medical Management, and other initiatives as required.
• Work to streamline and automate existing recurring reports that are in MS Access by migrating queries to SQL and reports to Business Intelligence software such as Tableau.
• Develop, maintain, and manage frequent updates to multiple databases, spreadsheets, reports to support the functions of the project management office and its goals.
• Build a thorough understanding of all available data sources and understands variances between these sources. Generate concise and accurate trends, reports, presentations for display and dissemination as required from above data sources.
• Design, develop, test and implement management reports using report development tools
• Independently manages the retrieval and analysis of data on multiple tasks or projects, to timely project completion.
• Documents progress, resolution and time spent on all activities in the appropriate tracking system.
• Coordinates the scheduling, delivery, testing and implementation steps associated with database enhancements, fixes, and/or customizations for assigned areas.
• Provide users with application assistance and consultation within assigned product area of expertise.
• Accurately defines the desired results of new systems/processes or improvements to existing system/processes.
• Ensures effective integration of new or modified system/processes into the work environment.
  
  

Requirements

• A Bachelor of Science in Industrial Engineering, Computer Science, Management Information Systems, or similar
• Report development in SQL Server Management Studio, SQL Server Reporting Services, and Microsoft Access
• Experience with Microsoft Excel (including pivot tables and advanced formulas)
• Relational database architecture
• Experience with migrating databases/queries from MS Access to SQL Server
• Highly preferred experience with: Business Intelligence software such as Tableau or Lumira and front end development such as VB.NET