Audit BI Developer (Hybrid)

The Data Analytics Auditor plays a crucial role in modern auditing by leveraging data analytics techniques to enhance the quality and effectiveness of audits. Completing the job responsibilities listed in the job description will improve audit quality, help detect anomalies and patterns, enhance efficiency, and support the outcome derived from testing. The main responsibilities include helping auditors with data acquisition and sampling, automating data gathering and enhancing processes, assisting in analytics reporting, and audit software administration.

Data Acquisition and Sampling:

Develop and execute data analytics using data preparation, analysis, and visualization tools to support auditors.

Assist auditors in obtaining data and samples for audit engagements using Galvanize (ACL), Alteryx, or similar software.

Normalize data, map, and document databases from multiple systems to ensure consistency and accuracy.

Automated Data Gathering and Process Enhancement:

Assist in automating the data gathering process (population and sample sizes) using programming/scripts in Galvanize (ACL), Alteryx, or similar software.

Troubleshoot and resolve issues related to automated data gathering processes.

Contribute to the development of tools and automation to enhance the effectiveness and efficiency of the audit process.

Analytics and Reporting:

Create analytics/dashboards for performance reporting, fraud prevention and detection, continuous monitoring, and risk assessment, using Tableau or similar software.

Create data dashboards upon the Internal Audit Manager's request.

Identify and communicate opportunities and challenges obtained from data analytics.

Business Requests and Compliance:

Address business requests for analytics while maintaining compliance with the IIA Standards.

Consult with colleagues to understand operational processes and assist in making processes more effective through redesign/re-engineering.

Communicate technical requirements/solutions to non-technical individuals.

Audit software Administration:

Administer audit software, ensuring it is up to date with changes/enhancements.

Assist others in resolving issues related to the software.

Maintain users and act as the owner of all configuration changes.

Confidentiality and Timely Execution:

Handle confidential and sensitive data with utmost discretion.

Meet critical deadlines for data-related tasks.

Under the direction of the Internal Audit Manager:

Manage multiple audits/projects.

Assist in developing and enhancing audit programs, including audit procedures, templates, best practices, etc.

Provide input and collaboration in finalizing audit plan.

Maintain continued professional education (CPE) in technical area of expertise.

Maintain and develop technical area of expertise.

Maintain annual CPE requirements.

Education/Certification:

o Bachelor’s degree in computer science, data science, analytics, statistics, or related field

 Equivalent years of relevant experience will be considered.

o Certifications preferred, but not required:

 Certified Analytics Professional or equivalent
 Certified Internal Auditor (CIA)

Requirements/Knowledge:

o Proficient in Microsoft Office products
o Strong understanding of IIA Standards, preferred.
o Thorough knowledge of credit union products, services, policies, and procedures preferred.
o Demonstrates technical/business acumen, problem-solving, and computer skills.
• Travel may be required.

Experience:

o Two or more years of hands-on experience using Galvanize (ACL), Alteryx, or similar software.
o Two or more years of hands-on experience with:

 Data definition, collection, cleansing, analysis, and interpretation of results
 Quantitative modeling, statistics, or data mining
 SQL, Python, Microsoft BI, or other similar tool
 Tableau or other visualization software

o Credit union or financial institution experience a plus

Skills/Abilities:

o Highest level of personal and professional ethics
o Excellent verbal and written communication skills
o Self-starter, highly motivated, organized, and detail oriented.
o Works efficiently and within the time requirements established by the Internal Audit Manager.
o Possesses technical acumen.
o Demonstrates curiosity and the ability to analyze information.
o Demonstrates and supports a team environment.
o Supervisory experience, a plus
o Professional in appearance and attitude
o Ability to work well independently with limited daily supervision while meeting deadlines.
o Ability to navigate through ambiguity, manage and coordinate multiple project assignments simultaneously, accept ownership and accountability for projects, and deliver on commitments.