Requisition Number -18-0124 -Post Date -1/3/2019 -Title -Reports Desk Intern - Summer -Division -Office of Economic and Risk Analysis -PT/FT -Full Time -City -Washington -State -DC -Description -Our Mission The PCAOB oversees the audits of public companies and SEC-registered brokers and dealers in order to protect investors and further the public interest in the preparation of informative, accurate, and independent audit reports. Job Description Summary The PCAOB is seeking highly motivated students for paid, full and part-time positions throughout the year. Successful candidates will provide support to the PCAOBs Office of Economic and Risk Analysis (ERA) in the Washington, DC headquarters. ERA identifies and analyzes emerging audit and accounting issues that may present elevated risk of audit failure, and communicates these risks to the PCAOBs other divisions. As an Intern you will have the opportunity to gain a broad overview of trends and developments affecting audit firms and their audit clients and experience professional life before youve left school. You will also learn about, and use, analytical tools and methods and gain experience that will make you more marketable to prospective employers. Responsibilities -To assist the Reports Desk prepare and format reports, and create graphs, charts and other visual displays of data. -Create and test Excel macros. -Write queries to extract and validate data. -Assist on a project to collect data on Securities and Exchange Commission filings using Python. -Requirements -Qualifications -Current academic enrollment at the undergraduate (Junior or above) or graduate level with an Accounting, Finance, Computer Science, Information Technology, Statistics or related major -Understanding of relational databases -Working knowledge of creating dashboards/charts, or VBA programming and macro development within MS Excel -Exposure to Python or R data science libraries -Familiarity with writing Structured Query Language (SQL) statements is a plus, but not required -Exposure to SAS or SharePoint is a plus, but not required -Good oral and written communication skills -Ability to stay organized and meet deadlines -Willingness to work as a team member -Ability to be flexible, work independently and be self-motivated Our Values As we seek to accomplish our mission and implement our vision, we expect integrity, pursue excellence, operate with effectiveness, embrace collaboration, and demand accountability. Equal Employment Opportunity All PCAOB employees are entitled to equal opportunity and a professional work environment, free of discrimination and harassment. A workplace free of discrimination is fundamental to professional success and to the PCAOB's mission. The PCAOB will consider for employment all qualified applicants with criminal histories in a manner consistent with applicable law.