Logo of Huzzle

Home

Matches

Explore

Manage

Associate, SW Eng

image

Northern Trust Corporation

Yesterday

  • Job
    Full-time
    Mid & Senior Level
  • Software Engineering
    IT & Cybersecurity
  • Pune
  • Quick Apply

AI generated summary

  • You need 3-6 years in IT with 2+ years in data warehousing, strong SQL, ETL/ELT, Snowflake, Azure, Agile, and familiarity with financial markets and data visualization. Excellent communication is key.
  • You will design and develop high-performance components, provide technical expertise, support applications, ensure code quality, and participate in platform transformation and ITIL practices.

Requirements

  • A minimum of 3-6 years of experience in IT, with at least 2+ Years of experience working in large data warehousing projects, implementing data warehouses, data marts, ETL, BI solution etc.
  • Strong understanding of dimensional design techniques, star and snowflake schemas, building facts, dimensions, implementing SCD, various types of facts and dimensions etc.
  • Experience in data engineering, ETL/ELT
  • Experience with Informatica, DataStage or equivalent tools
  • Strong Experience in Snowflake Cloud DB
  • Experience with Snowflake data ingestion, streams, tasks, secured views, stored procedures etc.
  • Experience in RDBMS, writing complex SQL and performance tuning of queries
  • Experience with Python
  • Experience in Azure cloud services such as Azure ADF, Azure DevOps, LogicApp, Azure Functions etc.
  • Experience in managing data security, access controls, and designing secure data solutions.
  • Experience with Agile development methodologies and a track record of successfully delivering projects in an Agile environment.
  • Familiarity with data visualization tools such as Power BI etc.
  • Ability to work effectively with end users to define requirements.
  • Understanding of financial market domain, market participants, securities, asset classes, mutual funds, ETF etc.
  • Strong written and verbal communication skills, with the ability to communicate effectively with technical and non-technical stakeholders.

Responsibilities

  • Consults with Business Unit and IT management and staff on all phases of the project development cycle.
  • Helps to design major systems and their subsystems utilizing a solid understanding of available technology, tools and existing designs.
  • Design and develop high-performance programming language components used by trading applications.
  • Provide technical expertise to support and enhance core brokerage application.
  • Operates independently; has in-depth knowledge of business unit / function.
  • As subject area expert, provides comprehensive, in-depth consulting and leadership to team and partners at a high technical level.
  • Carries out activities that are large in scope, cross-functional and technically difficult.
  • Role is balanced between high level operational execution and development, and execution of strategic direction of business function activities.
  • Ensure code meets standards and tested appropriately in the platform.
  • Provide L3 support and develop deep understanding of the landscape, production management and ITIL fundamentals.
  • Be part of platform transformation journey and help in reengineering and improve the current set of applications.

FAQs

What is the primary role of the Associate, SW Engineering at Northern Trust?

The primary role is to design, develop, test, and deploy software solutions for the Brokerage team, along with proposing new designs and modifications to improve system performance and functionality.

What kind of experience is required for this position?

A minimum of 3-6 years of experience in IT, with at least 2+ years involved in large data warehousing projects, including implementation of data warehouses, data marts, ETL, and BI solutions.

What programming skills are necessary for this job?

Candidates should have strong experience with SQL, Python, and familiarity with data engineering and ETL/ELT processes.

Which technologies should I be familiar with for this role?

Familiarity with Informatica, DataStage, Snowflake Cloud DB, Azure cloud services (such as Azure ADF, Azure DevOps), and data visualization tools like Power BI is required.

Is knowledge of the financial market necessary for this position?

Yes, understanding the financial market domain, including market participants, securities, asset classes, mutual funds, and ETFs, is important for this role.

What development methodology does Northern Trust follow?

Northern Trust utilizes Agile development methodologies and seeks candidates with a successful track record of delivering projects in an Agile environment.

How does Northern Trust support professional development?

Northern Trust promotes movement within the organization, offers a flexible and collaborative work culture, and encourages exploration of new ideas.

What accommodations are available for employees with disabilities?

Northern Trust is committed to providing reasonable accommodations to individuals with disabilities throughout the employment process. Candidates can reach out to HR for any necessary accommodations.

How can I apply for this position?

Interested candidates can apply online and discuss their experiences and interests to see how they fit with the opportunities at Northern Trust.

What is the company culture like at Northern Trust?

The company culture is flexible, collaborative, and committed to exploring new ideas while focusing on financial strength, stability, and community service.

Northern Trust Corporation

Dynamic careers. Brighter futures. Greater possibilities.

Finance
Industry
10,001+
Employees
1889
Founded Year

Mission & Purpose

Northern Trust is a leading global financial services company that offers a comprehensive range of asset servicing, investment management, and banking solutions to individuals and institutions. With a strong emphasis on client-focused services, Northern Trust aims to build enduring partnerships with their clients by providing tailored solutions and exceptional customer experiences. Their expertise in asset management, wealth management, and asset servicing enables them to deliver innovative and reliable financial solutions that help clients grow, preserve, and manage their wealth effectively. As a trusted financial partner, Northern Trust's purpose is to empower their clients to achieve their financial goals and navigate the complexities of the global financial markets with confidence and peace of mind.