Engineer, Data & Cloud, Clark Capital
HybridPhiladelphia, Pennsylvania, United States
Job Summary
Design, build, test, deploy, and maintain scalable ETL/ELT pipelines using Matillion to support reporting, analytics, applications, and AI. Develop and optimize complex SQL transformations in Snowflake, while administering AWS resources and implementing infrastructure-as-code practices with Terraform. Own platform administration, access provisioning, and governance across Snowflake and AWS, including monitoring, alerting, and least-privilege IAM role management. Participate in production support and incident resolution, troubleshooting data quality and performance issues to convert recurring failures into permanent fixes. Work on-site in downtown Philadelphia three days a week within a hybrid schedule.
Required Qualifications
- five or more years of experience in data engineering, cloud engineering, platform engineering, or a related discipline
- hands-on experience developing production ETL/ELT pipelines
- experience working with Snowflake
- experience administering AWS resources
- Bachelor's degree in computer science, engineering, information systems, or a related discipline, or equivalent practical experience
- Willing to work on-site in downtown Philadelphia 3 days a week
- Ability to communicate technical concepts, risks, incidents, and recommendations clearly to technical and business stakeholders
- Strong analytical, troubleshooting, and root-cause analysis skills
- Demonstrated attention to detail
- Ability to prioritize project work, operational responsibilities, and production issues in a high-accountability environment
- Security-first mindset with a practical understanding of least privilege, data protection, secrets management, encryption, and auditable access controls
- Solutions-oriented and accountable, with the ability to take ownership of ambiguous technical problems and drive them from investigation through sustainable resolution
- Commitment to continuous improvement through automation, documentation, standardization, and the elimination of recurring operational issues
- Experience developing and deploying software using the Agile methodologies
Desired Qualifications
- Experience developing and deploying software using the Matillion or similar technologies
- Experience developing and optimizing complex SQL transformations and data models in Snowflake
- Experience developing and deploying Python-based automation and serverless workflows, including AWS Lambda functions
- Experience using infrastructure-as-code practices and tools, such as Terraform or AWS CloudFormation
- Experience administering and optimizing the Snowflake environment, including roles, warehouses, resource monitors, query performance, usage and cost controls
- Experience administering and supporting AWS resources used by the data platform, including S3, CloudWatch, EventBridge, Secrets Manager, and KMS
- Experience implementing monitoring and alerting across pipelines and platform services
- Experience managing least-privilege, role-based access across Snowflake, AWS, Bitbucket, and related platforms
- Experience implementing secure data sharing and integration with custodians, external partners, and vendors
- Experience creating and maintaining architecture diagrams, data-flow documentation, operational runbooks, and platform standards
- Experience participating in production support and incident resolution, troubleshooting data quality, performance, and reliability issues
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.