Data Analyst

  • Smithfield, RI
  • Posted 21 days ago | Updated moments ago

Overview

On Site
$DOE
Full Time

Skills

SQL
Python
AWS
Informatica
MYSQL
Snowflake

Job Details

HMG America LLC is the best Business Solutions focused Information Technology Company with IT consulting and services, software and web development, staff augmentation and other professional services. One of our direct clients is looking for Data Analyst in Smithfield RI. Below is the detailed job description.

Title: Data Analyst

Location Smithfield RI- Hybrid

Skills: AWS,Snowflake,Python,Informatica, SQL, MySQL

Data Integration Lead

Job Description:

Having 6 -9 years of experience in design, develop, and maintain Snowflake Data Warehouse solutions for large-scale data processing.

Proficiency in developing ETL/ELT processeing tools using Informatica, Python along with AWS services like Glue,Lambda

Strong database design, relational and dimensional modeling, and SQL skills

Model complex business requirements into efficient SQL queries and stored procedures to support reporting needs.

Collaborate with cross-functional teams to design scalable architectures for data workloads on Snowflake platform.

Ensure high availability, performance, security, and compliance of the entire system.

Strong expertise in writing complex SQL queries including joins, aggregations, window functions etc.

Experience with data modeling techniques to create efficient star schemas or other types of databases designs.

In-depth knowledge and Proven practical experience in migrating data from on-prem to cloud using Snowflake,Python & AWS services

In depth understanding of Snowflake Architecture including Snow SQL, Performance tuning, Compute and Storagea
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.