Senior Data Analyst Senior Data Analyst …

Visa
in Singapore, Singapore, Singapore
Permanent, Full time
Last application, 20 Feb 20
Competitive
Visa
in Singapore, Singapore, Singapore
Permanent, Full time
Last application, 20 Feb 20
Competitive
Senior Data Analyst
Develop, deploy and maintain software solutions using Microsoft SQL Server products (SQL Server, SSIS, SSRS), Tableau and other technologies (such as Robotic Process Automation tools) to deliver solutions which improve the effectiveness and efficiency of the IAM Internal Controls function. Primarily operate in a Windows Server and desktop development environment although other hosting environments may be utilized in specific projects. Maintain analytics environments in conformance with Visa Corporate Key Controls, Technical Security Requirements and Privacy policies. Demonstrate strong project management skills while performing end-to-end automation of data analytics routines and procedures in support of key initiatives such as Continuous Control Monitoring/Auditing. Participate in all phases of development cycle (planning, design, development, testing, deployment and maintenance); engage in frequent interactions with internal teams to define the business and technical requirements; prototype, develop and test advanced data analytics techniques; train users; document analytic procedures; and report progress to management.

Qualifications

  • Assist manager in planning, development and execution of Microsoft SQL server, SSIS, SSRS and Tableau based data analysis procedures to create sustainable and repeatable data analytics.
  • Follow Visa corporate development, deployment and change control methodologies.
  • Incorporate previous MS SQL Server-based data warehouse experience including ETL best practices in project design and development.  
  • 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 automation and audit support projects. Regularly inform manager of project status, issues, risks and results.
  • Interact with management and business partners to identify appropriate data elements required for analytics. 
  • 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.
  • Consult with audit teams and provide data analysis support and guidance during audit engagement planning and execution.
  • Support data requests from the various audits. Activities may include extracting and downloading data, organizing that data, data scrubbing and performing analyses including thorough documentation of the steps performed.
  • Work with internal team members to meet department goals of zero audit findings with material weaknesses.
  • Possess strong written and oral communication skills and demonstrate these skills during the development process.
  • Bachelor's degree in computer science, management information systems.
  • 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
  • 2 or more years of experience in design and application of advanced data analytic techniques
  • Certificate in Data Science desirable
  • MCSA and MCSE certification in SQL Server desirable
  • Tableau Desktop Certification desirable
  • Oracle database and PL/SQL development experience desirable
  • Big Data  and Machine learning experience desirable
 

Close
Loading...