Cloud Data Engineer

SS&C • New York, NY

1d • Remote

About The Position

SS&C is a leading financial services and healthcare technology company, headquartered in Windsor, Connecticut, with over 27,000 employees across 35 countries. The company serves approximately 20,000 financial services and healthcare organizations, providing expertise, scale, and technology. This role is for a Cloud Data Engineer to join SS&C in building a unified Sales Data Lake on AWS. This initiative aims to consolidate over 6 Salesforce instances and various disparate tools from more than 40 acquired business units into a single source of truth. The engineer will be involved in designing ETL pipelines, defining infrastructure as code, implementing entity resolution for a Unified Client 360, and building executive dashboards, all while adhering to a security-first engineering culture. The position offers training on Claude Code as part of SS&C's AI-augmented engineering program. Joining SS&C means working with proprietary technology and deep industry expertise to support complex financial and healthcare operations, designing, implementing, and operating solutions that help clients manage data, automate processes, and scale their businesses. Employees will collaborate with industry experts, utilize modern platforms, and engage with 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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Number of Employees: 1-10 employees