Summary Of Day-To-Day Responsibilities:

• Analyze, document and validate business rules requirements from business users.
• As Spark SQL is used as a programming language for the business rules, a successful candidate is required to be able to write, test Spark SQL statements to translate the business requirements into the programming code.
• Optimize performance and tune Spark SQL statements
• Use Visual Studio (SQL Integration Services) to analyze SSIS packages
• Analyze multiple system builds by completing and updating project requirements documentation; understanding project scope; determining project priorities; ensuring efficient and on-time delivery of project tasks and milestones; following proper escalation paths.
• Collaborate closely with the technology team to implement the requirements, provide necessary guidance to testers during QA process
• Assess business process and system inefficiencies
• Ability to analyze and synthesize business requirements, including recognizing patterns and conceptualizing processes
• Participate in standup and planning meeting as part of the Agile methodology framework

Must Have:

• Experience working on large scale projects as well as handling day-to-day operational requests from the business
• Over 3 years of data analysis
• Familiarity with the general concepts of optimization and performance tuning of SQL statements.
• Familiarity with RDBMS (Oracle, SQL Server)
• Ability to successfully manage multiple tasks at any given point, strong relationship building skills & communication skills
• Being comfortable working in a distributed teams environment
• Strong problem-solving skills

Nice To Have:

• Experience in financial services industry, specifically in Capital Markets and Treasury
• Experience with Big Data and NoSQL databases (Hadoop/HBase/Spark) and Spark SQL is a bonus

Education:

• Ideally bachelor’s degree in either computer science, electrical engineering, information technology, or statistics