Overview
Skills
Job Details
Job Role : AWS Lambda Developer Report Generation
Location : San Diego, CA - (Hybrid - 3 Days Remote & 2 Days Onsite)
Job Type : Contract W2
Duration : 12TH + Months
About the Role
We are seeking an experienced AWS Lambda Developer to design and implement a serverless report generation system that integrates with Snowflake and downstream reporting services. The solution will be triggered by SQS message arrivals, process billing data from Snowflake, format customer reports (CSV/PDF with custom headers and line items), store outputs in S3, and notify reporting services through an API endpoint.
The ideal candidate will have strong expertise in Python-based Lambda development, cloud-native event-driven architectures, and robust error-handling patterns (including DLQs for failed events).
Key Responsibilities
- Serverless Architecture Development
- Implement AWS Lambda functions in Python triggered by SQS message events.
- Connect securely to Snowflake to fetch billing data for report generation.
- Merge and transform data into customer-specific report formats (CSV, PDF, or other).
Report Generation & Storage
- Implement dynamic report formatting logic (custom headers, line items, multi-format support).
- Store generated reports into Amazon S3 with versioning and lifecycle policies.
- Return the S3 object identifier to reporting services via REST API call.
Reliability & Logging
- Ensure robust logging and monitoring for all Lambda executions.
- Implement retry policies and push failed events to Dead Letter Queues (DLQs) for analysis.
- Design for scalability, performance, and cost optimization in a serverless environment.
Collaboration
- Work with data engineering and reporting service teams to align on data schemas and output requirements.
- Partner with DevOps/CloudOps for CI/CD automation, infrastructure-as-code (Terraform/CloudFormation), and security.
Required Qualifications
- 5+ years of software engineering experience, with at least 2+ years in AWS serverless development.
Proven expertise in Python (data handling, report generation, API integrations).
Hands-on experience with AWS Lambda, SQS, S3, CloudWatch, IAM, and DLQs.
Strong knowledge of Snowflake (SQL queries, connectors, authentication).
Experience in generating and handling CSV/PDF reports programmatically.
Familiarity with REST API integrations and secure data exchange.
Strong debugging, logging, and observability practices in serverless systems.
Preferred Skills
- Experience with Terraform or CloudFormation for infrastructure provisioning.
Knowledge of CI/CD pipelines for Lambda deployments.
Familiarity with billing and invoicing systems or other financial data domains.
Exposure to monitoring/alerting tools (CloudWatch, X-Ray, Datadog).