Job Title:  FIN_Global Middle Office_AS

Nomura Overview:

Nomura is an Asia-headquartered financial services group with an integrated global network spanning over 30 countries. By connecting markets East & West, Nomura services the needs of individuals, institutions, corporates and governments through its four business divisions: Retail, Asset Management, Wholesale (Global Markets and Investment Banking), and Merchant Banking. Founded in 1925, the firm is built on a tradition of disciplined entrepreneurship, serving clients with creative solutions and considered thought leadership. For further information about Nomura, visit www.nomura.com

Nomura Services India, (Powai) supports Nomura’s businesses around the world. Powai’ s world class capabilities in trading support, research, information technology, financial control, operations, risk management and legal support have played a key role in facilitating Nomura’s global operations and are an integral part of Nomura’s global expansion plans. The Powai operation is a critical part of the platform to support the growth of Nomura’s global business.

Business Unit Overview

Finance Transformation Office (FTO) is part of the Finance Wholesale Division at Nomura which is a central function providing the capability to shape, drive and deliver the global Finance Strategy and a single point of interfacing for other corporate initiatives. As a digital tool hub we offer transformation support to other corporate divisions over and above finance

FTO comprises of four work streams:

• Chief Data Office (CDO): is responsible for the design and delivery of our Data, Platform, and Digital Innovation & Automation strategies
• Finance Operating Model: all aspects of our onshore and Powai Operating Model delivery
• Transformation & Culture Development: build and embed innovation and transformational change into our Global organization
• Cross Functional Initiatives: evaluate our model across both Finance & Corporate to identify new opportunities to work differently

Within Finance, we pride ourselves on our professionalism and believe working in such a fast moving industry that it reflects in our departmental culture - dynamic and flexible. Senior management takes a hands-on approach within the department, and is keen to reward hard work, enthusiasm and success.

The ongoing investment at Nomura requires staff that can drive forward the necessary evolution of the Finance function through innovation and participation in Global Strategic initiatives.

The candidate must have a strong background in visual data delivery; interactive design and SQL with a passion for re imagine/ design. In addition, the candidate will be responsible for planning, designing, coordinating and developing highly interactive dashboards, reports with built-in guided analytics for various lines of business.

Position Specifications:

Role & Responsibilities:

• Ability to interact with business users and understand their requirements
• Perform end to end Data validation & Data modelling if required
• Communicate complex topics to team through both written and oral communications
• Take complete ownership of end to end project management from understanding the requirement from business, suggesting improvement (To be process flow), preparing the design document, developing, conducting unit testing and ensuring timely delivery of the project.
• Design and develop ETL workflows and datasets in Alteryx to be used by the BI
• Solid, deep experience with data extract, transform and load (ETL) tools as Alteryx
• Prepare technical specifications and documentation for Alteryx workflows supporting BI reports
• Write Complex SQL queries on multiple tables using complex joins
• Knowledge of Python, tools used and its libraries, should have some bit of hands on coding experience.
• Conduct unit tests and develop database queries to analyse the effects and troubleshoot any issues that arise
• Develop and update technical documentation for senior leaders and colleagues to serve as a reference guide
• Understand if there is technical or business limitation to implement technology control/configuration
• Provide recommendations to strengthen current processes, controls pertaining to technology platforms
• Understand and document the compensating control for managing or mitigating security risk that might exist due to the technical or business limitation
• Ensure all discussions with business to be documented and change management process to be adhered
• Provide regular updates on assign tasks to team members
• Develop impactful presentations and documents

 Mandatory Skill Set:

• Technical -Alteryx (Mandatory)
• 2+ years of related experience with Alteryx
• Hands-on skills and experience in Alteryx Designer, Alteryx Server, and the tools with Alteryx such as Predictive, Parsing, and Transforms.
• Experience with data ETL (SQL, Alteryx) and ability to manipulate data and draw insights from large data sets. . 
• Strong analytical, problem solving, and troubleshooting abilities
• Good understanding of unit testing, software change management, and software release management
• Good understanding the star schema and data models in the existing data warehouse.
• Sql (Mandatory) & Python good to have
• Develop efficient MS-SQL queries and procedures to extract reports from database
• Understanding of data modeling and how to implement the same
• Design, build, and maintain efficient, reusable, and efficient Python code along with other common libraries
• Exp. In Tesseract or similar OCR engine and Camelot is preferable
• Hands on experience in pdf data extraction using python libraries and Regex
• Unstructured to Structured text data processing experience is a plus
• Python deployment experience with pip and wheel packages
• Should be Proficient with GIT.

Essential Skill

• Strong communication skills and analytics
• Self-Starter and able to self-manage
• Ability to prepare accurate reports for all levels of staff in a language and tone appropriate to the audience.
• Good team player, ability to work on a local, regional and global basis
• Able to perform under pressure.
• Ability to drive to succeed and go beyond the extra mile
• Other programming experience
• Financial services industry experience
• General knowledge/skills: Databases, Excel, PowerPoint