Senior Internal Audit Data Analyst

$110,000 - $115,000/Yr

PLIC Primerica Life Insurance Company - Duluth, GA

Full-time - Mid Level

Hybrid - Duluth, GA

1,001-5,000 employees

About the position

This position is responsible for conducting and assisting in internal audits by applying data analysis using widely accepted data mining tools. The role involves leading the department's data analysis objectives, collaborating with audit teams, and managing the SOX testing effort. It requires a combination of project management and interpersonal skills to work effectively across various functional areas. The position is hybrid, requiring both onsite and remote work.

Responsibilities

• Consult with audit teams to understand data needs based on engagement objectives.
• Assist with identifying where the necessary data resides by meeting with the business and independently researching tables.
• Brainstorm with audit teams to design potential analytics based on the available data.
• Assist with acquiring independent access to the data.
• Maintain logs of tables which Internal Audit can independently access.
• Coach audit staff to extract data from tables using available techniques such as SQL queries or other means.
• Support audit staff in their efforts to run analytics using the department Data Analytics software—currently ACL/ Galvanize.
• Lead periodic training sessions for the Department to promote frequent interaction with ACL, SQL, and data analytics in general.
• Continually accumulate personal knowledge of data analytic techniques and share with the audit staff through trainings and live projects.
• Maintain the Department's Data Dictionary and Analytics Summary (log of all analytics performed for all audits).
• Lead the Department in identifying ways to improve the data analytics function such as templates, scripts, organizational tips, etc.
• Make full use of the department's internal audit software.
• Adhere to agreed-upon deadlines for deliverables to audit teams.
• Serve as department administrator for Data Analytic software currently ACL/Galvanize and Audit Management software, currently Teammate.
• Participates in many aspects of assessments, internal audits and investigations, external auditors' assistance, SOX testing, and advisory services (projects).
• Participates in testing and evaluating risks and controls which may include report testing and other SOX automated control testing.
• Makes recommendations to improve internal controls and operations as needed.
• Prepares clear and concise internal documentation that adhere to best practices.
• Prepares or contributes to the preparation of audit reports in a timely manner.

Requirements

• BA/BS in CIS, MIS, Accounting or equivalent.
• Experience performing data analysis (preferably in an audit context) via use of tools such as ACL, IDEA, and TeamMate Analytics.
• Experience writing queries in SQL.
• Prior work experience in a project-based environment.
• Minimum 5 years' experience in internal or external audit.

Nice-to-haves

• CIA, CPA, CISA, or similar designation.
• Graduate degree.
• Experience auditing in the insurance and/or securities industry.

Benefits

• Day one health, dental, and vision insurance
• 401(k) Plan with competitive employer match
• Vacation, sick, holiday and volunteer time off
• Life and disability insurance
• Flexible Spending Account & Health Savings Account
• Professional development
• Tuition reimbursement
• Company-sponsored social and philanthropy events