Cloud Automation Engineer
Job Description
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.