Staff Data Engineer
Staff Data Engineer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Job Description:
The mission of Visas Internal Audit team is to enhance and protect Visas organizational value by providing risk-based and objective assurance advice and insight on the state of Visas risk and control environment. The IA Analytics Audit 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 programs 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.
- Demonstrate commitment to Visas and Internal Audits strategic vision be a self-starter and promote project ownership and responsibility for actions. Interact with Audit project team members in working towards Departmental goals.
Qualifications :
Basic Qualifications:
6 years of work experience with a Bachelors Degree or at least 4 years of work experience with an Advanced degree (e.g. Masters MBA JD MD) or 2 years of work experience with a PhD degree.
4 years of Internal Audit experience preferably with a large financial institution or Big 4 assurance experience.
2 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:
Bachelors or Masters degree in computer science management information systems or in STEM (Science Technology Engineering or Math).
6-10 years of Internal Audit experience with 2-3 years of IA Analytics experience.
2 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
Automation Anywhere or similar RPA tool certification preferable.
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.
Remote Work :
No
Employment Type :
Full-time
Employment Type
Full-time
