Assoc Analyst Business Analytics

Associate Business Analyst -SPT Job Description: Medline is expanding its operations in Pune and is seeking Associate Business Analyst with strong expertise in data analysis, reporting, and business process automation. This role is responsible for delivering accurate, data-driven insights and timely, actionable reports that support strategic business decisions and operational excellence. The ideal candidate will have hands-on experience in developing and maintaining reporting and automation solutions using Microsoft Excel (VBA), MS Access, SQL Server, Microsoft Fabric, Python, and Power BI. The role also involves optimizing reporting processes, designing efficient database solutions, automating workflows, and driving continuous improvement initiatives to enhance operational efficiency, data quality, and overall business performance. Some of the roles and responsibilities • Identify, extract, and analyze data to support key business functions and decision-making across departments. • Design and develop tools or automate manual reporting processes using Excel VBA, MS Access, SQL, Python and Microsoft Power Platform (Power Apps, Power Automate, Power BI, Fabric) based on business requirements. • Prepare and deliver reports for stakeholders including Product Managers, Sales, and Rebate teams, ensuring clarity and actionable insights. • Collaborate with internal teams such as Sales, Inventory Management, and Marketing to gather requirements and deliver meaningful analytics and reporting solutions. • Perform data-driven analysis to support process improvement initiatives and enhance operational efficiency. • Ensure data quality, accuracy, and integrity in all analysis and reports; proactively communicate any discrepancies to relevant stakeholders. • Follow up on analytical outcomes, working with business users to ensure recommendations are reviewed and appropriately implemented. • Validate and cross-reference data submissions, particularly from Sales, and perform initial analysis to support broader data evaluations. • Manage and manipulate large datasets in Excel and Access with precision and efficiency to meet tight deadlines. Required Skills • Intermediate to advanced knowledge of Fabric, SQL and Python o Microsoft Fabric – Designing and implementing Lakehouse solutions, data migration, data validation, ETL pipelines, and integrating Fabric with SQL Server and Power BI. o SQL Server – Developing complex SQL queries, creating and optimizing stored procedures, views, functions, triggers, and indexes to improve database performance and automate data processing o Python – Building data validation and automation tools using libraries such as PySpark, Pandas, SQLAlchemy, PyODBC, OpenPyXL, NumPy, and Requests for large-scale data processing, reporting, Data pipeline automation and database integration. • Advanced proficiency in Microsoft Excel and MS Access, including complex formulas, pivot tables, VBA, forms, queries, and report generation. • Good to have hands-on experience with Microsoft Power Platform: o Power Apps (Canvas and Model-Driven) – designing user-friendly business applications. o Power Automate – automating workflows and improving operational efficiency. o Power BI – creating dynamic, interactive dashboards and visual reports. • Strong analytical and problem-solving skills, with the ability to translate data into actionable insights and business solutions. • Excellent written and verbal communication skills, capable of conveying technical information clearly to both technical and non-technical stakeholders. • Customer-oriented mindset, responsive to stakeholder queries and committed to delivering high-quality support and solutions. • Self-motivated and proactive, capable of managing tasks independently and prioritizing workload effectively. • Detail- and deadline-oriented, with a focus on accuracy, quality, and timely delivery. • Innovative thinker, able to identify opportunities for automation and efficiency improvements in business processes by collaborating with internal and external stakeholders. Educational Qualification Any Graduate / Post Graduate degree Work Experience: 2-4 years of relevant experience

• About Medline India: Medline India was setup in 2010 in Pune, primarily as an offshore Development centre 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 centres, physician offices, home care agencies, providers, and retailers. We are 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.