• Degree/Certifications Required: Undergraduate Degree or Technical Certificate
• Years of experience: 5+ years relevant experience
• Reason for request/why opened: New projects
• % Interaction with Stakeholders: 50%
• Project Scope: transformation from Hadoop to cloud
• Team Size: 7 ppl
• Selling Points of Position: Working within a leading FI organization
• IT BSA ideally from FI Strong focus RDBMS / DML language
• The Treasury Analytics Group is responsible for measurement and management of market risk (interest rate and foreign exchange) for the Bank’s retail portfolios. The team develops financial models and processes required for measuring, transfer pricing, hedging product profitability, and financial management reporting.
• The Treasury Analytics Group is embarking on a brand new initiative to build the next generation strategic platform for risk, valuations and analytics to meet the growing and future needs of the department. This is an exciting opportunity to work on cutting edge technologies including Big Data and NoSQL databases (Hadoop, HBase, Hive, Spark and MongoDB) to allow the business to gain advanced insight into their portfolios and valuation metrics.
• Lead business requirements elicitation, analysis, and documentation efforts
• Assist technology team in Azure cloud solution implementation; write Spark SQL queries to analyze and transform data; provide feedback to User Interface team; testing and documentation
• Analyze solution requirements; understand project scope; determine project priorities; ensure efficient and on-time delivery of project tasks and milestones; follow proper escalation paths
• Look for opportunities for process improvement and automation
• 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
• Onboarding new feeds to ensure completeness and accuracy of TBSM metrics.
• Build extraction pipelines from Indigo to other applications to support regulatory or business requirements.
• Integrate third party vendor based upstream data sources or downstream analytics with Indigo.
• Migrate Indigo to the Azure Cloud.
• Guide junior BSAs in the team.
• Code review of junior BSAs.
• Manage Business as Usual (BAU) activities- i.e. manage regular processes currently in production.
• Experience working on large scale projects as well as handling day-to-day operational requests from the business stakeholders
• Strong RDBMS (Oracle, SQL Server) hands on experience; SQL language
• Ability to successfully manage multiple tasks at any given point, strong relationship building skills & communication skills
• Ability to work independently and as part of the team in Agile environment
• Strong problem-solving skills
• Familiarity with the general concepts of optimization and performance tuning of SQL statements
• Ability to successfully manage multiple tasks at any given point, strong relationship building skills & communication skills
• Ability to analyze and synthesize business requirements, including recognizing patterns and conceptualizing processes.
• Being comfortable working in a distributed teams environment with strong problem solving skills
• 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
• Familiarity with other programming languages is a plus (e.g., Python)
Join our fast-paced real estate team in Marlton, NJ as a full-time Administrative Assistant. Youll play a critical role in managing... ...including calendar management, file compliance, budget tracking, and office supply coordination.Qualifications: Previous administrative...
...guidance and review of plans and associated documents. Provide assistance for scientific administration of the watershed programs on archaeological data, archeological resources, and historical preservation.Conducts analyses of issues associated with watershed policies,...
... 3 TOEIC650 BOAT GSS...
...international reputation for success, Western ranks as one of Canada's top research-intensive universities. Our research excellence expands... ..., diverse, and comprehensive unit, comprised of seven Schools (Nursing, Kinesiology, Health Studies, Physical Therapy, Occupational...
...with a fun team, then our Entry Level Data Analyst role is your perfect match! Our data... ...to meet deadlines and goals when working remotely as an Entry Level Data Analyst (Were a big... ...team bonding seriously. Get ready for epic online game nights - laughter and friendly...