Sr Associate, Data Engineer
Northern Trust23 hours ago
Pune, India or Bengaluru, IndiaSenior
Responsibilities
- Consult with business unit and IT management throughout the project development cycle.
- Design major systems and subsystems using existing technology, tools, and designs.
- Design and develop high-performance programming language components for trading applications.
- Provide technical expertise to support and enhance core brokerage applications.
- Implement data warehouses, data marts, ETL/ELT pipelines, BI solutions, and related data architectures.
- Build facts, dimensions, slowly changing dimensions, and star or snowflake schema models.
- Write and optimize complex SQL queries and work with relational database systems.
- Support scheduling and batch orchestration activities.
- Ensure code meets standards and is appropriately tested.
- Contribute to platform transformation, application reengineering, and strategic technology initiatives.
- Provide independent technical leadership and in-depth consulting to teams and business partners.
Requirements
- At least 5 years of experience working on large data warehousing projects, including data warehouses, data marts, ETL, and BI solutions.
- Understanding of star and snowflake schemas, facts, dimensions, and slowly changing dimensions.
- Familiarity with data architectures including data lakes, data lakehouses, and medallion architecture.
- Strong experience with data engineering and ETL/ELT.
- Strong experience with relational database systems, complex SQL, and SQL optimization.
- Working experience with Snowflake or Databricks.
- Working experience with Python.
- Experience with scheduling and batch orchestration tools such as Control-M.
- Exposure to data visualization tools such as Power BI or Tableau.
- Experience with cloud computing platforms such as Azure, AWS, or GCP.
- Familiarity with Agile development methodologies.
- Exposure to generative and agentic AI tools and solutions.
- Ability to provide technical leadership and operate independently on large, cross-functional, technically difficult initiatives.
Benefits
- Flexible and collaborative work culture with accessible senior leaders.
- Opportunities for movement and career development within the organization.
- Inclusive workplace committed to supporting employees and the communities it serves.
- Reasonable accommodations are available during the employment process.
- Bangalore office amenities include the Arrival Hub - Jungle, GameZone, and Employee Experience Zone.
Tech Stack
Categories
Data Engineering
About Northern Trust
Northern Trust is a financial services company that provides asset servicing (custody and fund administration), asset management, wealth management, and banking/treasury services to institutions, corporations, and affluent families. Its business model centers on fees for assets under custody/administration and management, plus banking services. Founded in 1889 and headquartered in Chicago, it is publicly traded on Nasdaq (NTRS) and serves clients across the Americas, EMEA, and APAC.