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

n

nRole Summary:

nThe 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.

n

nThe ideal candidate combines strong 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.

n

nKey Responsibilities:

n

nData Extraction

n

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

n

nData Transformation & Preparation

n

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

n

nData Ingestion Support

n

n
- Prepare and upload data into audit analytics platforms including: MindBridge, Validis, CaseWare.
n
- Map customer data fields to platform requirements.
n
- Troubleshoot ingestion failures and reconciliation issues.
n




- Perform validation procedures to ensure imported data matches source records
n

n

nReporting & Visualization

n

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

n

nAutomation & Process Improvement

n

n
- Identify opportunities to reduce manual effort through automation.
n
- Develop and enhance data-processing workflows.
n
- Help maintain Data COE standard operating procedures (SOPs).
n
- Contribute to continuous improvement initiatives across the Assurance practice.
n

n

nCollaboration & Continuous Improvement

n

n
- Liaise with audit teams to clarify data requirements and timelines.
n
- Provide technical support to clients during data extraction and upload.
n
- Identify opportunities to automate repetitive data transformation tasks.
n
- Contribute to refining ingestion templates and SOPs.
n
- Stay updated on recent features in audit tools and ERP systems.
n

n

nTools & Technologies used

n

n
- Data Analytics Platforms - Excel (VBA, Power Query, Power Pivot, TeamMate Analytics), Python.
n
- Audit Analytics Platforms - Caseware, Validis, MindBridge.
n
- Visualization Tools - PowerBi.
n

n

nRequired Skills & Qualifications:

n

n
- Bachelor’s degree in data analytics, accounting, Finance, or related field.
n
- Proficiency in Data cleansing and transformation techniques.
n
- 3–5 years of experience with strong Excel/Power Query skills, basic accounting knowledge, and an aptitude for automation (Python/Power BI).
n
- Familiarity with audit platforms (Validis, MindBridge, Caseware) is a plus.
n
- Strong analytical thinking and attention to detail.
n
- Good communication and client-handling abilities
n

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