Director - Americas Audit & Audit Data Analytics

Company: Magna International Inc.
Location: Troy
Posted on: February 16, 2020

Job Description:

Director - Americas Audit and Audit Data Analytics
The Americas Audit Director is responsible for the provision of independent assurance of Magna's Americas operations to the Vice President Internal Audit in relation to the appropriateness, effectiveness and compliance with policies, processes and internal control frameworks surrounding financial statements and related controls, business risk management, legal compliance and ethics/integrity. This role includes building a team of audit data & analytics professionals, defining the vision, strategy and roadmap for global audit data and analytics within the Internal Audit function for improving internal audit efficiency, continuous improvement to problems, and delivering value and tools to the business. This new position will lead a team of 10-15 people located in Canada, US, and Mexico that includes internal auditors and data and analytics professionals.

Responsibilities:

The Americas Audit Director will be responsible for realigning the Americas Internal Audit function with a layout between the corporate office in Aurora, Canada and the US headquarters in Troy, MI. This person will also be responsible for building and leading a global audit data analytics team in Troy, MI that services Magna globally. The leader will be responsible for building relationships with key leaders of Magna divisions and groups to be able to conduct audits effectively and develop a means to extract, transform, load, model, and analyze data from divisional systems. This role will have a high level of exposure to both C-level management and the Audit Committee through the Vice President Internal Audit and requires a high level of executive presence and presentation.

• Program leadership that is responsive to existing and emerging risks
• Leading annual risk assessment and audit plan development while building capability for a future data driven process within each of these
• Collaborate with leadership in Legal and Compliance to partner on risk assessment and compliance audit programs for the mitigation of key fraud risks across the company
• Partner with key stakeholders who have data responsibilities to develop, implement and manage data strategies that optimize data quality and improve standardization and business value
• Develop a global data lab focused on the identification of unusual activities utilizing predictive analytics
• Develop continuous auditing analytics to identify transactions involving asset misappropriation, fraud, misstatement of financial statements or falsification of company records
• Evaluation and implementation of data audit and visual analytics techniques, methods, and tools, including but not limited to: Tableau, PowerBI, SQL, ACL, Excel, Access, SAS, etc.
  
  Requirements/Skills:
  
  The Americas Audit Director will possess a combination of business knowledge, technical skills, people skills, and the expertise for guiding a new data strategy, complimented by strong finance analytical capabilities. This person will have the ability to manage the extraction, modeling, and front end solutioning of information from various databases that contain data in various and unstructured formats using complex query statements and advanced database tools.
  
  
  • Understands problem types, and inherent limitations of various solutions techniques
  • Able to clearly explain the approach, limitations, assumptions, and risks of analytic modeling to other practitioners who may not be familiar with the topic
    
    The person filling this role will be able to demonstrate:
    
    
    • Ability to face high levels of adversity during interviews at all levels of the company
    • Influential partnering with Chief Compliance Officer for establishing new policies around emerging regulations and laws
    • Able to apply technical skillset in forensics and data analytics to move initiatives with strategic direction/insight, yet maintain big picture perspective
    • Develop relationships with Division and Group stakeholder's for gaining access to required data and timely disposition of issues
    • Assess appropriateness, effectiveness and compliance with policies, processes and internal control frameworks surrounding financial integrity, business risk management, legal compliance and ethics/integrity
    • Reporting results and recommending improvements in policies, procedures and internal controls that focus on anti-fraud and anti-bribery/anti-corruption (ABAC) activities
    • Achieve high acceptance and implementation of audit recommendations by management
    • Proficiency in current internal audit practice and extensive experience in conducting internal audits
    • Understanding of the process for developing and incorporating audit coverage of key risks, business processes and assurance activities
    • Communicates effectively (both oral and written) with internal and external customers to achieve effective outcomes
    • Ability to analyze information to identify issues and / or potential problems and taking appropriate action
    • Making timely recommendations, based on available information.
      
      Required Job Qualifications:
      
      • Bachelor's Degree required, in the areas of Accounting, Finance, or data analysis related fields
      • CPA or CIA required
      • 10+ years of related work experience with a proven high-level performance in the areas of external/internal audit, internal controls, finance and accounting
      • 5+ years of experience applying advanced analytics and data reporting techniques in a large/complex environment
      • 5+ years demonstrated ability to effectively lead a team and interact with subject matter experts and all levels of management
      • 3-5+ years of experience in finance/accounting environment analyzing complex data to identify anomalies and provide useable information to internal and external customers
      • Experience using business intelligence tools and databases applying advanced analytics and data reporting techniques
      • Experience with ETL (Alteryx), SAS, SPSS, R, and Tableau Software, Business Intelligence suite, or similar front-end data solutions (e.g. IBM Cognos, Business Objects), including ability to design and implement canned/Ad-hoc reports and complex dashboard solutions
      • Experience with data acquisition and manipulation, modeling, and data analysis from core financial platforms (SAP, QAD, CMS, HFM)
      • Experience writing efficient SQL using various SQL-development software packages and can use customer SQL or Hadoop for complex data pulls
      • Databased querying, writing procedures, complex joins and indexes
        
        Role Summary
        
        Key Responsibilities
        
        Key Qualifications/Requirements
        
        Additional Information

Keywords: Magna International Inc., Detroit , Director - Americas Audit & Audit Data Analytics, Accounting, Auditing , Troy, Michigan