Financial Data Analyst

HP; Bengaluru; On-site; INR 800,000 - 1,300,000; Full time

Job summary

HP is seeking a finance data analyst to ensure integrity and accuracy of financial records under GAAP. You will manage core accounting processes, perform data extraction and transformation, and automate reporting using SQL and Python.

Qualified candidates have 2+ years in data analysis and automation, with CA/CMA/CPA or equivalent and certifications in Python/SQL. Collaboration with finance teams is key to enhancing close processes and reporting.

Qualifications

• Chartered Accountant, CMA India, or CPA (or equivalent).
• 2+ years of experience in data analysis and automation in finance.
• Certification in Python, SQL or automation tool.

Responsibilities

• Extract, transform, validate, and analyze large datasets to support finance operations and reporting.
• Write and optimize SQL queries to retrieve and summarize data accurately.
• Use Python or similar scripting to automate data prep, validation, and reporting tasks.
• Develop scalable data automation to reduce manual effort and strengthen controls.
• Perform data quality checks and resolve data gaps with stakeholders.
• Translate business requirements into data logic and reporting workflows.

Skills

General Ledger Accounting

Balance Sheet Review

Stakeholder Management

Excel

VBScript/VBA

SQL

Data Analysis

Automation

Education

CA / CMA India / CPA

Python / SQL Certification

Tools

SQL Server

MS Access

Power BI

Power Apps

SharePoint Designer

Job description

Job Summary

This job family is responsible for maintaining the integrity, accuracy, and compliance of the company's financial records and reporting in accordance with GAAP and applicable regulatory requirements.

It oversees core accounting processes, including general ledger management, journal entries, reconciliations, fixed assets, capital expenditures, revenue recognition, cash flows, and financial close activities, providing timely and reliable financial information to support internal and external stakeholders.

Responsibilities

• Extract, transform, validate, and analyze large datasets from multiple systems to support finance operations, reporting, reconciliations, and process decision-making.
• Write and optimize SQL queries to retrieve, join, reconcile, and summarize large volumes of structured data accurately and efficiently.
• Use Python or similar scripting tools to automate repetitive data preparation, validation, reporting, and exception identification activities.
• Develop scalable data automation solutions to reduce manual effort, improve accuracy, and strengthen control effectiveness across accounting and operational processes.
• Perform data quality checks, identify inconsistencies, investigate root causes, and partner with stakeholders to resolve data gaps or process issues.
• Translate business requirements into data logic, reporting outputs, and automation workflows by working closely with finance operations teams.
• Support process improvement initiatives by applying data analysis, trend review, and automation opportunities to improve productivity, timeliness, and decision support.
• Support month-end, quarter-end and year-end close activities for assigned R2R , P2P or AR processes, ensuring timely and accurate completion of close deliverables.
• Analyze balance sheet accounts, prepare trend commentary, and report exceptions, risks, and improvement opportunities.
• Ensure compliance with accounting policies, internal controls, SOX requirements and reporting standards.
• Identify process gaps, recommend improvements and support automation or standardization initiatives within reconciliations, journal entry processes and financial reporting.

Education & Experience Recommended

Professional qualification preferred:

• Chartered Accountant (CA) or Cost and Management Accountant (CMA India) or Certified Public Accountant.
• Certification in Python, SQL or any Automation related tool
• Typically, 2+ years of experience
• Experience in driving Data analysis and Automation

Knowledge & Skills

• General Ledger Accounting and Balance Sheet Review
• Accounting Standards and Policies
• Stakeholder Management
• Good business application skills - Microsoft Excel
• Scripting Languages: VBScript/VBA
• Database: SQL Server & MS Access
• Tools: SharePoint Designer, Power BI & Power Apps
• Good communication skills.