Data Analyst

Black Box; Bengaluru; On-site; INR 700,000 - 1,200,000; Full time

Job summary

Black Box in Bengaluru is seeking a data analyst capable of handling structured and unstructured data, building automated data pipelines, and creating interactive dashboards using BI tools.

You will perform financial and operational data analysis, support budgeting, automate with Python and VBA, apply Power Query and advanced Excel, and collaborate with finance and business stakeholders to deliver accurate reports.

Responsibilities

• Collect, clean, validate, and analyze structured and unstructured datasets.
• Develop and maintain automated data pipelines and reporting solutions.
• Build interactive and insightful dashboards using BI and visualization tools.
• Perform financial and operational data analysis to identify trends, anomalies, and opportunities.
• Support budgeting, forecasting, and performance reporting activities.
• Write efficient SQL queries for data extraction, transformation, and analysis.
• Develop Python and VBA-based automation solutions to improve process efficiency.
• Utilize Power Query and Advanced Excel capabilities for data transformation and reporting.
• Collaborate with finance and business stakeholders to understand reporting and analytical requirements.
• Create documentation for data models, processes, dashboards, and automation workflows.
• Ensure data accuracy, consistency, and governance across reporting systems.

Job description

Job Description:

Key Responsibilities

• Collect, clean, validate, and analyze structured and unstructured datasets.
• Develop and maintain automated data pipelines and reporting solutions.
• Build interactive and insightful dashboards using BI and visualization tools.
• Perform financial and operational data analysis to identify trends, anomalies, and opportunities.
• Support budgeting, forecasting, and performance reporting activities.
• Write efficient SQL queries for data extraction, transformation, and analysis.
• Develop Python and VBA-based automation solutions to improve process efficiency.
• Utilize Power Query and Advanced Excel capabilities for data transformation and reporting.
• Collaborate with finance and business stakeholders to understand reporting and analytical requirements.
• Create documentation for data models, processes, dashboards, and automation workflows.
• Ensure data accuracy, consistency, and governance across reporting systems.