Engineer, Data & Cloud, Clark Capital

Job Description Summary

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.

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

Work Experience

Certifications

Travel

Workstyle

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. This position is eligible for a benefits package that may include 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); and 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 .

At Raymond James our associates use five guiding behaviors (Develop Collaborate Decide Deliver Improve) to deliver on the firms 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. The Company is an equal opportunity employer and makes all employment decisions on the basis of merit and business needs.