Snowflake Data Specialist

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.

Snowflake Data Specialist who will perform mission critical duties in our data Service Delivery strategy, contributing to the maturity and governance of our Core Data Services Platform. A passionate professional who can blend the ever-evolving technology landscape of Cloud and Advanced Analytics with responsibilities to provide input on implementation and administration methodologies to Technology stakeholders. 

The Snowflake Data Specialist will mainly be responsible to develop, optimize and oversee company’s logical, conceptual, and physical data model and provide recommendations.

Role and Responsibilities

• Experience with data security and data access controls and design in Snowflake.
• Proficiency in complex SQL, Unix Shell/Python Scripting, performance tuning and database optimization techniques.
• Must have expertise in Azure Platform as a Service (PAAS) model and its integration with Snowflake to load/unload data.
• Implement/Maintain cloud-based Enterprise data warehouse solutions with multiple data platforms along with Snowflake environment to build data movement strategy.
• Lead in highlighting technical debt and gaps for end-to-end Data integration process using ETL for Structured, semi-structured and Unstructured Data.
• Recommend necessary updates to modeling principles, processes, solutions, and best practices to ensure that the Snowflake is aligned with business needs of the environment. 
• Act as Data domain expert for Snowflake in a collaborative environment to provide demonstrated understanding of data management best practices and patterns.
• Candidate will be responsible to attend on-call after office hours including weekend to support High and Critical production issues.
• Actively contribute to the supportability of the applications as well as continuous service improvement projects.
• Develop understanding of NT’s systems and products utilizing reference materials and support procedures.

Required Skills and Level of Experience

• 8+ years of experience implementing/maintaining data management solutions 
• Expertise in Snowflake concepts like setting up Resource monitors, RBAC controls, scalable virtual warehouse, SQL performance tuning,  time travel and automating them.
• Experience in handling semi-structured data (JSON, XML),
• Experience in in re-clustering of the data in Snowflake with good understanding on Micro-Partitions.
• Experience in Migration processes to Snowflake from on-premises database environment and cloud based. 
• Experience in designing and building manual or auto ingestion data pipeline using Snowpipe.
• Well versed with Snowflake DevOps procedures, grants, privileges with snowflake costing optimization background.
• Az-900 Certification will be an added benefit
• Design and develop automated monitoring processes on Snowflake using combination of Python, PySpark, Bash with SnowSQL.
• Snow SQL Experience in developing stored Procedures writing Queries to analyze and transform data. 

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.