Internal Audit Lead Data Analyst
About the position We are seeking a meticulous and analytical Internal Auditor to lead data efforts and enhance data-enabled internal auditing. The role involves providing insights to the audit team, identifying risks, validating processes, and offering both practical and innovative solutions. The candidate should excel in data selection, querying, and validation, while understanding business processes to evaluate risks and ensure process accuracy and reliability. Additionally, the Internal Audit Lead Data Analyst will assist in developing staff technical skills and serve as a point of contact with business owners for data needs. As a part of our Internal Audit team, you'll experience a wide range of exposure to all business processes and levels of management. You'll develop a well-rounded and broad understanding of the company as a whole, the industry and our business processes thus allowing for personal growth and development. North Carolina Farm Bureau Mutual Insurance Co., Inc. is a stable company with solid roots in North Carolina. Responsibilities • Lead efforts to strengthen data-enabled internal auditing. • Assist with staff development of technical data skills. • Consciously contribute to strengthening the organization through creative, innovative and practical solutions to business needs. • Utilize basic query tools to extract and manipulate data. • Perform data selection, querying, and validation as part of the audit processes. • Analyze large datasets to innovate and develop data-driven insights that identify risks, unique insights, potential inefficiencies and areas for improvement. • Understand and document business processes. • Develop and execute data-driven audit procedures to evaluate the integrity and effectiveness of controls. • Collaborate with business process owners to understand key data requirements and sources. • Think critically about business processes to identify risks which could prevent goal achievement. • Utilize data techniques to highlight process variances, attributes, trends and anomalies. • Use data to support risk assessments and provide insight into areas requiring further investigation. • Prepare clear and concise audit findings and recommendations. • Communicate complex data insights and audit results to stakeholders in an understandable manner. • Develop dashboards and reports to aid in the continuous monitoring of key business processes. • Stay up-to-date with industry best practices and advances in data analysis tools. • Recommend improvements to data analytics methodologies and audit processes. • Support the development and implementation of new audit techniques and tools. • Build and sustain relationships with business units by listening to their needs, proposing effective solutions and communicating timely and efficiently. • Assist in special projects focused on compliance, fraud investigations, business continuity, general process consulting and more as directed. • Follow department policies and procedures and complete administrative tasks correctly and on time. Requirements • College degree. Preference given to applicants with extended education and/or training in Computer Science, Data Analytics, Business or a related field. • Five or more years of experience working within or consulting for an audit, risk or compliance function. Property and casualty insurance industry experience is a plus • Expertise in building and optimizing complex SQL queries. • Understanding of Relational Database Design and Data Warehousing methodologies. • Professional certification such as CIA, CISA, CPCU or similar. • Proficiency with Microsoft Office suite and tools such as Tableau, Visio, R, Power BI and/or other analysis and process mapping tools. • Strong attention to detail with excellent analytical and problem-solving abilities. • Passionate about understanding and solving problems. • Natural desire and ability to understand complex business processes and identify areas of risk. • Effective oral and written communication skills for audit activities, team work and presenting data-driven insights and project results clearly and concisely. • Understanding of internal control concepts and experience in applying them to evaluate business processes. • Ability to work independently and as part of a team, including with cross-functional partners. • Ability and desire to develop, document and lead others through testing and analysis plans. • Position is located in Raleigh, NC and applicant must live in North Carolina. • Hybrid work from home policy. • Ability to travel, including occasional overnight stays, within North Carolina. Travel is currently estimated at less than 2%. Nice-to-haves • Property and casualty insurance industry experience is a plus • Professional certification such as CIA, CISA, CPCU or similar. • Preference given to applicants with extended education and/or training in Computer Science, Data Analytics, Business or a related field. Apply tot his job