Associate - Operations Support

Blackbox Analytics & Solutions Private Limited; Bengaluru; On-site; INR 8,00,000 - 12,00,000; Full time

Job summary

A technology solutions provider in Bengaluru is seeking an experienced professional to build complex performance reports and utilize Power BI, VBA, and SQL for analytics. The ideal candidate will have strong analytical skills and experience in advanced Excel, database management, and the ability to communicate effectively across teams. This role supports the mission to accelerate business through effective data-driven solutions.

Qualifications

• Bachelor's degree in a relevant field preferred.
• 3+ years of MS Excel experience, expert level required.
• Intermediate-to-Expert-level VBA skills.

Responsibilities

• Build complex reports related to operations performance.
• Utilize Power BI, VBA, and SQL for reporting solutions.
• Develop metrics and dashboards for product and inventory performance.

Skills

Strong analytical skills

Advanced Excel

Power BI

VBA

Organizational skills

Communication skills

Education

Bachelor's degree in Business Administration, Computer Science, MIS, Mathematics or related field

Tools

Power BI

SQL

SAP HANA

Job description

Primarily Roles & Responsibilities

• Build complex reports related operations performance. (Back-log report, ETA, POS report, YTD/MTD/OTD, Exchange rate, Inventory, Demand Planning, Production Dashboard etc.)
• Utilize Power BI, VBA within Microsoft Excel and SQL design to interact robustly with users, in order to provide solutions using macros.
• Develop metrics and dashboard reporting for insight to product and inventory performance
• Responsible for adding list price for items/warranty services, such as price/cost changes, etc.
• Coordinate the collection of vendors related legal agreements; and retain copies, i.e., Environmental hazardous substantial certificates (ROHS), ISO certification etc.
• Create queries, design reports, and present findings then making recommendation to direct and upper management
• Analyze current business and reporting processes and look for means to improve efficiency and reduce bottlenecks
• Work closely with management to prioritize business and information reporting needs
• Provide assistance to the purchasing and product management teams to ensure that complete and accurate product information is obtained.
• Should have basic understanding on O2C SAP HANA process to perform reporting related activities.
• Always have a go getter attitude with adhoc works to be performed as assigned by manager.

Skills, Knowledge, Abilities

• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
• Requires excellent working knowledge of the advance excel, Power-BI, Vlook-up, macros, nested If condition, reverse look-up, data validation, conditional formatting, Microsoft Office 365.
• Requires the ability to deal effectively and professionally with internal and external customers.
• Must have outstanding organizational and multi-tasking skills and the ability to prioritize work effectively.
• Strong organizational skills to multi-task demanding priorities; effective use of resources to deliver results
• Solid understanding and familiarity with SAP or similar product database/ERP systems.
• Strong analytical and communication skills with the ability to successfully interact at all levels of the organization
• Ability to work effectively across many internal functional groups
• Excellent written and verbal communication skills
• Advanced in MS Office (Word, Excel, PowerPoint), Outlook, and ERP systems

Education/Experience Requirements

• Bachelor s degree in Business Administration, Computer Science, MIS, Mathematics or related field preferred
• Analytics:
  • Intermediate-to-Expert-level VBA skills
  • 3+ years MS Excel experience with demonstrated experience VBA, complex formulas (expert level required), able to provide solutions using Power BI, VBA within Microsoft Excel and SQL design to interact robustly with users, in order to provide solutions using macros
  • Database: Relational database experience (Power Query, SQL)

Supervisory Responsibility

None

Black Box is a leading technology solutions provider. Our mission is to accelerate our customers business by valuing relationships with our team members, clients and stakeholders. By continuously growing our knowledge, we remain relevant in the market and are in a superior position to help customers design, deploy and manage their IT infrastructure. Through our values, such as innovation, ownership, transparency, respect and open-mindedness, we deliver high-value products and services through our global presence and 2,500+ team members in 24 countries and growing. Black Box is a wholly-owned subsidiary of AGC Networks.

Black Box is an equal opportunity employer. Black Box does not discriminate against individuals on the basis of race, color, marital status, sex, sexual orientation, gender identity, religion, national origin, age, disability, veteran status, genetic information, or any other protected status, and endorses those policies and practices which seek to recruit, hire, train and promote the most qualified persons into available jobs.