CAREERS

Snowflake ETL Engineer

🔍 United States, Illinois, Chicago

📁
InformationTechnology
📅
93694 Requisition #
📅
Mar 18, 2022 Post Date
Thanks for your interest in the Snowflake ETL Engineer position. Unfortunately this position has been closed but you can search our 0 open jobs by clicking here.

Description

Your key responsibilities

Snowflake:

  • 2 years of Hands-on experience in Snowflake cloud data warehouse.
  • Experience of designing warehouse and pipelines with Snowflake architecture, Data model.
  • Well versed with Snowflake concepts like Snowpipe, SnowSQL, Cloud services, Data sharing, Reader accounts, Designing optimal virtual warehouses as per the business SLAs, optimized data distribution, clustering keys, usage of materialized views.
  • Minimum of 6 years of Overall IT experience including experience as Technical lead in Data warehousing technologies including modern cloud data warehousing.
  • Hands on Experience in ELT tools like Informatica, AWS glue or any other parallel ELT tools.
  • Experience of semi-structured (XML, JSON) and unstructured data handling
  • Knowledge of how to implement security features like SSO, column masking, role-based administration.

 

BI Reporting/ETL Experience:

  • Should have designed and developed stored procedures, queries, ETL Process, views, Data models necessary to support BI Visualizations.
  • Should be able to effectively handle reports performance and administration
  • Strong knowledge of ELT/ETL concepts, design and coding.
  • Candidate should be eager to learn advance technologies, new product updates etc., learn and train other team members
  • Excellent analytical skills and communication skills (written, verbal and presentation).
  • Additional knowledge of complex source system data structures preferably in Financial services (preferred) Industry and reporting related developments will be an advantage.
  • Using warehouse data to generate reports to support business decision making and business performance monitoring.
  • Generating and delivering quality reports to customers and performing quality assurance checks on reports. Develop, Customize, Deploy, maintain data visualizations as per client business requirements
  • Should have thorough knowledge in creating dynamic visualizations with multiple concepts.
  • Experience working with clients throughout various parts of implementation lifecycle
  • Proactive with Solution oriented mindset, ready to learn new technologies for Client requirements.

Previous Job Searches

My Profile

Create and manage profiles for future opportunities.

Go to Profile

My Submissions

Track your opportunities.

My Submissions
© 2019 Northern Trust Corporation. All Rights Reserved | northerntrust.com | Terms and Conditions | Privacy Policy | California Applicant Privacy Notice
Reasonable Accommodation
Northern Trust is committed to working with and providing reasonable accommodations to individuals with disabilities. If, because of a medical condition or disability, you need a reasonable accommodation for any part of the employment process, please email our HR Service Center or call 1-800-807-0302 (North America), +630-276-5353 (Asia Pacific), 1800-425-0333 (India), +44(0)207 982 4357 (Europe, Middle East and Africa) and let us know the nature of your request and your contact information.

Equal Employment Opportunity Statements (hover over the below links)
  • APAC/India EEO Statement
    • APAC/INDIA EEO STATEMENT

      It is the policy and practice of Northern Trust to provide equal employment opportunities to all employees and applicants. Northern Trust does not discriminate on the basis of race, colour, religion or belief, nationality, ethnic or national origin, sex, marital status, sexual orientation, disability or age. All employment decisions will be made in a non-discriminatory manner in accordance with our obligations under the law and codes of practice. This includes human resources’ decisions relating to recruitment, terms and conditions of employment, transfers, promotions and access to learning and development.

  • Canada EEO Statement
    • Canada EEO STATEMENT

      Northern Trust is an Equal Opportunity Employer. Hiring and other employment decisions at Northern Trust are made without regard to race, colour, religion, sex, ancestry, national origin, ethnic origin, age, disability, citizenship, veteran status, sexual orientation, record of offences, marital status, family status, or any other characteristic protected by federal, provincial, or local law, regulation, or ordinance.

  • EMEA EEO Statement
    • EMEA EEO STATEMENT

      It is the policy and practice of Northern Trust to provide equal employment opportunities to all employees and applicants. Northern Trust does not discriminate on the basis of race, colour, religion or belief, nationality, ethnic or national origin, sex, marital status, sexual orientation, disability or age. All employment decisions will be made in a non-discriminatory manner in accordance with our obligations under the law and codes of practice. This includes human resources’ decisions relating to recruitment, terms and conditions of employment, transfers, promotions and access to learning and development.

  • USA EEO Statement
    • USA EEO STATEMENT

      It is the policy of The Northern Trust Company to afford equal opportunity in all phases of employment without regard to an individual's age, race, color, religion, creed, gender, national origin, citizenship status, marital status, pregnancy, sexual orientation, gender identity, gender expression, genetic tests and information, physical or mental disability, protected veteran status or any other legally protected status. EEO Know Your Rights (U.S.)


Pay Transparency

Pay Transparency Nondiscrimination Provision (U.S)