Senior Snowflake Data Engineer

Dexian; Providence (RI); On-site; USD 140,000 - 210,000; Full time

Job summary

Dexian is seeking a Snowflake Developer to design and optimize data pipelines and Snowflake database solutions at our Smithfield, RI site. You will work with Oracle, PostgreSQL, and NoSQL systems, leveraging AWS services to implement end-to-end data processing and analytics.

The role requires 8+ years in database design, 3+ years in Snowflake, and strong Python/Java development. Collaboration with cross-functional teams and CI/CD practices are essential in our fast-paced environment.

Qualifications

• 8+ years in database design and development (Oracle/PostgreSQL, NoSQL).
• 5+ years in ETL/ELT tools (Informatica or SnapLogic).
• 3+ years in Snowflake development.
• Strong Python and Java development experience.

Responsibilities

• Design, develop, and maintain scalable data pipelines and ETL/ELT solutions using Informatica PowerCenter and/or SnapLogic.
• Develop and optimize Snowflake database solutions, including complex SQL queries, stored procedures, data transformations, and performance tuning.
• Write and optimize complex SQL and Oracle PL/SQL queries, procedures, functions, and database objects.
• Develop Python scripts and applications for data processing, transformation, integration, and automation.
• Design and implement logical and physical data models to support enterprise data warehouse solutions.
• Work with relational and NoSQL databases, including Oracle, PostgreSQL, DynamoDB, and Aerospike.
• Leverage AWS services such as S3, EMR, EC2, Lambda, Athena, and CloudFormation for cloud-based data processing and integration.
• Develop and support distributed data processing solutions using technologies such as Kafka, Kinesis, SNS, and SQS.
• Collaborate with application, architecture, and data engineering teams to design and implement end-to-end solutions.
• Ensure data quality, performance, scalability, and reliability of critical applications and data pipelines.
• Work with CI/CD tools and DevOps practices to support application deployment and release management.

Skills

Snowflake development

SQL/PLSQL

Python

Data Modeling

Oracle/PostgreSQL

AWS (S3/EC2/Lambda/Athena)

Kafka/Kinesis/SNS/SQS

Java/Spring Boot

CI/CD (Jenkins)

API design (Swagger)

Tools

Informatica PowerCenter

SnapLogic

Job description

Dexian is seeking a Snowflake Developer to design and optimize data pipelines and Snowflake database solutions at our Smithfield, RI site. You will work with Oracle, PostgreSQL, and NoSQL systems, leveraging AWS services to implement end-to-end data processing and analytics.

The role requires 8+ years in database design, 3+ years in Snowflake, and strong Python/Java development. Collaboration with cross-functional teams and CI/CD practices are essential in our fast-paced environment.