Programmer Analyst, Expert - AWS Cloud & Data Platform Engineer

Job Responsibilities

• Design, develop, and operate AWS-based solutions using services including API Gateway, Lambda, EC2, S3, IAM, CloudWatch, and Database Migration Service (DMS).
• Implement Infrastructure as Code using Terraform and enterprise-approved modules and patterns.
• Design and maintain CI/CD pipelines supporting application, infrastructure, and database deployments.
• Implement monitoring, logging, alerting, and operational dashboards using CloudWatch and enterprise observability tools.
• Ensure cloud solutions align with enterprise security, governance, networking, and compliance requirements.

Data Engineering & Snowflake

• Design and support scalable data ingestion, replication, and transformation pipelines supporting enterprise analytics and operational reporting.
• Develop and maintain integrations between operational systems, cloud platforms, and Snowflake data environments.
• Build and optimize Snowflake database objects including schemas, tables, views, tasks, streams, and stored procedures.
• Support data quality, data validation, metadata management, and governance practices within the Snowflake platform.
• Tune and optimize Snowflake workloads for performance, scalability, and cost efficiency.

Database & Replication Engineering

• Administer Microsoft SQL Server databases hosted on AWS EC2 environments.
• Configure and manage high availability, backup/recovery, patching, monitoring, and performance tuning activities.
• Design, implement, and support AWS DMS replication processes including Change Data Capture (CDC), latency monitoring, and reconciliation.
• Analyze and troubleshoot database, replication, and application performance issues.

Qualifications

• Bachelor's Degree in Computer Science, Information Systems, Engineering, or equivalent experience.
• 7 years of experience in programming analysis, software engineering, cloud engineering, or data platform development.
• 3+ years of hands-on experience deploying and operating production workloads on AWS.
• Experience with AWS services including API Gateway, Lambda, EC2, S3, IAM, and CloudWatch.
• Experience implementing Infrastructure as Code using Terraform.
• Hands-on Microsoft SQL Server administration experience.
• Experience building and supporting Git-based CI/CD pipelines.
• Strong SQL development and database design experience.
• Working knowledge of cloud security, IAM, networking, and monitoring concepts.
• Experience with AWS DMS and CDC-based replication architectures.
• Experience supporting enterprise-scale AWS environments using centralized governance and shared services models.
• Experience with Windows Server administration on AWS, including Systems Manager (SSM) and Patch Manager.
• Knowledge of enterprise networking concepts including VPCs, Transit Gateway, Direct Connect, VPC Endpoints, and hybrid cloud architectures.
• Experience implementing monitoring and observability solutions using CloudWatch dashboards, alarms, tracing, and operational analytics.
• Understanding of SQL Server high-availability architectures, replication technologies, and disaster recovery solutions.
• Experience designing and supporting Snowflake data warehouse and data engineering solutions.
• Experience with Snowflake Streams, Tasks, Snowpipe, performance tuning, and data governance capabilities.
• Experience with cost optimization and FinOps practices in cloud environments.
• Experience supporting utility, energy, or other critical infrastructure systems.
• AWS certifications (Solutions Architect, Developer, Database Specialty, SysOps) preferred.
• Snowflake SnowPro certification preferred.