Data Analyst III

Top 5 Skill sets

1. Power BI / Microsoft Power Platform

2. SQL

3. Project / Time Management

4. Alteryx

5 Problem solving / able to work independently

Nice to have skills or certifications:

1. Data Science certificate

2. Internal Audit / Aviation / F500 experience

3. Python

Preferred Hours of work: 9am-5pm

Work Location(s): remote or Willis Tower

Work Schedule: if the candidate prefers hybrid, our team typically goes into the office Tuesday-Thursday.

Interview Process:

Will it be via video or in person? Video

How many interviews do you anticipate? 1-2 or more. One interview

Rate Details based on job title work location: CHICAGO

Rate Card Min Max:

Role and Responsibilities:

The client is seeking a skilled and experienced Senior Data Analyst – Internal Audit to provide data-driven

support to project teams within the Internal Audit department. This position will primarily work with the Audit

Manager & Project Leads to ensure audit teams acquire structured and unstructured data related to the areas

of the assignment in scope. Develop testing algorithms that provide more efficient and extensive population

coverage and design data visualization dashboards to accompany published audit reports.

Key Responsibilities:

• Leads data analytics engagements, including requesting access to data, crafting test strategies,

detailing business results and procedures performed, and communicating results to audit and business

leadership

• Support the audit team to scout, document, and – where vital – acquire access to the associated data

landscape(s)

• Develop queries and test scripts sought at identifying transactional and operational patterns, instances

of non-compliance, and emerging risks

• Design and support digital dashboards that visualize audit results and findings

• Support the audit team in maintaining functionality and leading departmental access to analytics-

specific software and hardware, including Spotfire library & private SQL servers

• Assist with special projects, contracted services, and other agreed-upon procedures requested of the

Internal Audit department

• Develop and maintain productive client, staff, and management relationships through individual

contacts and group meetings

Qualifications:

• Bachelor's degree

• 3+ years of experience with analytics

• Experience using database querying tools and able to write queries and procedures using SQL Server,

SQLite, PostgreSQL

• Familiarity with cloud-based applications and accounting systems (e.g., Oracle)

• Knowledge of machine learning algorithms and concepts such as natural language processing, time-

series forecasting and clustering models and how they apply to Internal Audit processes

• Extensive experience with data analytics and visualization tools such as Power BI, Palantir Foundry,

Python (including pandas and Anaconda), and Power Query (MS power platform)

• Experience using Alteryx

• Demonstrated knowledge of data governance, data quality management concepts, and data quality

tools

• Ability to gather system and application requirements from multiple stakeholders and successfully

implement them into user friendly applications

• Reliable, punctual attendance is a crucial function of the position

2

Preferred Qualifications:

• Master’s Degree in a quantitative field like Math, Statistics, Computer Science and/or Data science,

Information Systems, Accounting

• CIA, CPA or CISA experiance

• Experience working with unstructured data

• Experience with process automation

• Direct experience in the transportation/aviation fields

• Knowledge of SAS or Python

• Experience in testing internal controls around financial, application and IT general controls (ITGCs)

• Knowledge of and skill in applying auditing principles and practices

EEO:

“Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.”