Senior Snowflake Data Engineer – ETL/ELT & AWS

Dexian; Smithfield (RI); On-site; USD 120,000 - 180,000; Full time

Job summary

Dexian seeks an experienced Data Engineer in Rhode Island to design and optimize data pipelines and data models supporting enterprise data warehouses. You will work with Snowflake, Oracle, PostgreSQL, and NoSQL databases, plus AWS services for scalable cloud-based processing.

The role emphasizes ETL/ELT, Python development, and CI/CD collaboration with cross-functional teams to ensure data quality and reliable, high-performance data solutions.

Qualifications

• 8+ years in database design and development (Oracle / PostgreSQL, NoSQL).
• 6+ years programming in SQL, R, or Python.
• 5+ years ETL/ELT with Informatica PowerCenter or SnapLogic.
• 4+ years AWS services (S3, EMR, EC2, Lambda, Athena, CloudFormation).
• 3+ years Snowflake experience.
• 3+ years Python/Java with Spring Boot.
• 3+ years messaging systems (Kafka, Kinesis, SNS, SQS).
• Hands-on data modeling and data warehousing.

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 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

Oracle PL/SQL

ETL/ELT tools

Python

Data modeling

PostgreSQL

NoSQL (DynamoDB, Aerospike)

AWS services

Kafka/Kinesis/SNS/SQS

CI/CD (Jenkins, Artifactory, DevOps)

API design (Swagger)

Open-source distributed systems

JIRA/Git/Stash/FishEye/Crucible/Maven

SonarQube (code quality)

Tableau/Qlik/Power BI

Java/Spring Boot

Drools Rules Engine

Tools

Informatica PowerCenter

SnapLogic

Job description

Dexian seeks an experienced Data Engineer in Rhode Island to design and optimize data pipelines and data models supporting enterprise data warehouses. You will work with Snowflake, Oracle, PostgreSQL, and NoSQL databases, plus AWS services for scalable cloud-based processing.

The role emphasizes ETL/ELT, Python development, and CI/CD collaboration with cross-functional teams to ensure data quality and reliable, high-performance data solutions.