Job Description*
Associate would require proficiency in data analytics to perform business analysis for operational risk organization. Objective of the role is to develop / modify existing scripts using SAS, SQL, SSIS and Trifacta automation technologies. The developer needs to refer to standard procedures and methodologies to perform data extraction, analysis, sampling and monitoring using above mentioned technologies. The results and analysis based on the work would further be used to develop trend analysis, and risk impact within the business.
Responsibilities*
- Own and execute the end to end execution of new and/or modified test plans, scripts and associated documentation in collaboration with the Test Owner, Test Development Manager and Sampling Execution Manager, ensuring compliance with enterprise testing standards and policies
- Understanding data requirements, working with data partners to ensure appropriate sampling requirements are incorporated in to the Test Plans, developing the logic required for providing samples for tests, distribution of samples for testing and resolution of any issues encountered in executing scripts. Responsible for accessing pertinent databases or acquiring raw data from third party sources along with all associated documentation
- Candidate must exhibit an exceptional degree of ingenuity, creativity, and resourcefulness
- Often acts independently to uncover and resolve issues associated with procurement of data to be used for testing
- Maintain SOR (System of Record) tracking of test status per standards
- Participate in other phases of testing (intake, development, reporting) to provide expertise and feedback on areas assigned
- Delivering high-quality results and managing, manipulating and summarizing large quantities of data
- Incorporate automation during test development using effective and efficient technologies, where possible
Requirements:
Graduates or Post-Graduates in Computer Science, Software Engineering, Statistics.B.Tech/B.E./B.Sc.(Statistics)/B.C.A./M.C.A/M.Sc.(Statistics)
Experience Range:3-6 years
Foundational skills:
- Candidate should be PCEP certified & should have completed multiple development projects in Python.
- Strong understanding of Python/ SQL/Trifacta/SAS/PowerQuery with data warehousing and mining concepts.
- 5+ years’ experience with an internal audit, testing, risk management, process improvement, compliance, or front-line control role
- Strong understanding of the sampling methodologies
- Experience building queries to source data from a variety of different types of data sources such as DB2, Teradata, Oracle, SQL Server, Hadoop, Hive
- Proficiency with MS Office suite with an emphasis on Excel to perform data analytics, pivot tables, lookups and external data source connections
- Ability to communicate complex technical concepts with non-technical business partners, in order to develop populations for testing
- Lead the team of analysts & manage the daily production deliverables pipeline
- Ability to serve as an escalation support for the group of analysts & assist with issue resolution & complete BAU deliverables in timely manner.
- Demonstrated project management skills; Ability to handle multiple competing priorities with demonstrated success at achieving SLA (Service Level Agreements)
- Strong familiarity with sampling business requirements and test design
- Strong partnership and influencing skills, research and analytical skills
- Strong verbal and written communication skills as well as interpersonal skills
- Self-starter, organized, versatile, capable of performing work independently with minimal direction
- Ability to think independently, solve problems, and develop solutions
- Demonstrated ability to interface effectively with Senior management
- Strong team player
Desired skills*
- Experience in Enterprise Control functions and related compliance efforts
- Risk management, Compliance and/or Audit experience
- Working within a financial institution
- Diverse experience across multiple lines of business and functions
Shift Timings:12:30 PM - 9:30 PM IST
GIFT City / Hyderabad