AUDIT SERVICES SKILLS, EXPERIENCE, AND JOB REQUIREMENTS
Updated: Aug 10, 2024 - The Audit Services offer expertise in leveraging business intelligence tools and advanced analytics for reporting in complex environments, with proficiency in data visualization tools like Tableau and PowerBI. They design and implement robust dashboard solutions, utilizing data from multiple platforms including SAP and Hyperion, and are skilled in predictive modeling and process automation. The team holds certifications in key analytics tools, contributes to project management, and has experience with prominent consulting firms, ensuring comprehensive technological integration in operations.
Summary of Audit Services Knowledge and Qualifications on Resume
1. BS in Accounting with 5 years of Experience
- Experience with ETL (Knime), Python
- Experience writing efficient Structured Query Language (SQL) using various SQL development software packages including Greenplum and Oracle PL/SQL.
- Ability to use custom SQL or Hive/Hadoop for complex data pulls
- Extensive experience in Database querying, writing procedures, complex joins and indexes
- Ability and comfort level independently researching inquiries and emerging issues, including regulations, industry practices, and new technologies
- Experience mapping out the conceptual designed for planned database, considering both the backend organization of data and frontend accessibility for end users
- Ability to manage and work with external consultants
- Good organization skills to manage multiple tasks/projects simultaneously
- Good communication skills (verbal, written, and presentation)
- Professional certifications (e.g., Microsoft Certified Business Intelligence, CPA CA, CIA, CFE, CPIM, CISA)
2. BA in Business Administration with 3 years of Experience
- Sound-related experience in areas such as compliance auditing, monitoring and investigating financial information, income testing, subsidy or taxation review.
- Equivalent combination of education, training and experience acceptable to the Employer.
- Sound knowledge of auditing standards and procedures required in a public sector financial, administrative and systems environment.
- Sound knowledge and understanding of the legislation, policies and programs of BC Housing is preferred, particularly those affecting tenants and housing providers.
- Sound knowledge of income tax rules, income tax returns and supporting tax schedules to audit tenant income and asset declarations.
- Sound knowledge in accessing and comprehension of several government agency information databases such as BC Online and TransUnion.
- Ability to perform income verification procedures on tenants and report on findings.
- Ability to effectively communicate with tenants in a social housing environment.
- Ability to review basic financial statements and perform reconciliation of financial records, complete income verification audits and report on findings.
- Ability to coordinate work with others, adapt to changing priorities and complete projects in accordance with tight timelines.
- Ability to use sound judgment and identify improvements in policies and procedures.
3. BS in Information Systems with 2 years of Experience
- Experience using business intelligence tools and databases, applying advanced analytics and data reporting techniques in a large complex environment
- Strong written and verbal communication, presentation, and technical writing skills, coupled with a strong interest in further developing and integrating operations with technology skills
- Experience using Data Visualizations tools (Tableau or PowerBI preferred) (including desktop and server deployment), or similar front-end data solutions (e.g., IBM Cognos, Business Objects, MS Excel, MS Access)
- Ability to design and implement canned / AdHoc reports and complex dashboard solutions
- Experienced with data acquisition and manipulation, modeling, and analyzing data from core financial platforms (SAP, Hyperion, Enterprise Data Warehouse) and various mainframe systems
- Data analytics tools certifications (e.g., PowerBI, Python)
- Experience with predictive modeling and natural language processing
- Experience developing robotic process automation solutions
- Working knowledge of SAP (FI/CO/MM/SD modules)
- Experience with a recognized consulting firm
- Project management, internal audit and/or business
4. BA in Economics with 4 years of Experience
- Ability to work independently and as an effective team member.
- Ability to maintain confidentiality of information and exercise discretion and independent judgment.
- Ability to work with personnel of varying skill levels and backgrounds within and outside the organization.
- Ability to multi-task with efficiently.
- Ability to travel throughout the province to conduct audits and special reviews
- Good analytical, problem-solving, organizational and time-management skills.
- Excellent verbal and written communication skills, relationship management, public speaking and presentation skills.
- Good interpersonal skills, ability to deal with clients using diplomacy and tact.
- Proficient in the use of computers and MS Office, and ability to adapt quickly to in-house applications.
- High proficiency in Microsoft Office tools and general systems aptitude.
5. BA in Internal Auditing with 3 years of Experience
- Professional designation/certification (CPA, CIA or CISA)
- Experience in public accounting, internal auditing, external auditing and/or internal controls experience managing audit teams and projects.
- Comprehensive knowledge of auditing practices, procedures and principles, sufficient to interpret and analyze complex concepts and apply these in innovative ways.
- Strong interpersonal and communication skills and executive presence with proven ability to work with all levels of management.
- Strong written communication skills needed for effective reporting and developing guidance documents to be utilized by others at all levels of the organization.
- Exceptional analytical thinker with strong conceptual and problem-solving skills, sound independent judgment as well as meticulous attention to detail.
- Demonstrated business acumen and the ability to provide value-added advice and guidance to the business.
- Experience and capability in developing and using data analytics to enhance the audit process.
- Proven ability to build, coach and mentor a high-performing audit team.
- Experience operating within a multi-site, highly regulated industry.