Data Analyst - Stamford, CT- onsite -W2 - Tele communications domain mandatory

Position: Data Analyst - Tele communications domain

Location: Stamford, CT

Duration: Longterm

Description: Strong Data/BI Analyst with Data Engg/SQL exp.

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.