Logo of Huzzle

Audit Data Architecture Intern │ New York Summer 2024

image

KPMG US

Dec 13, 2023

Applications are closed

  • Internship
    Full-time
    Summer Internship
  • Accounting & Tax
    Banking & Finance
  • New York

Requirements

  • Must be enrolled in an accredited college or university and be pursuing a Bachelors or Masters degree in one of the fields described below:
  • Major in Finance or Accounting or equivalent program with a concentration/double major in Information Systems (IS); IS coursework with a focus on database management and/or Accounting/ERP systems is preferred; Accounting majors are encouraged to pursue the minimum educational requirements for CPA licensure in state of employment
  • Major in Information Systems with a concentration/double major in Finance or Accounting; IS coursework with a focus on database management knowledge focusing on Microsoft SQL Server technology and the MSBI suite, including writing SQL stored procedures and data modeling and with additional coursework in ERP systems, financial analysis, data analytics, business intelligence and/or visualization
  • Major in Computer Science or other IT-related degrees with coursework in ERP Systems, financial analysis, business intelligence, data science, data analytics/visualization/automation
  • Major in Statistics or Mathematics with a minor in IS or equivalent coursework in ERP systems, financial analysis, data analytics, business intelligence and/or visualization
  • Upon completion of this internship, candidates must have additional academic credits to complete before obtaining their degree and/or CPA eligibility requirements
  • Preferred GPA of 3.0 or above
  • Ability to navigate various computer applications and technologies, including MS Office, ERP systems and data analysis tools; aptitude to quickly learn KPMG Audit tools and applications used by our clients; understanding or knowledge of SQL, MSBI Suite, Alteryx, Python and/or Power BI is preferred

Responsibilities

  • Work as part of the audit engagement team to support the use of Data and Analytics (D&A) in the audit including data extraction and analysis; utilize a range of technologies and data analysis tools, such as Excel, Alteryx, SQL, Python and Power BI
  • Help the Audit Data Engineering Services team members to identify the scope of D&A capabilities used in the audit, review data driven reports and understand the insights gained in the audit and how the analysis is used to plan and execute the audit
  • Learn to prepare clear, well-structured and effective audit documentation for data processing procedures and data validation
  • Support the execution of a high-quality audit through the diligent performance of assigned tasks and professional client and engagement team interactions
  • Adhere to the Firms Values and Code of Conduct

KPMG LLP, the U.S. audit, tax & advisory firm, operates from 75+ offices and over 40,000 partners and professionals.

Accounting
Industry
10,001+
Employees
1987
Founded Year

Mission & Purpose

KPMG is one of the world’s leading professional services firms and the fastest growing Big Four accounting firm in the United States. With 75+ offices and more than 40,000 employees and partners throughout the US, we’re leading the industry in new and exciting ways. Our size and strength make us much more agile and responsive to changing trends.