About this role
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