In short
Data Engineer (full-time, hybrid in Hartford, CT) building Snowflake data models and writing complex SnowSQL, migrating data from on-prem Teradata to AWS (S3) and Snowflake, with ETL work (DBT a plus). Core stack: Snowflake, SnowSQL, AWS S3, SQL, ETL.
About the role
Position: Data Engineer
Location: Hartford CT- Hybrid
Duration: Full time
Skills
Mandatory Skills : Snowflake
Overview
Must have hands on expertise on Snowflake SnowSQL on Cloud
Good to have SQL and ETL Tool DBT
Requirements
- Candidate must be experienced working in projects involving Snowflake data model creation SnowSQL writing
- Ideal qualifications include experiences in
- OnPrem experience Teradata
- Experience on data migration to AWS Cloud on S3 Snowflake
- Understands where to obtain information needed to make the appropriate decisions
- Demonstrates ability to break down a problem to manageable pieces and implement effective timely solutions
- Identifies the problem versus the symptom
- Manages problems that require involvement of others to solve
- Reaches sound decisions quickly
- Carefully evaluates alternative risks and solutions before taking action
- Optimizes the use of all available resources
- Develops solutions to meet business needs that reflect a clear understanding of the objectives practices and procedures of the corporation department and business unit
Skills
- The Candidate must have 24 yrs of experience in Snowflake and AWS
- Hands on experience on AWS Cloud platform especially S3
- Experience on designing data model in Snowflake data types
- Experience in writing complex SnowSQL
- Exceptionally strong analytical and problem solving skills
- Relevent experience with ETL methods and with retrieving data from dimensional data models and data warehouses
- Strong experience with relational databases and data access methods especially SQL
- Excellent collaboration and crossfunctional leadership skills
- Excellent communication skills both written and verbal
- Ability to manage multiple initiatives and priorities in a fastpaced collaborative environment
- Ability to leverage data assets to respond to complex questions that require timely answe
Requirements
- Hands-on expertise with Snowflake SnowSQL on Cloud