Cloud Data Engineer

SS&C Technologies • New York, NY

1d • Remote

About The Position

SS&C is building a unified Sales Data Lake to consolidate 6+ Salesforce instances and disparate tools across 40+ acquired business units ($96T AUM) into a single source of truth on AWS. This role involves designing ETL pipelines, defining infrastructure as code, implementing entity resolution for a Unified Client 360, and building executive dashboards, all within a security-first engineering culture. The successful candidate will be trained on Claude Code as part of SS&C’s AI-augmented engineering program. SS&C combines proprietary technology with deep industry expertise to support complex financial and health care operations. Our teams design, implement, and operate solutions that help clients manage data, automate processes, and scale their businesses with confidence. You will work with industry experts, modern platforms, and evolving technologies, gaining exposure to real-world operational challenges and large-scale enterprise environments.

Requirements

• BS in CS, Data Engineering, or related field
• 5+ yrs cloud data engineering
• 3+ yrs AWS
• AWS Glue (PySpark), Redshift, S3, IAM proficiency
• Production Terraform experience (modules, state)
• Full-stack: Python + React/Vue + REST APIs
• Salesforce data models & integration APIs
• Data modeling, warehousing, quality frameworks
• Security: IAM, encryption, VPC, compliance controls

Nice To Haves

• AWS certs (Solutions Architect, Data Analytics)
• AWS Entity Resolution / Lake Formation / MDM
• Financial services / SOC 2 / SOX environment
• QuickSight, Tableau, or Looker experience
• Kubernetes (EKS) & container orchestration
• AI dev tools (GitHub Copilot, Claude Code)
• Multi-tenant SaaS or M&A tech integration
• CASB, DLP, cloud security monitoring

Responsibilities

• Design and maintain ETL/ELT pipelines using AWS Glue (PySpark) to ingest, transform, and load data from Salesforce and proprietary sources into Amazon Redshift
• Author and manage all cloud infrastructure with Terraform (modules, state management, CI/CD), provisioning Redshift, Glue, S3, Lambda, Step Functions, IAM, and KMS
• Implement AWS Entity Resolution to deduplicate and link client records across Salesforce tenants, building matching workflows with confidence scoring at enterprise scale
• Build interactive QuickSight dashboards and internal web applications (React + Python/Node.js) for pipeline monitoring and consolidated sales intelligence
• Implement data classification, encryption, access controls, and SIEM integration aligned with Salesforce hardening standards (SSO/MFA, OAuth, API throttling)
• Adopt Claude Code for AI-augmented development, progressing through SS&C’s Copilot → Navigator → Autopilot competency tiers

Benefits

• medical, dental, and vision coverage
• a 401(k) plan with company match
• paid time off, holidays, and parental leave
• professional development reimbursement opportunity
• discretionary bonus and/or equity awards, such as restricted stock units or stock options, based upon individual and business performance at the company’s discretion

What This Job Offers

• Job Type: Full-time
• Career Level: Senior