Engineer, Data & Cloud, Clark Capital

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

Job Description Summary

Clark Capital is seeking a Data & Cloud Engineer to build and support the data pipelines and cloud infrastructure that power our reporting, analytics, applications, and AI capabilities. The ideal candidate will bring five or more years of experience in data engineering, cloud engineering, platform engineering, or a related discipline, with hands-on experience developing production ETL/ELT pipelines, working with Snowflake, and administering AWS resources. This role will work closely with our Data Engineering team and collaborate across Development, AI, Information Security, and Infrastructure. In addition to developing pipeline logic and data models, the engineer will own platform administration, access provisioning, and governance across Snowflake and AWS. The successful candidate will be a collaborative, hands-on engineer who can solve complex technical problems and take ownership from design through production support.

Technical Skills & 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.
• 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.

Competencies for Success

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

Education

• Bachelor’s: Computer and Information Science
• Bachelor’s: Information Technology

Work Experience

General Experience - 6 to 10 years

Certifications

Certifications

Travel

Less than 25%

Workstyle

Hybrid

Compensation

The total compensation for this position includes base salary or wages, and may include components such as additional compensation (cash or equity), discretionary bonuses, or commissions.

Benefits

• medical, dental, and vision
• life insurance
• critical illness insurance and accident insurance
• disability benefits
• retirement savings
• paid time off (including vacation, holidays, and sick leave)
• parental leave

Eligibility for benefits and specific offerings may vary based on position and employment status. To view more details of the benefits offered, visit Myrjbenefits.com.

At Raymond James our associates use five guiding behaviors (Develop, Collaborate, Decide, Deliver, Improve) to deliver on the firm's core values of client-first, integrity, independence and a conservative, long-term view. We expect our associates at all levels to:

• Grow professionally and inspire others to do the same
• Work with and through others to achieve desired outcomes
• Make prompt, pragmatic choices and act with the client in mind
• Take ownership and hold themselves and others accountable for delivering results that matter
• Contribute to the continuous evolution of the firm

At Raymond James - as part of our people-first culture, we honor, value, and respect the uniqueness, experiences, and backgrounds of all of our Associates.

When associates bring their best authentic selves, our organization, clients, and communities thrive.

We are a diversified financial services company providing wealth management, capital markets, asset management, banking and other services to individuals, corporations and municipalities. Founded in 1962 in St. Petersburg, Florida, rather than on Wall Street, we have always embraced being a different kind of financial services firm. Today, Raymond James has locations and subsidiaries across the United States, Canada, the United Kingdom, and Germany, and is listed on the New York Stock Exchange under the symbol RJF.

We invest in you with wide-ranging benefits and the support of leaders and colleagues who care. From development opportunities and enriching networking groups to prioritizing diversity, inclusion and the power of different perspectives, Raymond James is where good people grow. Our people-first culture is outlined in our Culture Blueprint. Check it out to see why many choose to work at Raymond James – and why they stay.

The Company is an equal opportunity employer and makes all employment decisions on the basis of merit and business needs.

Our business is deeply focused on people and their financial well-being. We're committed to helping individuals, corporations and institutions achieve their goals, while also supporting successful professionals and helping our communities prosper. We believe doing well and doing good aren't mutually exclusive. As an established but ever-evolving company, you can start – or continue – growing your career here.