Sr Data Analyst Internal Audit

• If you live within 50 miles of the Aflac offices located in Columbus, GA or Columbia, SC, this role will be hybrid. This means you will be expected to work in the office for at least 60% of the work week. You will work from your home (within the continental US) for the remaining portion of the work week. Details of this schedule will be discussed with your leadership.
• If you live more than 50 miles from the Aflac offices located in Columbus, GA or Columbia, SC, this role will be remote. This means you will be expected to work from your home, within the continental US. If the role is remote, there may be occasions that you are requested to come to the office based on business need. Any requests to come to the office would be communicated with you in advance.

• Acting with Integrity
• Communicating Effectively
• Pursuing Self-Development
• Serving Customers
• Supporting Change
• Supporting Organizational Goals
• Working with Diverse Populations

• Knowledge of SQL Server is required
• Ability to design and develop analytics within various technical tools to deliver meaningful insights to support audits
• Knowledge of the operations of the business and the insurance industry
• Knowledge and understanding of internal audit standards and guidance
• Knowledge and understanding of financial and business process controls
• Ability to use analysis skills to investigate and fully understand the root causes of problems and find solutions
• Strong collaboration and organizational skills
• Excellent presentation, oral, written, and interpersonal communication skills to effectively interact with management and internal and external business contacts
• Ability to create dashboards and prepare audit documentation
• Excellent attention to detail to ensure accuracy of data
• Ability to communicate and present to diverse audiences, including executive management, via dashboards and Microsoft PowerPoint
• Basic knowledge and skill in Visio or similar software required
• Knowledge of SAP and Lean Six Sigma preferred
• Intermediate knowledge and skill in Microsoft Access, Word, Advanced Analysis Tools, Statistical Analysis Tools, and Statistical Analysis required
• Advanced knowledge and skill in Microsoft Excel, PowerPoint, Business Intelligence Reporting Tools, Business Case Preparation, Business Cost/Benefit Analysis, Data Trend Analysis and Interpretation, Financial/Budget Analysis and Business Performance Analysis and Forecasting

• Bachelor’s Degree in business administration, finance, accounting, information technology or a related field
• Four years of progressively responsible work-related experience that demonstrates successful analytics work

• Experience with Tableau, R and Python software

• Less than or equal to 25%

• Collaborates with business partners and audit team members to gather requirements in support of analytics and dashboard creation, prepares supporting audit documentation, and assists with business rules development
• Provides audit technical support; coordinates and communicates with business partners providing guidance regarding audit projects, software development and/or support requests; provides technical advice in the definition, development, implementation and review of existing and proposed projects or applications for audit teams, leading research and documentation of business requirements; assists in the review of existing and proposed applications for audit systems and databases
• Develops and maintains databases, to include documenting standards for use, control, updating and maintenance of databases within internal business areas
• Assists with defining processes to incorporate data and analytics into Internal Audit methodology, including continuous risk assessment, periodic sampling and data-driven root cause analysis; assists with the establishment of standard analytics definitions and documentation standards that are supported by clear data definitions and clear traceability to data sources; performs formal quality reviews of data based on established guidelines
• Works closely with management to prioritize business and information needs and serves as a business-focused, value-added partner for the Internal Auditors and the Internal Audit function
• Builds reusable analytics tools, templates and request forms; creates documentation for data governance and data sources such as data dictionaries; ensures data quality and validity checks
• Remains abreast of the latest software to build tools, reports and conduct analysis most efficiently
• Travel required approximately 20% of the time
• Performs other duties as required

Aflac