AWS Lambda Developer – Report Generation

Job Title: AWS Lambda Developer – Report Generation Location: USA- Remote Job Description 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).