Business Intelligence Analyst

Description
Business Intelligence Analyst
Pune, India

Optimas 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

Position overview:
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