Audit Staff Data Analyst
Job Locations US-TX-Arlington | Hybrid
Requisition ID 2022-40788 Employee Type Full Time-Regular Category Audit
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
Options
Apply Now! Apply
Share
Share this Job Email
Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed
Need help finding the right job?
We can recommend jobs specifically for you! Click here to get started.
Return to job search
To learn more about GM Financial benefits, click here
GM Financial is an Equal Opportunity Employer and is committed to diversity and inclusion at every level of our organization. We do not discriminate against any applicant or employee based on race, color, age, gender, national origin, religion, sexual orientation, gender identity, veteran status, disability or any other federal, state or local protected class.
GM Financial has an accommodation process in place and provides accommodations for applicants and employees with disabilities. If you require a reasonable accommodation because of a disability, please contact Human Resources at 1-866-411-4748 or by e-mail at HRConnection@gmfinancial.com .
Application FAQs Software Powered by iCIMS
www.icims.com