Recently postedTechnology

Sr Data Analyst :: Stamford, CT (Only Locals)

Reliable Software ResourcesStamford, CT🇺🇸United States

Quick overview

SeniorityMid Senior

Work modeHybrid

LocationStamford, CT, United States

FiberSQLMicrosoft ExcelHTMLETLAssemblyRedshift

Job Role: Sr Data Analyst

Location: Stamford, CT

Hiring-Type: Contract

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.