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

Big Sky Compounding

Pharmacy Assistant Job at Big Sky Compounding

 ...About Us Were a friendly, community-focused compounding pharmacy dedicated to providing excellent care and personalized service...  ...Overview Were looking for a dependable and personable Pharmacy Assistant to join our team! In this role, youll be the first point of... 

Laurel Lake Placid

Room Attendant - Housekeeper Job at Laurel Lake Placid

 ...Overview Opportunity: Room Attendant Clean and maintain guest rooms to ensure rooms meet established standards. Your Growth Path Housekeeping Supervisor Assistant Executive Housekeeper Executive Housekeeper Your Focus Greet guests upon interaction... 

Omni Inclusive

Technical Product Owner Job at Omni Inclusive

 ...Technical Product Owner, Mandatory hands-on experience and ability to navigate current tools is required. Overview The technical product owner for digital and web is responsible for leading the web platforms domain management product vision, operations... 

Anne Arundel Community College

Life Skills Instructor Job at Anne Arundel Community College

Department Occupational Skills Duties Provide life skills instruction (goal setting, interpersonal skills, financial literacy, health and nutrition, life and parenting skills, employability skills) instruction to incarcerated adults in a Maryland correctional facility...

People R Us Community Residential Services

Residential Mentor Job at People R Us Community Residential Services

Job Description Job Description Our Residential Aides (RA) are our on-site staff who provide support at our group home(s) as our clients work towards achieving their treatment goals. RMs are expected to engage our clients every shift and to meet them where they are...