Metra Looking for Sr Data Analytics Auditor at Chicago, IL  Full Time

Metra is one of the largest and most complex commuter rail systems in North America, serving Cook, DuPage, Will, Lake, Kane, and McHenry Counties. The agency is linking communities in Northeastern Illinois by providing safe, reliable, and efficient commuter service.

The Audit Department reports to the Chief Audit Officer, who reports directly to Metra’s Board of Directors and the CEO. The department is focused on operational, financial and compliance audits and the continuous review of money-handling at the highest levels of the agency. The department is committed to ensuring absolute transparency and proper conduct by all Metra employees.

Reporting to the Chief Audit Officer, the Sr Data Analytics Auditor will assist Metra Internal Audit in accomplishing its objectives by bringing a systematic and disciplined approach to evaluate and improve the effectiveness of Metra’s governance, risk management and internal control environment by providing data and automation support to perform independent evaluations of the adequacy and effectiveness of Metra’s production, finance, operations, compliance and technology functions; lead and provide data and automation support for a variety of complex audits; and execute the analytics road map for Internal Audit, which includes improving department efficiency and leverage analytic tools.

The Primary Duties include: Conduct all technology related assurance services and assist in other individual audits and related activities in accordance with auditing standards to support the completion of Internal Audit’s Annual Internal Audit Plan. Coordinate with the Internal Audit team and key stakeholders across the company to perform exploratory analysis of critical business areas. Develop repeatable data analytics to support risk assessments, audit testing, and control activities. Develop and maintain relationships with various control owners and other constituents throughout the organization. Interact with management and business partners to identify appropriate data sources and data elements required for analytics, apply professional skepticism to assessments of data sources, and validate completeness and accuracy of data. Utilize Power BI, Python and SQL to cleanse, transform and analyze large volumes of data to support the development, implementation, and execution of analytics solutions. Develops new Power BI and other dashboard solutions and maintain existing solutions to support data extraction and analysis (for end users). Interpret results of data obtained, generate visualizations and reports to support audit procedures and resultant recommendations (e.g., forecasting errors observed, performing root cause analysis, determining adequacy and effectiveness of internal controls). Coordinate team’s day-to-day activities, assign tasks/projects and monitor performance, and provide guidance and training, but is not a supervisor. Perform other related duties as assigned to meet the ongoing needs of the organization.

Final salary will be determined in part by the qualifications of the selected candidate.

Metra is a railroad employer subject to the provisions of the Railroad Retirement Tax Act, not the Social Security Administration.

1. Bachelor’s degree in Data Analytics, Information Systems, Computer Science or a related field.
2. In addition to #1, must have at least five (5) years of experience in internal, financial, or operational audit analytics development, deployment, and investigations.
3. Experience conducting financial, inventory, or operational audits is beneficial.
4. Working knowledge of the audit functions, methodologies, and procedures, including internal controls, risk management, and auditing standards.
5. Working knowledge of data science, predictive analytics, and artificial intelligence or machine learning concepts.
6. Working knowledge of open source data analysis and manipulation tool such as pandas and numpy and their use in performing data analysis with large, complex and messy datasets.
7. Working knowledge of RPA technologies and how to implement them for Internal Auditing purposes.
8. Proficient with Python, Microsoft SQL Server, SQLite, or other enterprise relational database systems; and data analysis, visualization, and presentations with skills in extraction, transformation, analysis, and visualization of data from a wide variety of data sources using various analytics tools, computer programming languages and automation software (e.g., Power BI, Python, SQL). Experience working with modeling tools, including Power BI, Jupyter Notebook/Lab.
9. Proficient in Microsoft 365 (Word, Excel, and Power Point) or audit software programs to access data, perform data manipulations and analytics, and develop project worksheets and reports.
10. Excellent written and verbal communication, critical thinking, analytical and presentation skills.
11. Excellent interpersonal skills necessary to interact with all levels of management, employees, external consultants, and organizations.
12. Excellent statistical, financial, and mathematical analysis skills with the ability to interpret facts and figures.
13. Excellent critical thinking and problem-solving skills.
14. Excellent organizational and time management skills.
15. Ability to work on multiple projects, is self-motivated, takes initiative, and able to function independently as required. Has a passion for learning and can work effectively in a nimble environment.
16. Ability to effectively collaborate with cross functional teams across all levels of the IA team.
17. Ability to understand complex and diverse technology infrastructure as it relates to data flows and business processes.
18. Ability to develop python scripts for data analysis.
19. Ability to develop complex Power BI dashboards for Internal Audit users and other end-users outside of Internal Audit
20. Ability to stand, walk, and/or sit, for extended periods of time.
21. Must be able to operate a vehicle.
22. Must be willing to travel within and outside of Metra’s 6-county region.
23. Must be available to work flexible hours in the early morning, late afternoon, evenings, or weekends.

Preferred:

1. A Master’s Degree
2. Commuter rail or transportation experience
3. Supervisory or team lead experience
4. Certified Internal Auditor (CIA), Certified Fraud Examiner (CFE), or Certified Information Systems Auditor (CISA) certifications
5. Certified Public Accountant (CPA) license

Please note: Regardless of any state laws that legalize marijuana, Metra prohibits applicants and employees’ use or possession of marijuana (or marijuana paraphernalia), or having detectable amounts of marijuana in their bodies, including synthetic and/or non-synthetic substances such as THC for any reason for pre-employment screening purposes, while on duty, subject to duty, on Metra property, or in Metra work equipment and vehicles.

Metra is an Equal Opportunity/Affirmative Action Employer. It is our policy to fill vacant positions with qualified candidates without regard to race, color, sex, religion, national origin, age, gender identity, disability, or any protected categories, assuming an individual can perform the essential functions of the job with or without accommodation.