Snowflake Engineer Job at United IT Solutions, Charlotte, NC

dnlxQVJyazJpT25wWmp5NzhqclM5b1U3TlE9PQ==
  • 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

Graze Craze Charcuterie Boards & Boxes (Newport Mesa & Lagun...

Team Member/Food decorator Part-time (must be able to work 12+hours) Job at Graze Craze Charcuterie Boards & Boxes (Newport Mesa & Lagun...

 ...****@*****.*** JOB TYPE: Part time (up to 12~ 16 hours/week) Pay Rate: $2...  ...that encourages our team to have fun at work whileenjoying life outside of work....  ...for enthusiastic individuals or college students who are looking to earn some extra money.... 

L4 Security and Consulting Group, LLC

Corporate Armed Security Guard (Lexington) Job at L4 Security and Consulting Group, LLC

 ...Summary of Job: L4 Security and Consulting Group LLC is announcing the availability...  ...Agent in the Lexington, KY area. L4 is a private security agency that sets a high standard...  ...Disabilities Employer VEVRAA Federal Contractor * Priority referrals for protected... 

Black Caucus of the American Library Association

Project Archivist Job at Black Caucus of the American Library Association

 ...for the future and furthers the Harvard Radcliffe Institutes commitment to the study of women, gender, sexuality, and society. The Archival Technical Services unit at Schlesinger Library fosters the discovery, use, and care of archival and manuscript materials through... 

Burke & Herbert Bank & Trust

BSA/AML Compliance Analyst Job at Burke & Herbert Bank & Trust

 ...Job Description Job Description CLASSIFICATION: Non-exempt REPORTS TO: BSA/AML Compliance Manager JOB DESCRIPTION Summary/Objective Responsible for supporting the Banks compliance with BSA/AML regulations and OFAC sanctions by conducting real-time... 

Vaco

Desktop Support Analyst Job at Vaco

 ...Vaco is actively looking for a contract desktop support to sit on-site 5x a week in Charlotte, NC. Must be able to work on a W2 basis and no sponsorship is offered. Required skills: ~ Local to Charlotte, NC as this role is on-site 5 days a week outside Uptown...