Engineer, Data & Cloud, Clark Capital

Raymond James Financial, Inc.

Philadelphia, PA, United States

20 days ago

Apply on www.phillyjobs.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

5 years minimum

Working hours

Regular working hours

Job source

www.phillyjobs.com

Tech stack

Query Performance Agile Methodology Artificial Intelligence Amazon Web Services Amazon S3 Data Analysis Cloud Computing Cloud Engineering Cyber Security Information Systems Information Engineering Data Infrastructure

+21 more

Extract Transform Load (ETL) Data Security Data Flow Control Identity and Access Management Python (Programming Language) Key Management Role-Based Access Control Software Deployment SQL Databases Data Ingestion Snowflake AWS Lambda Cloudformation Servicebus Infrastructure Automation Frameworks Information Technology Bitbucket Cloudwatch Terraform Data Pipelines Serverless Computing

Job description

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.
Participate in production support and incident resolution, troubleshooting data quality, performance, and reliability issues and converting recurring failures into permanent fixes, monitoring rules, or runbook entries.

Requirements

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.
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.
Experience developing and deploying software using the Agile methodologies
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.