Visa’s Internal Audit team needs to enhance and protect organizational value by providing risk-based and objective assurance, advice, and insight on the state of Visa’s risk and control environment. The IA Analytics Senior Manager will identify opportunities for data analytics throughout the audit lifecycle and develop/deploy solutions to meet strategic objectives.
Requirements
- 3 or more years of experience with Microsoft SQL Server family of products (SSMS, SSIS, SSRS) with extensive development experience using the MS T-SQL Query Language
- 2 or more years of experience with Tableau or a similar visual analysis technology
- 1 or more years of experience in design and application of advanced data analytic techniques
- 2 or more years of experience with Power BI, Tableau or a similar visual analysis technology
- Oracle database and PL/SQL development experience desirable
- MCSA and MCSE certification in SQL Server desirable
- Tableau Desktop Certification desirable
Responsibilities
- Develop and deploy appropriate analytics solutions using Microsoft SQL Server products (SQL Server, SSIS, SSRS), Power BI, Tableau and other technologies (such as Robotic Process Automation tools)
- Use a ‘Data Tracing Matrix’ or other mechanisms to identify data sources used in audit procedures
- Review ‘Risk and Control’ matrices, data and process flow diagrams and audit test procedures to identify opportunities to use data analytics that help to expand risk coverage, increase efficiency and provide increased assurance
- Assist IA Director/Sr. Director in planning, development and execution of Microsoft SQL server, SSIS, SSRS, Power BI and Tableau based data analysis procedures to create sustainable and repeatable data analytics solutions.
- Monitor the ‘refresh’ activities of the data warehouse including periodic data refresh, troubleshooting errors, fixing bugs and implementing enhancements.
- Apply professional skepticism when assessing data sources and validate completeness and accuracy of data received.
- Assist in the documentation of functional, technical and source data requirements.
Other
- Act as project leader for the IA data analytics program. Regularly inform manager, audit team and senior management of project status, issues, risks and results.
- Demonstrate strong time and project management skills.
- Demonstrate knowledge of the data analysis process and experience with the application of data analytics in the assessment of IT and business processes.
- Stay abreast of company business strategies, Payment industry technology advances and the risk profile of assigned business areas to ensure relevancy of analytics approach.
- Lead the planning, development, and project execution on complex analytics implementations.
