Audit Data Analyst

Blue Cross Blue Shield of Michigan; Detroit (MI); On-site; USD 65,000 - 95,000; Full time

Job summary

Blue Cross Blue Shield of Michigan is seeking a data analytics professional to support the Internal Audit data analytics program and assist with daily operations. You will perform analytics to identify issues, risks, and trends from audit planning through execution, including data mining, profiling, scripting, and dashboard creation.

You will provide support to Internal Audit teams by creating automated tests, conducting continuous monitoring with CAATs, and leading analytics projects to drive

Qualifications

• Bachelor's degree in Accounting, Computer Science, Data Science or related field.
• Two to four years of internal audit, data analytics or related field.
• Experience with Tableau or similar BI tool preferred.
• Specialty certification in data analytics tool preferred.
• CIA, CPA, or CISA certification preferred.

Responsibilities

• Assist in improving the data analytics program maturity and support audit operations.
• Perform analytics to identify issues, risks, and trends from 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 CAATs and other analytic tools.
• Lead analytics projects and teams to identify key risk and performance metrics utilizing testing scripts and data visualizations.
• Travel to various BCBSM and subsidiary locations around the State, BCBSA (Chicago), other Blues Plans and vendor sites.

Skills

Communication skills

Analytical thinking

Problem solving

Attention to detail

Teamwork

Independent work

SQL

Python

R

SAS

Cognos

Data warehousing

Education

Bachelor's degree

Tools

Tableau

Excel

PowerPoint

Word

Access

SharePoint

Job 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.

Job Info

• Job Identification 14505
• Job Category Audit/Corporate Compliance
• Legal Employer Blue Cross Blue Shield of Michigan Mutual Insurance Company