Data Engineer

Company Description Visa is a world leader in payments and technology with over 259 billion payments transactions flowing safely between consumers merchants financial institutions and government entities in more than 200 countries and territories each year Our mission is to connect the world through the most innovative convenient reliable and secure payments network enabling individuals businesses and economies to thrive while driven by a common purpose - to uplift everyone everywhere by being the best way to pay and be paid Make an impact with a purpose-driven industry leader Join us today and experience Life at Visa The mission of Visa s Internal Audit team is to enhance and protect Visa s 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 work with audit teams to identify opportunities for use of data analytics throughout the audit lifecycle S he will then 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 that fulfil the identified opportunities and meet the program s strategic objectives Responsibilities include 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 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 Provide support on the existing data analytics environment 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 Essential Functions Lead the planning development and project execution on complex analytics implementations Lead the execution of the specific technical areas of a project supervising other team members and providing coaching where requested Manage the internal goals and metrics of the IA analytics program and provide reports on their progress to senior leaders Maintain business relationships with appropriate levels of management to ensure that the analytics team is aware of changes in business activities and objectives and these are used as inputs in the development of analytics solutions Promote new ideas and new ways of executing projects and internal infrastructure enhancements Qualifications Basic Qualifications 8 years of work experience with a Bachelor s Degree or at least 6 years of work experience with an Advanced degree e g Masters MBA JD MD or 2 years of work experience with a PhD degree 8 years of Internal Audit experience preferably with a large financial institution or Big 4 assurance experience 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 Preferred Qualifications Bachelor s or Master s degree in computer science management information systems or in STEM Science Technology Engineering or Math 8-12 years of Internal Audit experience with 2-3 years of IA Analytics experience 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 Power BI Tableau or a similar visual analysis technology MCSA and MCSE certification in SQL Server desirable Tableau Desktop Certification desirable Oracle database and PL SQL development experience desirable Strong time management skills Excellent written and oral communication skills Ability to travel domestically and internationally approximately 10 - 25 Work experience in a large financial institution or a matrix organization Additional Information Visa is an EEO Employer Qualified applicants will receive consideration for employment without regard to race color religion sex national origin sexual orientation gender identity disability or protected veteran status Visa will also consider for employment qualified applicants with criminal histories in a manner consistent with EEOC guidelines and applicable local law