Hybrid Philly Data & Cloud Engineer - ETL, Snowflake & AWS

Polluxa, Inc.; Philadelphia (Philadelphia County); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Polluxa, Inc. seeks a data engineer to design, build, and maintain scalable ETL/ELT pipelines and optimize Snowflake data models. You will implement Python automation, IaC with Terraform/AWS CloudFormation, and manage Snowflake/AWS resources with a security‑first mindset.

You will collaborate across teams, provide documentation, and ensure data quality while supporting reporting, analytics, and AI initiatives in a hybrid on-site setting in downtown Philadelphia.

Qualifications

• Bachelor's degree in computer science, engineering, information systems, or a related discipline, or equivalent practical experience.
• Minimum of five years of experience in data engineering, cloud engineering, platform engineering, or a related technical role supporting production systems.

Responsibilities

• Design, build, test, deploy, and maintain scalable ETL/ELT pipelines using Matillion or similar technologies to support reporting, analytics, applications, and AI.
• Develop and optimize complex SQL transformations and data models in Snowflake, emphasizing performance, maintainability, testing, and data quality.
• Develop and deploy Python-based automation and serverless workflows, including AWS Lambda functions, to support data ingestion, orchestration, and recurring operational tasks.
• Use infrastructure-as-code practices and tools, such as Terraform or AWS CloudFormation, to provision and maintain cloud resources consistently.
• Administer and optimize the Snowflake environment, including roles, warehouses, resource monitors, query performance, usage and cost controls.
• Administer and support AWS resources used by the data platform, including S3, CloudWatch, EventBridge, Secrets Manager, and KMS.
• Implement monitoring and alerting across pipelines and platform services to surface health, performance, and data quality issues before they reach the business.
• Manage least-privilege, role-based access across Snowflake, AWS, Bitbucket, and related platforms, partnering with Information Security and Infrastructure to implement and review IAM roles, policies, and service accounts.
• Implement secure data sharing and integration with custodians, external partners, and vendors.
• Create and maintain architecture diagrams, data-flow documentation, operational runbooks, and platform standards.

Skills

SQL

Python

Data engineering

Cloud engineering

Agile methodologies

Data quality

Troubleshooting

Communication skills

Security mindset

IAM knowledge

Education

Bachelor's degree in CS/Engineering/IS

Tools

Matillion

Snowflake

Terraform

AWS CloudFormation

AWS

Bitbucket

Job description

Polluxa, Inc. seeks a data engineer to design, build, and maintain scalable ETL/ELT pipelines and optimize Snowflake data models. You will implement Python automation, IaC with Terraform/AWS CloudFormation, and manage Snowflake/AWS resources with a security‑first mindset.

You will collaborate across teams, provide documentation, and ensure data quality while supporting reporting, analytics, and AI initiatives in a hybrid on-site setting in downtown Philadelphia.