Data analytics skills required for accounting industry jobs: analysis and strategies

Purpose of the research. There’s a lack of specific advice / tactics for those interested in switching from public practice to industry. Purpose of the research is to fill the current gap and provide specific tactics for aspiring professionals both in terms of understanding the skills required to make a transition, as well as the ways to develop those skills.

Methodology. This study employed a qualitative research approach to explore the data analytics skills required for audit and corporate accounting jobs. The study adopted a case study design to examine the specific data analytics skills required for audit and corporate accounting roles.

Originality / value of the research. By combining the researcher's personal experience, industry insights, and academic literature, this study provides valuable insights into the data analytics skills required for audit and corporate accounting roles. The study's findings and recommendations offer practical guidance for auditors transitioning to corporate accounting positions and for corporate accountants seeking career advancement.

Findings. This article delved deeply into the data analytics skills required in corporate reporting, but absent in audit due to job differences. The article provides an overview the current software market and provide practical tips on learning and practicing new tools that could (1) provide required skills for a successful industry shift and (2) cementing and upscaling your role in reporting department.

1. Bragg, S. (December 4, 2019). The Transition from Auditing to Industry (#112). Accounting tools. Retrieved March 23, 2023, from https://www.accountingtools.com/podcast-blog/112.

2. Transferable skills: practice to industry. (May 18, 2020). ACCA Careers. Retrieved March 23, 2023, from https://jobs.accaglobal.com/article/transferable-skills-beyond-practice/.

3. Sood, S. (April 27, 2022). Auditing, a serious job: Top challenges faced by auditors while auditing. Times of India. Retrieved March 23, 2023, from https://timesofindia.indiatimes.com/blogs/voices/auditing-aserious-job-top-challenges-faced-by-auditors-while-auditing/.

4. Analytics in Finance and Accountancy. (September, 2020). ACCA Professional Insights. Retrieved March 23, 2023, from https://www.accaglobal.com/content/dam/ACCA_Global/professional-insights/aifaa/CliveWebb.PI-ANALYTICS-FINANCE-ACCOUNTANCY.pdf.

5. Lacity, M. C. and Willcocks, L. (June 19, 2015). What Knowledge Workers Stand to Gain from Automation. Harvard Business Review. Retrieved March 23, 2023, from https://hbr.org/2015/06/whatknowledge-workers-stand-to-gain-from-automation.

6. ACCA Professional Insights. (June, 2019). Audit and Technology: Report. 20 p.

7. Cochran, J. J. (2019). INFORMS Analytics Body of Knowledge. Hoboken, NJ: John Wiley and Sons, Inc., 400 p.

8. Dzuranin, A. (2021). Statement on Management Accounting. Institute of Management Accountants, 41 p.

9. Webb, C. (June 30, 2020). Finance Insights – Reimagined. ACCA Professional Insights. Retrieved March 23, 2023, from https://www.accaglobal.com/gb/en/professional-insights/pro-accountants-the-future/FinanceInsights-reimagined.html.

10. Webb, C. and Schu, P. (June 26, 2019). Finance's journey to the future. ACCA Professional Insights. Retrieved March 23, 2023, from https://www.accaglobal.com/gb/en/professional-insights/pro-accountantsthe-future/finance-journey.html.

11. Holsapple, C., Lee-Post, A. and Pakath, R. (2014). A unified foundation for business analytics. Decision Support Systems, 64, 130-141.

12. Data analytics – An information resource for IFAC members. (November 9, 2018). International Federation of Accountants (IFAC). Retrieved March 23, 2023, from https://www.ifac.org/knowledge-gateway/preparing-future-ready-professionals/publications/data-analytics-information-resource-ifac-members.

13. D’Amore, J. and Mitchell, S. (July 28, 2020). Electronic Health Record Data Governance and Data Quality in the Real World. Healthcare Information and Management Systems Society. Retrieved March 23, 2023, from https://www.himss.org/resources/electronic-health-record-data-governance-and-data-quality-realworld.

14. D'Amore, J. D., Li, C., McCrary, L., Niloff, J. M., Sittig, D. F., McCoy, A. B. and Wright, A. (2018). Using Clinical Data Standards to Measure Quality: A New Approach. Applied clinical informatics, 9(2), 422-431.

15. D'Amore, J., Bouhaddou, O., Mitchell, S., Li, C., Leftwich, R., Turner, T., Rahn, M., Donahue, M. and Nebeker, J. (2018). Interoperability Progress and Remaining Data Quality Barriers of Certified Health Information Technologies. in American Medical Informatics Association (AMIA) Annual Symposium proceedings. San Francisco, 358-367.

16. Bureau of Labor Statistics. Occupational Outlook Handbook. (2023). Bernan Press. 1294 p.

17. Catch them if you can: How leaders in data and analytics have pulled ahead. (September 19, 2019). McKinsey. Retrieved March 23, 2023, from https://www.mckinsey.com/capabilities/quantumblack/ourinsights/catch-them-if-you-can-how-leaders-in-data-and-analytics-have-pulled-ahead.

18. Bersin, J. and Zao-Sanders, M. (February 12, 2020). Boost Your Team’s Data Literacy. Harvard Business Review. Retrieved March 23, 2023, from https://hbr.org/2020/02/boost-your-teams-data-literacy.

19. Excel Power Tools for Data Analysis. (2021). Coursera. MacQuarie University. Retrieved September 24, 2023, from https://www.coursera.org/learn/excel-power-tools.

20. Microsoft Certified: Power BI Data Analyst Associate. (August, 2023). Microsoft. Retrieved September 24, 2023, from https://learn.microsoft.com/en-us/credentials/certifications/power-bi-data-analyst-associate/.

21. Database and Programming tutorials. (2023). Holowczak.com. Retrieved September 24, 2023, from https://holowczak.com/.

22. Access 2013 No VBA Index. (2013). Access All in One. Retrieved September 24, 2023, from https://www.accessallinone.com/access-2013-no-vba-index/.

23. Rice University Online Learning. (2023). Official website of the Rice University. Retrieved September 24, 2023, from https://online.rice.edu/courses/business-statistics-and-analysis-specialization.

24. Certified Analytics Professional. (2023). Certified Analytics Professional. INFORMS. Retrieved September 24, 2023, from https://www.certifiedanalytics.org/.

25. Duggal, N. (January 27, 2023). Future Of Work: What Job Roles Will Look Like In 10 Years. Simplilearn Solutions. Retrieved March 31, 2023, from https://www.simplilearn.com/future-of-work-article.

26. Schwab, K. (2016). The Fourth Industrial Revolution. World Economic Forum, Geneva, 192 p.