Audit Data Analyst
Blue Cross Blue Shield of Michigan · Detroit, Michigan, United States
Insurance · 5,001-10,000 employees
About the role
The Audit Data Analyst will assist in the continuous improvement of the data analytics program by performing data mining, profiling, and creating automated testing scripts. They will also lead analytics projects to identify risk and performance metrics while providing training to internal audit and compliance teams.
What they look for
Requirements
Candidates must hold a Bachelor's degree in Accounting, Computer Science, or Data Science with two to four years of relevant experience. Proficiency in data analytics tools, BI software like Tableau, and programming languages such as SQL or Python is required.
Full description
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.
QUALIFICATIONS
- 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.
- Experience with Tableau or similar Business Intelligence Tool preferred.
- Specialty certification in data analytics tool preferred.
- CIA, CPA, or CISA certification preferred.
- 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.