Description
Roles & responsibilities
The Senior Associate 1 - Data & Analytics will be part of the GDC Canada Audit team, supporting data engineering, analytics, reporting, and automation initiatives within the Audit Data & Analytics domain. The role involves working with ERP and audit datasets, including General Ledger (GL), Trial Balance (TB), and Journal Entries (JE), to deliver audit analytics, risk assessment, and reporting solutions for Audit and internal teams.
Key Responsibilities:
Develop and maintain ETL/ELT pipelines using Azure Databricks, PySpark, and SQL to ingest, transform, and process data from multiple sources.
Build and support Power BI dashboards, reports, datasets, semantic models, and DAX measures to enable business reporting and analytics.
Write and optimize SQL queries for data extraction, transformation, validation, and analysis.
Design and develop business applications using Microsoft Power Apps and workflow automation solutions using Microsoft Power Automate.
Perform audit analytics procedures using General Ledger (GL), Trial Balance (TB),
Journal Entries (JE), and other ERP data to identify risks, anomalies, and actionable insights.
Assist in the development, testing, deployment, and support of data & analytics solutions in accordance with established development standards and best practices.
Perform data quality checks, troubleshooting, and issue resolution to ensure accuracy, reliability, and completeness of data and reporting solutions.
Collaborate with stakeholders to understand business requirements and translate them into effective technical solutions.
Support data extraction, transformation, and analysis activities from ERP systems and other source applications.
Maintain accurate and up-to-date project status, ensuring timely communication of progress, risks, and dependencies.
Prepare and review engagement-related documentation and deliverables with a high degree of accuracy and attention to detail.
Support knowledge-sharing initi
📌 Senior Associate 1 (Bengaluru)
🏢 BSR
📍 Bengaluru