Business Intelligence Analyst

1 day ago


Pune, Maharashtra, India Optimas Solutions Full time ₹ 2,50,000 - ₹ 7,50,000 per year

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


  • Pune, Maharashtra, India Robustrade Dmcc Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    Job Summary:The BI Analyst will work closely with the Business Intelligence (BI) Manager to gather, analyze, and transform business data into actionable insights that inform decision-making and drive business performance. The ideal candidate will possess advanced skills in BI tools, particularly Power BI and Tableau, and have the ability to design and...


  • Pune, Maharashtra, India Acquia Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    About AcquiaAcquia empowers the world's most ambitious brands to create digital customer experiences that matter. With open source Drupal at its core, the Acquia Digital Experience Platform (DXP) enables marketers, developers, and IT operations teams at thousands of global organizations to rapidly compose and deploy digital products and services that engage...


  • Pune, Maharashtra, India Sibylline Ltd Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    Company Description About SibyllineSibylline is a leading intelligence and strategic risk consultancy in the security sector. Since 2010 we have supported businesses, governments and NGOs through the provision of high-quality risk analysis, due diligence and consultancy services. The firm provides an innovative, entrepreneurial and fast-growing working...


  • Pune, Maharashtra, India Sibylline Ltd Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    Company Description About SibyllineSibylline is a leading intelligence and strategic risk consultancy in the security sector. Since 2010 we have supported businesses, governments and NGOs through the provision of high-quality risk analysis, due diligence and consultancy services. The firm provides an innovative, entrepreneurial and fast-growing working...


  • Pune, Maharashtra, India Ecolab Full time ₹ 10,00,000 - ₹ 25,00,000 per year

    Key Responsibilities:Design, create, and maintain process intelligence analyses including Signavio-based insights for assigned process portfolio - Order to CashCollaborate across process mining, insights, Global Capability Owners, and continuous improvement teams to enhance tool utilization and effectivenessDevelop and execute the strategy for process...

  • Business Analyst

    2 days ago


    Pune, Maharashtra, India Programming Full time ₹ 6,00,000 - ₹ 12,00,000 per year

    Company Description empowers global enterprises to scale in a digital-first world with intelligent next-gen digital solutions. With over 22 years of excellence and a team of 2200+ tech experts, we have delivery hubs in the USA, India, Singapore, Mexico, and Ukraine. We have successfully executed over 1000 projects across diverse industries such as...


  • Pune, Maharashtra, India NextAstra Technologies Pvt. Ltd. Full time ₹ 4,00,000 - ₹ 12,00,000 per year

    Company DescriptionNextAstra Technologies Pvt. Ltd. transforms businesses through intelligent, customized solutions that convert complex challenges into competitive advantages. Combining deep expertise in applied AI and custom software development, we deliver technology consulting, web and mobile applications, industrial automation, embedded IoT systems,...


  • Pune, Maharashtra, India TESTQ Full time ₹ 1,04,000 - ₹ 13,08,780 per year

    Job DescriptionFunctional AccountabilitiesDevelop internal business intelligence reports - including interactive business intelligence reports, strategic management reports, and ad hoc reports - on a prioritized basis.Enhance internal reporting by allowing us to provide more detailed and meaningful figures on usage and trends.Create new and enhance existing...

  • Business Analyst

    1 week ago


    Pune, Maharashtra, India FreightFox Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    AtFreightFox, we're reimagining how India's manufacturing enterprises move freight — with data, intelligence, and technology at the core. We're seeking aBusiness Analystwho thrives at the intersection ofoperations, analytics, and technologyto turn complex logistics challenges into smart, scalable solutions.As a Business Analyst, you will act as...


  • Pune, Maharashtra, India Workday Full time ₹ 1,20,000 - ₹ 3,00,000 per year

    Your work days are brighter here.At Workday, it all began with a conversation over breakfast. When our founders met at a sunny California diner, they came up with an idea to revolutionize the enterprise software market. And when we began to rise, one thing that really set us apart was our culture. A culture which was driven by our value of putting our people...