Quick overview
Job description
Roles & responsibilities
The Associate 2 - Data & Analytics will be part of the GDC Canada Audit practice, supporting the delivery of data engineering, analytics, reporting, and automation solutions within the Audit Data & Analytics domain. The role requires hands-on experience in data preparation, transformation, dashboard development, and process automation while working closely with audit engagement teams to deliver high-quality, data-driven insights. The individual will work extensively with audit and financial datasets such as General Ledger (GL), Trial Balance (TB), Journal Entries (JE) to support audit analytics, and reporting requirements. The Associate 2 will be responsible for:
Key Responsibilities:
Develop and maintain ETL/ELT processes using Azure Databricks, PySpark, and SQL to support data extraction, transformation, and loading activities.
Perform data validation, reconciliation, and quality checks to ensure completeness and accuracy of data.
Build and support Power BI dashboards, reports, datasets, and visualizations to meet business and audit requirements.
Develop business applications using Microsoft Power Apps and automate business processes using Microsoft Power Automate.
Support data extraction and transformation activities from ERP systems and other business applications.
Write, test, and optimize SQL queries and PySpark code for data processing and analysis.
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 troubleshooting, debugging, and resolving issues related to data pipelines, reports, and automation solutions.
Collaborate with engagement teams and stakeholders to understand requirements and deliver analytics solutions.
Prepare engagement-related documentation and maintain workpapers with attention to detail and quality standards.
Maintain accurate and up-to-date project status and communicate progress to project leads.
Contribute to continuous improvement initiatives by identifying opportunities for automation and process optimization.
Stay updated on emerging technologies, including Azure AI and Generative AI capabilities, and actively participate in learning initiatives.
Roles & responsibilities
The Associate 2 - Data & Analytics will be part of the GDC Canada Audit practice, supporting the delivery of data engineering, analytics, reporting, and automation solutions within the Audit Data & Analytics domain. The role requires hands-on experience in data preparation, transformation, dashboard development, and process automation while working closely with audit engagement teams to deliver high-quality, data-driven insights. The individual will work extensively with audit and financial datasets such as General Ledger (GL), Trial Balance (TB), Journal Entries (JE) to support audit analytics, and reporting requirements. The Associate 2 will be responsible for:
Key Responsibilities:
Develop and maintain ETL/ELT processes using Azure Databricks, PySpark, and SQL to support data extraction, transformation, and loading activities.
Perform data validation, reconciliation, and quality checks to ensure completeness and accuracy of data.
Build and support Power BI dashboards, reports, datasets, and visualizations to meet business and audit requirements.
Develop business applications using Microsoft Power Apps and automate business processes using Microsoft Power Automate.
Support data extraction and transformation activities from ERP systems and other business applications.
Write, test, and optimize SQL queries and PySpark code for data processing and analysis.
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 troubleshooting, debugging, and resolving issues related to data pipelines, reports, and automation solutions.
Collaborate with engagement teams and stakeholders to understand requirements and deliver analytics solutions.
Prepare engagement-related documentation and maintain workpapers with attention to detail and quality standards.
Maintain accurate and up-to-date project status and communicate progress to project leads.
Contribute to continuous improvement initiatives by identifying opportunities for automation and process optimization.
Stay updated on emerging technologies, including Azure AI and Generative AI capabilities, and actively participate in learning initiatives.
Mandatory technical & functional skills:
Hands-on experience with Azure Databricks and PySpark for data transformation and processing.
Strong proficiency in SQL and relational database concepts.
Experience developing Power BI dashboards, reports, and visualizations.
Experience building applications using Microsoft Power Apps.
Experience creating workflow automations using Microsoft Power Automate.
Understanding of ETL/ELT concepts and data integration practices.
Basic understanding of Azure data services and cloud-based data solutions.
Strong analytical and problem-solving skills.
Good communication and stakeholder collaboration skills.
Ability to work independently and manage multiple deliverables within deadlines.
This role is for you if you have the below
Educational qualifications
B.E./B.Tech., MCA, or equivalent degree in Computer Science, Information Technology or a related field.
Work experience
3-5 years of relevant work experience
Haystack's AI agent can fill in and submit this application for you. How AI auto apply works
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- ON

FP&A Data Analyst Auto Apply
Onecom · Gurugram · On-site · Posted 5 Nov 2026 🇮🇳
SQLMicrosoft ExcelLooker+5TechnologySalary not listed - BH

Senior Data AnalystRecently posted Auto Apply
Blink Health · India · Hybrid · Posted 19 Nov 2026 🇮🇳
SQLTableauArticulate+3TechnologySalary not listed - WG
Associate Director | Analytics - Solutions | Banking and Financial ServicesRecently posted Auto Apply
WNS Global Services · Bangalore, KA · Hybrid · Posted 18 Nov 2026 🇮🇳
ETLKYCRegulatory Reporting+2FinanceSalary not listed - WG
REF113298U- Consumption data (Neilson, NIQ IQVIA)-Power BI, Advance Excel and Data Bricks, - Lead Associate-AnalyticsRecently posted Auto Apply
WNS Global Services · Gurgaon, HR · On-site · Posted 17 Nov 2026 🇮🇳
Microsoft ExcelSnowflakeProcess Improvement+2TechnologySalary not listed - NI
Principal Data Operations AnalystRecently posted Auto Apply
NielsenIQ · Gurgaon, HR · On-site · Posted 17 Nov 2026 🇮🇳
Stakeholder ManagementMicrosoft ExcelMicrosoft Office+2Operations & Project ManagementSalary not listed - B2
GCP Data Specialist - R01572732 Auto Apply
Brillio 2 · Bengaluru · Hybrid 🇮🇳
GCPSQLT-SQL+4Salary not listed - RS

Data AnalystRecently posted Auto Apply
Redwood Software · Hyderabad · Hybrid · Posted 17 Nov 2026 🇮🇳
SQLMicrosoft ExcelTableau+5TechnologySalary not listed - NI
Visualization AnalystRecently posted Auto Apply
NielsenIQ · Chennai, TN · On-site · Posted 16 Nov 2026 🇮🇳
Microsoft PowerPointGoogle WorkspaceFigmaOperations & Project ManagementSalary not listed - A2
Costing & Insights EngineerRecently posted Auto Apply
A2MAC1 · Chennai, Tamil Nadu · On-site · Posted 16 Nov 2026 🇮🇳
AssemblyCapacitorLean ManufacturingEngineeringSalary not listed - TI
Manager, Analytics, Fraud, UKRecently posted Auto Apply
Tide · Hyderabad · Hybrid · Posted 16 Nov 2026 🇮🇳
OnboardingSQLMicrosoft Excel+4Salary not listed - EU
Reporting Executive Auto Apply
Eurofins · Bengaluru, KA · On-site · Posted 13 Nov 2026 🇮🇳
TechnologySalary not listed - ON

Team Lead- Data and Analytics Auto Apply
Onecom · Gurugram · On-site · Posted 12 Nov 2026 🇮🇳
RecruitingStakeholder ManagementOnboarding+18Operations & Project ManagementSalary not listed