Job Title: A&A; Staff-Data Ingestion & Analysis

Role Summary:
The Data Ingestion & Analysis Analyst is responsible for supporting Assurance engagement teams through the extraction, transformation, validation, ingestion, and analysis of client financial data. This role plays a critical part in ensuring data quality and enabling engagement teams to leverage analytics platforms such as MindBridge, Validis, CaseWare.

The ideal candidate combines robust data management and analytical skills with a working knowledge of accounting and auditing processes. They will work closely with engagement teams, clients, and Data COE members to streamline data workflows, improve efficiency through automation, and deliver audit-ready datasets.

Key Responsibilities:

Data Extraction
- Coordinate with audit teams and clients to understand data requirements.
- Extraction of data from ERP/accounting systems (e.g., QuickBooks, NetSuite, SAP, Oracle).
- Extraction of transactional or operational data from client - specific tools.
- Validate completeness and accuracy of source data received.





Data Transformation & Preparation
- Cleanse, standardize, and transform data for audit and analytics purposes.
- Develop reusable templates and workflows using: Excel, Power Query, VBA, Python, TeamMate Analytics.
- Handle data anomalies, missing values, duplicate records, and formatting issues.
- Create and maintain data mapping documentation.

Data Ingestion Support
- Prepare and upload data into audit analytics platforms including: MindBridge, Validis, CaseWare.
- Map customer data fields to platform requirements.
- Troubleshoot ingestion failures and reconciliation issues.
- Perform validation procedures to ensure imported data matches source records

Reporting & Visualization
- Creating dashboards and reports in tools like MindBridge, Power BI or Excel.
- Provide ad hoc analytical support to engagement teams and leadership.

Automation & Process Improvement
- Identify opportunities to reduce manual

📌 Staff-Data Ingestion (Hyderabad)
🏢 Citrin Cooperman India
📍 Hyderabad