Position: Sr.Data Analyst
Location: Stamford, CT (5 Days onsite)
Duration: Long Term
Coding Test will be there***
Visa: USC, GC or EAD's
Core responsibilities:
- Design, build, and maintain the IW Executive Report covering customers receiving Invincible WiFi service, including metric definitions, report period scoping, and the presentation layer.
- Write production-grade SQL for ad-hoc and recurring analysis: IW customer churn rate, customers impacted by service interruptions caused by fiber cuts, self-service/SSB rates, and adoption funnels.
- Define and implement business logic for new measures, including SI cause classification to isolate fiber-cut-driven interruptions, and identification of customers on fiber equipment at the time of an interruption.
- Partner with the ETL team to get new columns and flags implemented in the warehouse, then validate each layer (source view → staging → dev → production) before release.
- Run ad-hoc investigations across the IW base, such as identifying customers who have not activated their equipment after N days, splitting the base by how they acquired IW (free/promotional offer vs. paid service, and with or without a Service Reliability offer code), measuring SSB rate, and similar one-off questions as they come up from stakeholders.
- Use Kiro extensively to accelerate analysis, logic implementation, and ad-hoc report delivery, cutting turnaround from days to hours.
- Build and maintain the automated refresh pipeline that pulls from Redshift, applies the metric logic, and regenerates the HTML dashboard and Excel deliverables end to end, removing manual report assembly.