Cloud Automation Engineer

Job Title: Cloud Automation Engineer

Location: North Reafing, MA

Employment Type: Full-Time

Job Description

We are seeking an AWS-focused engineer to build and operate a cloud analytics and dashboard layer for device and fleet data. Data lands in S3 and is queried primarily through Amazon Athena. You will own the end-to-end delivery of reliable datasets, SQL queries, and visualization dashboards used by engineering and operations teams. This role requires strong execution in a fast-paced, ambiguous environment, with a high bar for quality, operational excellence, and written communication.

Responsibilities

• Own dashboard and analytics deliverables end-to-end (design → build → test → release → operate).
• Build and maintain Amazon Athena SQL queries, views, and datasets that support filtering, drill-down analysis, and repeatable reporting.
• Develop and enhance dashboards using QuickSight and/or CloudWatch dashboards (or equivalent AWS-native visualization tooling).
• Define metrics/KPIs with stakeholders and translate requirements into clear, actionable visualizations.
• Improve cost and performance of analytics workflows (partition strategies, query optimization, efficient formats, and operational guardrails).
• Drive data quality and correctness: detect schema changes, missing partitions, late data, and regressions; write RCAs and implement durable fixes.
• Implement mechanisms that scale (dashboards as mechanisms, SLIs/SLOs where applicable, alarms, runbooks, and automated checks).
• Collaborate cross-functionally with teams responsible for ingestion/ETL; contribute to ETL as a plus (Lambda, Step Functions, scheduling).

Essential Skills

• 4+ years of relevant experience delivering dashboards and analytics solutions in AWS.
• Strong SQL proficiency with experience building maintainable, production-grade query logic.
• Hands-on experience with Amazon Athena and S3-based analytics workflows.
• Experience with QuickSight and/or CloudWatch dashboards (or comparable visualization tools integrated with AWS).
• Proficiency in TypeScript (expected usage mix approximately 60% TypeScript / 40% other technologies).
• Strong SDLC discipline: Git, code reviews, automated testing, and CI/CD.
• Strong troubleshooting and root-cause analysis skills; ability to drive issues to closure.
• Strong written communication (design notes, operational runbooks, incident summaries).
• Experience with AWS CDK (TypeScript) and Infrastructure as Code practices.