Data 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.

We're seeking Data Engineer who will help us simplify our data landscape and solve data problems using the Lakehouse Platform. You will work with business/ product and engineering teams, to understand their data needs and optimal data delivery mechanisms. You will then build new data pipelines and data products that help deliver meaningful data digitally to clients and their wealth advisors.

Your daily work will involve:

Design/Development: You will design and support the business's database and table schemas for new and existing data sources for the lakehouse. Create and support the ETL in order to facilitate the movement of data into the Lakehouse.

Through your work you will ensure

• The data platform is scalable for large amounts of data ingestion and processing without service degradation.
• Processes are built for monitoring and optimizing performance
• Implement Chaos Engineering practices and measures that allow the end-to-end infrastructure to function as expected, even if individual components fail

Collaboration: You will be collaborative - working closely with Product Owners, application engineers, and other data consumers within the business in an attempt to gather and deliver high quality data for business-cases. Work closely with other disciplines/departments and teams across the business in coming up with simple, functional, and elegant solutions that balance data needs across the business

Analytics: You will play an analytical role in quickly and thoroughly analyzing business requirements and subsequently translating the emanating results into good technical data designs. Document the data solutions, develop, and maintain technical specification documentation for all reports and processes.

Skills you MUST have:

• 4+ years proven ability of professional Data Development experience
• 3+ years proven ability of developing with Databricks or Hadoop/HDFS
• 3+ years of experience with PySpark/Spark
• 3+ years of experience with SQL
• 3+ years of experience developing with either Python, Java, or Scala
• Full understanding of ETL concepts and Data Warehousing concepts
• Data modeling and query optimization skills, implementation experience of Data Vault and Star Schema
• Experience with CI/CD
• Experience with version control software
• Strong understanding of Agile Principles (Scrum)
• Experience with Azure
• Experience with Databricks Delta Tables, Delta Lake, Delta Live Tables
• Bachelor's Degree (Computer Science, Management Information Systems, Mathematics, Business Analytics, or STEM)

Bonus points for experience in the following

• Proficient with Relational Data Modeling
• Experience with Python Library Development
• Experience with Structured Streaming (Spark or otherwise)
• Experience with Kafka and/or Azure Event Hub
• Experience with GitHub SaaS / GitHub Actions
• Experience with Snowflake
• Exposure to BI Tooling (Tableau, Power BI, Cognos, etc.)

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.

https://www.northerntrust.com/content/dam/northerntrust/pws/nt/images/careers/taleo-india.png

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 [Confidential Information].

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.