Business Intelligence Analyst

Pixfirst; Bengaluru; On-site; INR 600,000 - 900,000; Full time

Job summary

A data-driven company in Bengaluru is seeking a skilled business intelligence analyst to organize, analyze, and report on various data sources crucial for business operations. The ideal candidate will manage sales and product metrics, support the finance team, and collaborate with both product and operations teams to enhance performance. The role requires expert proficiency in Excel and experience with data visualization tools, SQL, and Python for effective data analysis.

Qualifications

• Expert-level proficiency in Excel.
• Familiarity with data visualization tools like Tableau, Kibana, or Grafana.
• Strong analytical and problem-solving skills required.

Responsibilities

• Manage and analyze company sales, revenues, profits, and other KPIs.
• Analyze photographer-level metrics, e.g., sales and conversion rate.
• Collaborate with the product team to improve product adoption.

Skills

Expert-level proficiency in Excel

Strong analytical and problem-solving skills

Excellent communication and collaboration abilities

Experience in SQL for data querying and manipulation

Experience in Python for data analysis

Tools

Tableau

Kibana

Grafana

Job description

We are looking for a business intelligence analyst who can organize and analyze data from various sources and create reports and metrics. He should be able to both deeply analyze data and succinctly explain metrics and insights from it to different stakeholders.

As a BI Analyst, you will be responsible for managing various data and metrics crucial to our business operations, including company sales and revenues, customer-level metrics, and product usage metrics. Additionally, you will collaborate with finance teams, assisting in tasks such as invoicing and cash flow management. This role also involves close collaboration with product and operations teams to analyze product metrics and enhance overall product performance.

Responsibilities

• Manage and analyze company sales, revenues, profits, and other KPIs.
• Analyze photographer-level metrics, e. g., sales, average basket, conversion rate, and growth.
• Analyze product usage data and collaborate with the product team to improve product adoption and performance.
• Perform ad hoc analysis to support various business initiatives.
• Assist the finance team in invoicing, cash flow management, and revenue forecasting.

Requirements

• Expert-level proficiency in Excel.
• Familiarity with one or more data visualization and exploration tools, e.g., Tableau, Kibana, Grafana, etc.
• Strong analytical and problem-solving skills.
• Comfortable with analyzing large amounts of data and finding patterns and anomalies.
• Excellent communication and collaboration abilities.
• Experience in SQL for data querying and manipulation.
• Experience in Python for data analysis, e.g., pandas, numpy, scipy, matplotlib, etc.
• Familiarity with statistical analysis techniques.
• Experience with basic accounting, e.g., balance sheets, P and L statements, double-entry accounting, etc.