Snowflake Engineer Job at United IT Solutions, Charlotte, NC

  • United IT Solutions
  • Charlotte, NC

Job Description

Job Description:


This position is for a Cloud Data / Reporting engineer with a background in SQL and data warehousing for enterprise level systems. The position calls for someone that is comfortable working with business users along with business analyst expertise.


Major Responsibilities:
• Experience designing and developing Enterprise Data Warehouse solutions.
• Demonstrated proficiency with Data Analytics, Data Insights
• Proficient writing SQL queries and programming including stored procedures and reverse engineering existing process
• Leverage SQL, programming language (Python or similar) and/or ETL Tools (Azure Data Factory, Data Bricks, Talend and SnowSQL) to develop data pipeline solutions to ingest and exploit new and existing data sources.
• Perform code reviews to ensure fit to requirements, optimal execution patterns and adherence to established standards.


Skills:
• 10+ years - Enterprise Data Management
• 10+ years - SQL Server based development of large datasets
• 5+ years with Data Warehouse Architecture, Snowflake experience preferred
• 3+ years' experience in Finance / Banking industry - some understanding of Securities and Banking products and their data footprints.
• 2+ years Python coding experience
• Experience with pyspark (good to have, should understand the architecture)
• Proficient with Data Visualization tools
• Hands-on experience with Snowflake utilities such as SnowSQL and SnowPipe
• Working knowledge of MS Azure configuration items with respect to Snowflake.
• Hands-on experience with Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing
• Experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling.
• Previous experience leading an enterprise-wide Cloud Data Platform migration with strong architectural and design skills
• Capable of discussing enterprise level services independent of technology stack
• Experience with Cloud based data architectures, messaging, and analytics
• Superior communication skills
• Cloud certification(s)
• Any experience with Regulatory Reporting is a Plus

Education
• Minimally a BA degree within an engineering and/or computer science discipline
• Master's degree strongly preferred

Job Tags

Similar Jobs

Softbank Investment Advisers

Product Manager, Trust & Safety Job at Softbank Investment Advisers

 ...Product Manager, Trust & SafetyChime was created with the mission to make financial peace of mind a reality for millions of everyday...  ...product to help people lead healthier financial lives. The Trust & Safety team spans the full member lifecycle and is responsible for... 

SlaterConsult

Controller Job at SlaterConsult

 ...beneficial, as would experience from a Big Four accounting firm, although neither is a requirement. Familiarity with Microsoft Dynamics NAV/Navision or derivatives would also be a plus.Who You AreYou are structured, detail-oriented and comfortable taking ownership.... 

REVOLVE

Retail Personal Stylist Job at REVOLVE

 ...Instagram @REVOLVEcareers or #lifeatrevolve. Are you ready to set the standard for Premium apparel? Main purpose of the Retail Personal Stylist role: This is a full time role for a candidate who is looking to work in contemporary & luxury personal shopping. The... 

Group1 Automotive, Inc.

Automotive Technician - BMW MINI of Rockland Job at Group1 Automotive, Inc.

Overview MARKET LEADING PAY! BMW MINI of Rockland is part of the fast-growing Group 1 Automotive, a leader in automotive retail and service. We are growing and looking for Quality, Service Mechanics/Technicians to work with our Quality Dealership, representing the Quality... 

ACLU - National Office

Assistant Director/Senior Writer Job at ACLU - National Office

 ...Assistant Director/Senior Writer The ACLU seeks applicants for the full-time position of Assistant Director/Senior Writer in the Development Department of the ACLU's National office in New York, NY. This is a hybrid role that has in-office requirements of two (2) days...