Snowflake Developer

Logisoft Technologies Inc; Smithfield (RI); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Snowflake development

Job summary

Logisoft Technologies Inc. in Smithfield, RI seeks a Snowflake Developer for a 12-month on-site role. The candidate will design and optimize Snowflake data warehousing, develop SQL, PL/SQL, Python ETL scripts, and model data for analytics. The role requires hands-on Snowflake experience and experience with Informatica PowerCenter or SnapLogic for data integration. On-site every other week.

Remote work is limited to occasional visits; duration may extend based on project needs.

Qualifications

• Snowflake architecture, data warehousing, SQL development and performance optimization.
• PL/SQL development including stored procedures, functions, packages, triggers, and complex queries.
• ETL tools Informatica PowerCenter and/or SnapLogic for data integration and pipeline development.
• Python scripting for data processing, automation and ETL tasks.
• Advanced SQL with joins, subqueries, CTEs, analytics and optimization.
• Data modeling across conceptual, logical, physical, dimensional, Snowflake/Star schemas.

Skills

Snowflake

PL/SQL

Informatica PowerCenter

SnapLogic

Python

SQL

Data Modeling

Job description

Dear Connections,

Title: 182069 - Snowflake Developer

Location: Smithfield, RI (on-site every other week)

Duration: 12 months

Required Technical Skills

• Snowflake: Strong hands-on experience with Snowflake architecture, data warehousing, SQL development, and performance optimization.
• PL/SQL: Experience developing stored procedures, functions, packages, triggers, and complex database queries.
• ETL Tools: Hands-on experience with Informatica PowerCenter and/or SnapLogic for data integration and pipeline development.
• Python: Experience in Python scripting for data processing, automation, and ETL-related activities.
• SQL: Strong SQL skills, including complex joins, subqueries, CTEs, analytical functions, and query optimization.
• Data Modeling: Experience with conceptual, logical, and physical data modeling, dimensional modeling, Star Schema, and Snowflake Schema.

Preferred Qualifications

• Experience working with enterprise data warehouse environments.
• Understanding of data governance, data quality, and data validation practices.
• Experience with cloud-based data integration and migration.
• Knowledge of incremental data loading and CDC concepts.
• Experience supporting enterprise analytics and business intelligence solutions.
• Strong problem-solving, communication, and analytical skills.

Mandatory Skills

• Snowflake
• PL/SQL
• Informatica PowerCenter and/or SnapLogic
• Python
• SQL
• Data Modeling