Business Intelligence AnalystPune, IndiaOptimas is a global distributor of integrated supply chain solutions, and engineering support focused on delivering fasteners, components, industrial and safety supplies to our diverse customers around the world. Our local, on-the-ground teams understand the nuances of every community we serve. This allows us to adapt with our customers and partners as needs evolve, leveraging our footprint to remain at your side while providing a highly personalised level of service and support no matter where you find yourself around the globe.To learn more, please visit our website http://www.optimas.com/We are seeking a detail-oriented and analytical Business Intelligence Analyst to join our growing BI team at a mid-sized Supply Chain distribution company. In this role, you will play a key part in supporting cross-functional teams by delivering high-quality, data-driven insights and solving ad hoc analytical requests. You will work primarily with Excel and SQL, transforming complex data into actionable insights that drive operational and strategic decision making.This position is ideal for someone who enjoys digging into data, problem-solving in real time, and collaborating across departments in a fast-paced, results-driven environment.Main responsibilities:
Respond to ad hoc data requests from internal stakeholders with accuracy, clarity, and speed
Use Excel (including pivot tables, Power Query, advanced formulas) to analyse, clean, and present data in a clear and actionable format
Develop and execute SQL queries to extract and manipulate data from various systems and databases.
Create and maintain custom reports and dashboards to monitor key performance indicators (KPIs) and operational metrics
Partner with departments across the organisation to understand their needs and deliver data solutions that drive smarter decisions
Validate data integrity and troubleshoot discrepancies in reporting or analysis
Document repeatable processes to improve team efficiency and reduce response times for recurring requests
Collaborate with the BI team to identify opportunities for automation or tool enhancement
Qualifications:Required:
Bachelor’s degree in Business Analytics, Information Systems, Supply Chain, or a related field
2+ years of experience in an analyst role with a focus on SQL and Excel
Ability to prioritise and manage multiple ad hoc requests simultaneously in a fast-paced environment
Strong proficiency writing and optimizing SQL queries for data extraction and analysis
Advanced Microsoft Excel skills, including experience working with large datasets
Excellent problem-solving skills with a keen eye for detail
Strong interpersonal and communication skills – ability to translate business needs into data solutions
Preferred:
Experience in a Supply Chain, Logistics, or Distribution environment
Understanding of Supply Chain concepts such as inventory turns, order cycle time, and fulfilment rates
Familiarity with BI tools such as Power BI, Tableau, or similar platforms
Familiarity with ERP systems and warehouse management data (e.g., NetSuite, SAP, Oracle)
Knowledge of basic data modelling and reporting best practices
Why Join Us:
Opportunity to make a tangible impact on a growing business through data-driven insights
Work in a collaborative environment that values curiosity, initiative, and continuous improvement
Exposure to a wide range of business functions and data challenges
Opportunities for professional development in business intelligence and analytics
About Optimas Solutions
Optimas is a global manufacturer/distributor and service provider of fastening and supply chain solutions for manufactures seeking to improve their efficiency and profitability.
