Full Job Description
JOB SUMMARY:
The IT Auditor - Data Analytics role at OnPoint Community Credit Union will play a key role in assessing the design and effectiveness of information technology controls across the credit union's systems, infrastructure, and applications, while also helping to expand Internal Audit's data analytics program. This position requires a strong understanding of IT governance, cybersecurity, and regulatory compliance relevant to financial institutions, as well as technical skills needed to access, organize, and analyze data in support of audit engagements. The IT Auditor - Data Analytics will be responsible for performing IT audits across the full audit lifecycle, assessing IT risks, testing controls, and recommending improvements to strengthen operational resilience and regulatory compliance. This individual will also leverage Databricks and other tools to obtain, prepare, validate, and provide data identified by engagement teams for audit use, and develop and advise on analytics procedures that support all of Internal Audit's engagements, including both IT and operational audits performed by the broader audit team.
ESSENTIAL FUNCTIONS:
3 Plan and execute risk-based audits, in accordance with the Global Internal Audit Standards, of the credit union's systems, infrastructure, networks, databases, applications, cybersecurity practices, data governance, and technology-related processes.
3 Identify and assess technology risks and evaluate the design and operating effectiveness of related controls against applicable laws, regulations, supervisory guidance, industry standards, internal policies, and control frameworks.
3 Prepare clear, supportable audit documentation and reports; communicate risks, observations, conclusions, and recommendations to management and other stakeholders; and support regulatory or supervisory requests as directed by audit leadership.
3 Monitor management action plans and perform validation testing to determine whether corrective actions have been implemented and address the identified risk.
3 Use Databricks and other approved tools to access, extract, prepare, validate, and securely provide data identified by the audit team for IT and operational audit engagements, including documenting relevant data sources, selection criteria, transformations, reconciliations, and known limitations.
3 Consult with auditors on how available data may be used to address audit objectives, including potential analytical procedures, testing techniques, data limitations, and interpretation considerations.
3 Assist the IT Audit Manager in developing and maintaining Internal Audit's data analytics capabilities, including procedures, documentation standards, reusable guidance, training, and appropriate use of emerging analytics and automation tools.
3 Participate in applicable data governance and knowledge-sharing activities, communicate relevant standards and developments to the audit team, and coordinate Internal Audit's data and access needs.
3 Perform other projects, duties, and responsibilities as assigned.
KNOWLEDGE, SKILLS & COMPETENCIES:
3 Knowledge of IT audit principles, risk assessment practices, control design, and operating effectiveness testing.
3 Knowledge of IT governance, cybersecurity, data governance, and applicable financial-industry requirements and frameworks, including GLBA, NCUA requirements, FFIEC guidance, PCI DSS, NIST CSF, and COBIT or ITIL.
3 Understanding of data sourcing, transformation, validation, documentation, access controls, and responsible use of AI-enabled analytics in an audit environment.
3 Proficiency using SQL for data extraction, transformation, validation, and analysis; experience with Databricks, Python, Power BI, or similar analytics tools.
3 Strong analytical and problem-solving skills, including the ability to evaluate complex data, identify risks and control gaps, and develop supportable conclusions.
3 Strong written and verbal communication skills, including audit documentation, report writing, and translating technical findings for non-technical audiences.
3 Sound judgment, attention to accuracy, confidentiality, data governance, and audit evidence standards.
3 Collaboration, initiative, adaptability, and organization in building sustainable analytics practices and managing concurrent priorities and deadlines.
MIN QUALIFICATIONS:
3 Bachelor's degree in information systems, computer science, data analytics, accounting, or a related field or equivalent experience in lieu of degree; relevant work experience may substitute for the degree requirement.
3 Minimum of 3 years' experience in IT auditing, data analytics, or a related technology, data, or risk role.
3 Intermediate SQL skills for data extraction, transformation, and validation.
PREFERRED QUALIFICATIONS:
3 Certified Information Systems Auditor (CISA), Certified Internal Auditor (CIA), Certified in Risk and Information Systems Control (CRISC), or similar certification.
3 Experience with Databricks, Python, Power BI, or similar analytics tools.
OnPoint employees are rewarded, acknowledged and appreciated! We take care of our Members, and OnPoint takes care of us by offering employees a generous vacation package, incentives, competitive hourly pay, 100% - paid employee medical, dental and vision premiums, Tri-Met / parking passes, 401k matching, tuition reimbursement and more!
