Audit Data Analyst

Blue Cross Blue Shield of Michigan • Detroit, MI

3d • Hybrid

About The Position

Responsible for assisting in the continuous improvement and maturity of the data analytics program within BCBSM Internal Audit and assisting with other day-to-day operational responsibilities of the Audit data analytics team. Performs analytics to identify issues, risks, and trends to assist from audit planning through execution, including data mining, profiling, script creation, and dashboard creation. Provide support to Internal Audit teams by creating automated testing and conducting continuous monitoring through the use of CAATs and other analytic tools. Perform data querying, manipulation, data set testing, and create scripts or data visualizations on large data sets using the various tools. Lead analytics projects and teams to identify key risk and performance metrics utilizing testing scripts and data visualizations. Assist in the enhancement of the Internal Audit’s data analytics program’s maturity and strategic direction to support audit operations. Assist in obtaining and gaining an understanding of key source system data and requests from Audit leadership. Conduct and lead analytics training for General Audit and Corporate Compliance team members.

Requirements

• Bachelor's Degree in Accounting, Computer Science, Data Science or related field required.
• Two (2) -Four (4) years of internal audit, public accounting/audit, data analytics or related field required.
• Strong written and verbal communication skills.
• Strong attention to detail, analytical, and problem-solving skills.
• Excellent skills in Microsoft Office applications and systems (i.e. Excel, Word, PowerPoint, Access, and SharePoint).
• Ability to work independently and work in a team environment on projects with concurrent deadlines.
• Familiarity with Data Warehouse and Data Mart concepts.
• Knowledge of Python, R, Cognos, SQL, or SAS.
• Must be able to travel to various BCBSM and subsidiary locations around the State, BCBSA (Chicago), other Blues Plans and vendor sites.

Nice To Haves

• Experience with Tableau or similar Business Intelligence Tool preferred.
• Specialty certification in data analytics tool preferred.
• CIA, CPA, or CISA certification preferred.

Responsibilities

• Assisting in the continuous improvement and maturity of the data analytics program within BCBSM Internal Audit.
• Assisting with other day-to-day operational responsibilities of the Audit data analytics team.
• Performing analytics to identify issues, risks, and trends to assist from audit planning through execution, including data mining, profiling, script creation, and dashboard creation.
• Providing support to Internal Audit teams by creating automated testing and conducting continuous monitoring through the use of CAATs and other analytic tools.
• Performing data querying, manipulation, data set testing, and creating scripts or data visualizations on large data sets using the various tools.
• Leading analytics projects and teams to identify key risk and performance metrics utilizing testing scripts and data visualizations.
• Assisting in the enhancement of the Internal Audit’s data analytics program’s maturity and strategic direction to support audit operations.
• Assisting in obtaining and gaining an understanding of key source system data and requests from Audit leadership.
• Conducting and leading analytics training for General Audit and Corporate Compliance team members.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level