Data Analyst

Jainco Transmission Limited; Howrah; In loco; INR 500.000 - 900.000; Tempo pieno

Descrizione del lavoro

Jainco Transmission Limited in Howrah seeks a Data Analyst to collect, clean, validate, and analyze data from multiple sources. You will develop and maintain Google Sheets dashboards, automate reporting with Apps Script, and write Java programs for data processing and reporting.

The role involves coordinating with IT, Finance, HR, Operations, and Sales to meet reporting requirements, ensuring data accuracy, and delivering ad-hoc analyses as needed.

Competenze

• Collect, clean, validate, and analyze business and operational data from multiple sources.
• Prepare daily, weekly, and monthly MIS reports, dashboards, and performance summaries.
• Develop and maintain Google Sheets for data tracking, reporting, reconciliation, and management dashboards.
• Use advanced Google Sheets functions such as QUERY, FILTER, VLOOKUP/XLOOKUP, INDEX-MATCH, ARRAYFORMULA, SUMIFS, COUNTIFS, and Pivot Tables.
• Automate repetitive reporting and data-processing activities using Google Apps Script.
• Develop, maintain, and troubleshoot Java-based applications, utilities, and data-processing programs.
• Write Java programs for data extraction, transformation, validation, automation, and report generation.
• Integrate data from databases, APIs, spreadsheets, and other business systems.
• Perform data quality checks, identify inconsistencies, and resolve data-related issues.
• Analyze trends, variances, KPIs, and operational performance and provide meaningful insights to management.
• Create automated workflows between Java applications, Google Sheets, databases, and other business tools
• Maintain data accuracy, security, consistency, and proper documentation.
• Prepare ad-hoc reports and analysis based on management requirements.
• Coordinate with IT, Finance, HR, Operations, Sales, and other departments to understand reporting requirements.
• Troubleshoot reporting, application, and data-related issues and provide timely solutions.
• Maintain technical documentation, report formats, data dictionaries, and process manuals.
• Continuously identify opportunities to automate manual processes and improve reporting efficiency.

Mansioni

• Collect, clean, validate, and analyze business and operational data from multiple sources.
• Prepare daily, weekly, and monthly MIS reports, dashboards, and performance summaries.
• Develop and maintain Google Sheets for data tracking, reporting, reconciliation, and management dashboards.
• Use advanced Google Sheets functions such as QUERY, FILTER, VLOOKUP/XLOOKUP, INDEX-MATCH, ARRAYFORMULA, SUMIFS, COUNTIFS, and Pivot Tables.
• Automate repetitive reporting and data-processing activities using Google Apps Script.
• Develop, maintain, and troubleshoot Java-based applications, utilities, and data-processing programs.
• Write Java programs for data extraction, transformation, validation, automation, and report generation
• Integrate data from databases, APIs, spreadsheets, and other business systems.
• Perform data quality checks, identify inconsistencies, and resolve data-related issues.
• Analyze trends, variances, KPIs, and operational performance and provide meaningful insights to management.
• Create automated workflows between Java applications, Google Sheets, databases, and other business tools
• Maintain data accuracy, security, consistency, and proper documentation.
• Prepare ad-hoc reports and analysis based on management requirements.
• Coordinate with IT, Finance, HR, Operations, Sales, and other departments to understand reporting requirements.
• Troubleshoot reporting, application, and data-related issues and provide timely solutions.
• Maintain technical documentation, report formats, data dictionaries, and process manuals.
• Continuously identify opportunities to automate manual processes and improve reporting efficiency.

Conoscenze

Data Analysis

Pivot Tables

MIS Reporting

KPI Analysis

Data Cleaning

Data Validation

SQL

Data Visualization

Exception Handling

Automation

Java basics

Strumenti

Java

Google Sheets

Google Apps Script

SQL

APIs

Google Drive

Descrizione del lavoro

Contact - 6292006033.

Location - Jalan Complex Gate no - 1.

1. local candidates prefer. Howrah, Kolkata etc.

Job Responsibilities Data Analyst / Java / Google Sheets

• Collect, clean, validate, and analyze business and operational data from multiple sources.
• Prepare daily, weekly, and monthly MIS reports, dashboards, and performance summaries.
• Develop and maintain Google Sheets for data tracking, reporting, reconciliation, and management dashboards.
• Use advanced Google Sheets functions such as QUERY, FILTER, VLOOKUP/XLOOKUP, INDEX-MATCH, ARRAYFORMULA, SUMIFS, COUNTIFS, and Pivot Tables.
• Automate repetitive reporting and data-processing activities using Google Apps Script.
• Develop, maintain, and troubleshoot Java-based applications, utilities, and data-processing programs.
• Write Java programs for data extraction, transformation, validation, automation, and report generation.
• Integrate data from databases, APIs, spreadsheets, and other business systems.
• Perform data quality checks, identify inconsistencies, and resolve data-related issues.
• Analyze trends, variances, KPIs, and operational performance and provide meaningful insights to management.
• Create automated workflows between Java applications, Google Sheets, databases, and other business tools.
• Maintain data accuracy, security, consistency, and proper documentation.
• Prepare ad-hoc reports and analysis based on management requirements.
• Coordinate with IT, Finance, HR, Operations, Sales, and other departments to understand reporting requirements.
• Troubleshoot reporting, application, and data-related issues and provide timely solutions.
• Maintain technical documentation, report formats, data dictionaries, and process manuals.
• Continuously identify opportunities to automate manual processes and improve reporting efficiency.

Key Skills Required

Data Analysis

• MS Excel / Google Sheets
• Pivot Tables & Dashboards
• Data Cleaning & Validation
• MIS Reporting
• KPI Analysis
• SQL
• Data Visualization
• Collections
• Exception Handling
• File/API/Data Processing
• Basic Java application development

Google Workspace

• Google Sheets
• Google Apps Script
• Google Drive
• Google Forms
• Automated reporting