Senior Lead, Software Engineer

About Northern Trust

Northern Trust, a Fortune 500 company, is a globally recognized, award-winning financial institution that has been in continuous operation since 1889.

Northern Trust is proud to provide innovative financial services and guidance to the world’s most successful individuals, families, and institutions by remaining true to our enduring principles of service, expertise, and integrity. With more than 130 years of financial experience and over 22,000 partners, we serve the world’s most sophisticated clients using leading technology and exceptional service.

Northern Trust is looking for a Senior Lead Software Engineer to join its Technology Development Centre in Pune, India in the Investment Management team. This individual as part of an agile development team, will be responsible for analysis and design of upcoming Alternatives business platform that meet business and technical requirements.

Major Duties

• Analyse and build the data model from requirements of Private Equity, Hedge Fund businesses of Northern Trust Asset Management upcoming Alts datawarehouse.
• Analyse the source data while working with upstream teams and 50 South development team to produce schema.
• Build pipelines to extract required data from upstream systems and model them for reporting to clients and downstream systems.
• Break down requirements to domain, model and entity data for setup in datawarehouse.
• Able to define the Raw, Transform and Curate layers for data consumption.
• Liaise with various vendor products, internal applications to refine the requirements to help technical team solutions.
• First point of contact for clarification of any business gaps in Tech team locally.
• Participate in data modeling discussions and ensure the dataware house model meets business needs
• A team player with an ability to own the design and code as per requirement given.
• Communicate status (written and verbal) to project team and management
• Continuously looks for ways to improve the application’s stability, scalability and user experience
  
  

Experience

Experience/ Skills

• Bachelor or equivalent degree in finance with technology background
• 8-12 years experienced technical engineer with proven track record of modelling datawarehouse systems using public cloud offering preferably Snowflake.
• Strong understanding of Azure data stack and containerization.
• Strong with SQL and performance tuning
• Experience in Hedge Fund and Private Equity
• Experience in working and configuring SaaS products like Backstop, Subscribe, Sungard, Morning star etc.
• Experience in multi-tiered, complex system design & architecture
  
  

Required Skills

• Excellent knowledge of public datawarehouse offering preferably Snowflake
• Strong SQL writing and analysis skills
• Strong Experience on Data Analysis and modelling
• Exceptional DB debugging skills with view on performance tuning
• Proven ability to work on cloud native databases.
• Design thinking for both SQL and No SQL db stacks.
• Ability to lead and drive business user communication
• Excellent communication skills – both written and verbal.
• Strong with SQL and query writing skills for analysing and data quality.
• Experience working with ADO or equivalent SDLC tool.
• Expert level understanding of writing automated unit test cases.
• Experience with building interfaces to Data Lakes, Operational Data Stores and Enterprise Datawarehouse.
• Design, develop and use data structures and data marts to support reporting.
• Good analytical and problem-solving skills
• Both attention to detail & ability to rise above details to see broader implications & recommend strategic solutions
• Self-starter; Positive & adaptable in a continually changing environment
• Ability to work independently and with a team
• Proven interpersonal and communication skills with technical & business partners
• Strong understanding of building CI/CD pipelines for change management
  
  

Preferred/ Recommended Skills

• Familiarity with Change management process
• Understanding of Java Spring Boot stack
• Financial domain knowledge – Investment Management, potfolio construction and risk management.
• Worked on project streamlining the testing process by introducing automation, leveraging tools and setting goals to reduce time and effort.
  
  

Working With Us

As a Northern Trust partner, greater achievements await. You will be part of a flexible and collaborative work culture in an organization where financial strength and stability is an asset that emboldens us to explore new ideas.

Movement within the organization is encouraged, senior leaders are accessible, and you can take pride in working for a company committed to assisting the communities we serve! Join a workplace with a greater purpose.

We’d love to learn more about how your interests and experience could be a fit with one of the world’s most admired and sustainable companies! Build your career with us and apply today. #MadeForGreater

Reasonable accommodation

Northern Trust is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation for any part of the employment process, please email our HR Service Center at MyHRHelp@ntrs.com.

We hope you’re excited about the role and the opportunity to work with us. We value an inclusive workplace and understand flexibility means different things to different people.

Apply today and talk to us about your flexible working requirements and together we can achieve greater.