Job description

Overview:
The Audit Staff Data Analyst is responsible for building, developing, and executing data analytics and assisting with the development of analytics skills for Internal Audit team members. This includes data analytic projects and continuous monitoring techniques executed with consistency and overall strategy, policy, and procedures of the company.
Responsibilities:
JOB DUTIES
  • Establish relationships and collaborate with business, IT, and internal audit personnel at appropriate levels to capture, prioritize and document data analytic requirements and drive measurable results
  • Extract, model, and front-end solution information from various sources using complex query statements and advanced data analytic tools Document data analytic procedures and transfer knowledge to both internal and external customers
  • Analyze complex data, identify anomalies, and provide usable insight to internal and external customers
  • Stay abreast of current data analytic techniques/technology, business and industry trends relevant to the business
  • Recommend types of analytics and procedures to apply to meet audit objectives
  • Proactively identify opportunities for application of advanced analytics and automation in audit processes
  • Prepare documentation and analytical reports that effectively summarize results, assumptions, and conclusions for internal audit and business
  • Monitor progress, manage risk and ensure key stakeholders are kept informed about progress and expected outcomes
  • Training and mentoring audit team members in the use of data analytics and data analytics tools
  • Support internal audit annual risk assessment, monitoring, and planning activities
  • Perform other duties as assigned
  • Conform with all company policies and procedures
Qualifications:
Knowledge
  • A combination of business knowledge, technical skills, people skills, and the ability to work with management on a data strategy
  • Working knowledge of SAS, Cognos, TOAD and/or Rapid SQL, Power BI and/or Tableau
  • Working knowledge of Oracle ERP and Oracle databases preferred
  • Strong technical skills complemented by analytical abilities
  • The ability to extract, model, and front-end solution information from various databases using complex query statements and advanced database tools
  • Experience writing efficient Structured Query Language (SQL) using various SQL development software packages including SAS and Oracle PL/SQL
  • Ability to use custom SQL for complex data pulls
  • Experience in Database querying, writing procedures, complex joins, and indexes
  • Experience with Python, R preferred
  • Experience mapping out the conceptual design for planned database; considering both the back¬end organization of data and front¬end accessibility for end users
  • Project management, internal audit and/or business preferred
Skills
  • Strong analytical skills
  • Able to work independently and as a member of a cross-functional and cross-geographical team
  • Able to incorporate new knowledge into current/new processes
  • Ability to manage time and to work with management to prioritize task when needed
  • Multitasking
  • Problem Solving
Additional Knowledge Skills and Abilities
  • Proficient understanding of project management methodologies, relationship oriented, and able to build bridges networks across functions
Education
  • Bachelor’s Degree in Data Analytics, Information Technology, Computer Science, Engineering, Accounting, Finance or a related field required
Experience
  • 1-3 years of experience using business intelligence tools and databases, applying analytics and data reporting techniques in a complex environment required
  • 1-3 years of experience using Data Visualizations tools (PowerBI or Tableau preferred) or similar front end data solutions (eg, IBM Cognos, MS Excel, MS Access) including ability to design and implement canned / Ad-Hoc reports and dashboard solutions required
  • 1-3 years of experience writing efficient Structured Query Language (SQL) using various SQL development software packages including SAS and Oracle PL/SQL required
  • 1-3 years of experience in Database querying, writing procedures, complex joins, and indexes required
Licenses
  • Professional certification (ie, Microsoft Certified Business Intelligence, Oracle DBA, SQL DBA, CISA, CPA, CIA, CFE) 1 Year preferred
  • Data analytics tools certifications (eg, SAS, Oracle, PowerBI, Python) preferred
Working Conditions
  • Normal office environment
  • Hybrid work environment
  • Strong focus on providing quality service to internal and external customers
  • Limited travel may be required to support business needs

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.