Data & Cloud Engineer — ETL, Snowflake & AWS

255 Clark Capital Management Group, Inc.; Philadelphia (Philadelphia County); Hybrid; USD 120,000 - 170,000; Full time

Benefits offered by this job

Medical, dental, and vision

Life insurance

Disability benefits

Retirement savings

Paid time off

Job summary

Clark Capital is seeking a Data & Cloud Engineer to design and run scalable data pipelines and cloud infrastructure powering reporting, analytics, applications, and AI capabilities.

The ideal candidate will have 5+ years in data/cloud/platform engineering, hands-on Snowflake and AWS experience, and strong collaboration across Data Engineering, AI, Information Security, and Infrastructure teams. Hybrid work with on-site Philadelphia duties.

Qualifications

• Five+ years of experience in data/cloud/platform engineering or related field.
• On-site in downtown Philadelphia 3 days a week.
• Experience with production ETL/ELT pipelines and data modeling.
• Ability to communicate complex technical concepts to technical and non-technical stakeholders.

Responsibilities

• Design, build, test, deploy, and maintain scalable ETL/ELT pipelines using Matillion or similar technologies.
• Develop and optimize SQL transformations and data models in Snowflake with focus on performance and data quality.
• Develop Python-based automation and serverless workflows (e.g., AWS Lambda) for data ingestion and orchestration.
• Use IaC (Terraform or CloudFormation) to provision cloud resources consistently.
• Administer and optimize Snowflake environment (roles, warehouses, monitors, cost controls).
• Manage AWS resources (S3, CloudWatch, EventBridge, Secrets Manager, KMS).
• Implement monitoring/alerting for health and data quality issues; ensure governance and least-privilege access.
• Create architecture diagrams, data-flow docs, and operational runbooks; participate in production support and incident resolution.

Skills

ETL/ELT pipelines

Snowflake

AWS

Python

Infrastructure as Code

SQL

Data modeling

Production support

Cloud governance

Security awareness

Education

Bachelor’s degree in CS/Engineering

Information Systems

Tools

Matillion

Terraform

AWS CloudFormation

Bitbucket

Snowflake

Job description

Clark Capital is seeking a Data & Cloud Engineer to design and run scalable data pipelines and cloud infrastructure powering reporting, analytics, applications, and AI capabilities.

The ideal candidate will have 5+ years in data/cloud/platform engineering, hands-on Snowflake and AWS experience, and strong collaboration across Data Engineering, AI, Information Security, and Infrastructure teams. Hybrid work with on-site Philadelphia duties.