Title: Operations BI Specialist
About Medline:
About Medline India:
Medline India was setup in 2010 in Pune, primarily as an offshore Development center and to augment resources for Medline Industries LP headquartered in Chicago, USA. We are a 1500+ strong and growing team of technology, finance and business support professionals who support our businesses worldwide towards a mission to make healthcare run better. We are proud to be certified as a ‘Great Place to Work’ by the Great Place to Work Institute® (India) for the duration May 2023 – May 2024.We are an organization with a conducive work environment, ample opportunities to learn, contribute and grow with a highly empowered & engaged team. We encourage our people to share their best ideas and create new opportunities for our customers and ourselves to work together to solve today’s toughest healthcare challenges.
About Medline Industries, LP:
Established in 1966, Medline Industries LP is a renowned global healthcare organization boasting 56 years of consecutive sales growth, exceeding $21 billion in annual sales. With a workforce of over 36,000 professionals spread across the globe, we operate in more than 125 countries and territories. As the largest privately held manufacturer and distributor of medical supplies in the United States, Medline is uniquely positioned to offer comprehensive products, education, and support across the continuum of care.At present, Medline Industries, LP holds the esteemed position as the #1 market leader, delivering an extensive portfolio of over 550,000 medical products and clinical solutions. Our clientele includes hospitals, extended care facilities, surgery centers, physician offices, home care agencies, providers, and retailers.We're proud to be recognized by Forbes as one of America’s Best Large Employers and Best Employers for Women. Additionally, the Chicago Tribune has consistently named us a Top Workplace for the past 12 years.Based in India, this role supports Australian Operations by developing, maintaining and enhancing BI solutions across functions such as Warehousing, Inbound and Outbound Logistics and MedTrans activities. The individual is expected to be an expert in current reporting tools and design and lead future developments (such as reports and dashboards), ensuring timely and proactive support with a strong focus on delivering reports and data to the Australian Operations team.
Key Responsibilities
- Design, develop, and maintain interactive dashboards, KPI reports, using Power BI, SQL, and other BI tools to support data-driven decision-making.
- Design automated data extraction tools and workflows to improve data reliability and reduce manual work from various source data including Excel, ERP, CSV, PDF, databases and any other source data formats as required.
- Develop automation solutions using Power Automate, Python, and VBA to streamline processes, reduce manual effort, and enhance data accuracy.
- Develop and maintain custom applications and automated workflows using Power Apps and Power Automate to streamline business processes and improve operational efficiency.
- Analyze existing operational reporting and dashboards to identify gaps, inefficiencies, or opportunities for harmonization.
- Conduct rigorous testing and validation of new reports/tools with end users before delivery.
- Deliver reports by the required date as required by the Australian Operations team.
- Continuously improve existing reports and dashboards with a focus on user experience, speed, and ease of use
Must Have
- 7-10 years of experience with Proven expertise in data analysis and business intelligence (BI) report development, with a strong focus on designing reports for end user analysis.
- Experience in developing and maintaining Business Intelligence dashboards and reports using Power BI is a Must; MicroStrategy experience is a plus.
- Proficiency in data automation and scripting using Python, VBA, and Power Automate.
- Hands-on experience with the Microsoft Power Platform, including Power Apps and Power Automate, to build custom solutions and automate workflows
- Advanced MS Office skills, particularly in Excel (including Power Pivot and Power View)
- Strong Functional knowledge of Warehousing, Transportations and supporting systems like ERP/WMS/TMS.
- Working knowledge of SQL Server, including writing and optimizing queries
- Strong ability to work with and manipulate large datasets, including flat files and structured data sources
- Fluent in English, both written and spoken.
- Strong sense of accountability with a consistent ability to meet deadlines
- Master’s degree in Operations/Supply Chain Management, or Engineering (preferred).
Good to Have
- Prior experience working with global or multi-site Operations networks.
- Microsoft Power BI certification & power Platform is a strong plus
Working Hours:
10.30 am to 7.30 pm IST – daylight saving11.30 am to 8.30 pm IST – non daylight saving
