Lead Data Analyst, Cloud FinOpsLocation: BengaluruWorking Type: Hybrid – 3 days in office mandateThis role is critical for transforming raw cloud billing data into actionable financial insights. The ideal candidate willpossess advanced data engineering capabilities to integrate various data sources and deep expertise in AWS costand usage reporting to build, maintain, and troubleshoot complex FinOps analytical solutions.Key ResponsibilitiesThe successful candidate will be responsible for filling the identified technical and analytical gaps:1. Data Engineering & Integration (API/ETL) API Development: Design and write production-quality code (e.g., Python, Go) to establish and maintainrobust API connections between internal SaaS products and the FinOps data tool. Ensure data quality, integrity, and timely availability across all integrated sources.2. Advanced AWS Cost Reporting & Analysis Custom Report Generation: Own the end-to-end process of generating complex, custom reports usingAWS Athena and/or Amazon Quicksight to address critical business needs.o Develop data models and write sophisticated SQL queries in Athena for topics such ascontractual commitment tracking, validation of complex cloud charges, and detailed spendattribution.o Design and deliver highly effective Quicksight dashboards and visualizations based on thesecustom datasets. Contract Negotiation Support: Generate validated, specialized datasets and detailed historical analysisusing CUR data to directly support and inform cloud contract negotiations and long-term financialstrategy.3. Reporting Maintenance & Troubleshooting Advanced Troubleshooting: Act as the Tier 3 escalation point for issues with established FinOps reportsand dashboards in Quicksight and other tools. Root Cause Analysis (RCA): Deeply review the underlying Cost and Usage Report (CUR) to identify thespecific line items, billing dimensions, or data transformation steps causing errors or inaccuracies inreports. Solution Implementation: Propose and implement code/query updates and necessary data schemachanges to correct report errors, improve performance, and ensure reporting stability.Required Technical Skills & ExperienceThis role requires a unique combination of engineering and specialized FinOps data expertise.FinOps Data Expertise (Non-Negotiable) In-Depth CUR Knowledge: Demonstrated deep, hands-on understanding of the AWS Cost and UsageReport (CUR) schema, including fields related to pricing, usage types, resources, and billing. AWS FinOps Tools: Expert proficiency with AWS Athena for querying massive datasets and AmazonQuicksight for advanced data visualization and dashboard development. Experience in validating cloud provider charges against contractual agreements and identifying billinganomalies using the raw CUR data.Data Engineering & Programming Expert SQL: Mastery of complex SQL for data transformation, aggregation, and performance tuning(specifically in an Athena/Trino environment). Programming Proficiency: Strong proficiency in a programming language (preferably SQL) for writingintegration code, working with APIs, and developing ETL/data pipelines. Experience with BI/reporting tools and integrating data into internal platforms (APIs, scripts, or ETLpipelines). Familiarity with data warehousing concepts, including partitioning, schema design, and performanceoptimizationGeneral Minimum of 5 years of experience in a Data Analyst, Data Engineer, or Business Intelligence role, withat least 2 years focused specifically on Cloud Financial Management (FinOps). Experience working collaboratively with Finance and Engineering teams to translate business questionsinto technical data solutions.
Job Title
Leading US Based Media Company - Lead Data Analyst, Cloud FinOps