Staff Data Analyst

Optimum•New York, NY

1d•$169,541 - $202,694•Onsite

About The Position

Optimum Media LLC in Long Island City, NY seeks a Staff Data Analyst to engineer advanced data pipelines and build Care and Retention analytics datasets using SQL and Python, leveraging the medallion data architecture to integrate billing, service, and interaction data into retention- and care-ready structures.

Requirements

Bachelor’s degree in Computer Science, Information Technology, Management of Technology, Engineering, or related field
5+ 5 years of experience with the following skills:
Build scalable cloud data pipelines using advanced SQL and DBT
Create and maintain dynamic retention KPIs driven by behavioral signals to detect and enable targeted interventions
Develop Python solutions to integrate multi-source data, automate analytics workflows
Lead customer analytics initiatives using predictive modeling and segmentation to identify attrition drivers
Conduct campaign and pricing analytics to evaluate customer outcomes, ARPU impact, and ROI, and provide insights that guide retention and pricing strategies.
Employer will accept any suitable combination of education, training, or experience.

Responsibilities

Track and analyze retention KPIs such as churn and ARPU trends across time, segmenting by market, product, revenue tier, and acquisition path, and enrich with external firmographic and industry data to produce executive-ready insights and infographics.
Automate Tableau dashboards and executive scorecards using engineered data pipelines, providing real-time visibility into churn, ARPU, and care metrics with drill-downs by geography, product, revenue tier, and customer segment.
Leverage Customer Lifetime Value (CLV) and churn risk models, integrating financial and behavioral data to prioritize retention strategies and maximize revenue yield.
Analyze customer care operations by examining interaction volumes, service efficiency, transfer and repeat behaviors, and task code utilization, and evaluate field service activity and truck rolls to surface inefficiencies, cost drivers, and ARPU erosion risks.
Evaluate rate events and campaigns by measuring offer response, churn, ARPU, and save yields, and assess their impact on Care and Retention KPIs to deliver ROI insights for pricing and retention strategy.
Partner with Finance, Retention, Care, and Product leadership to design and monitor incentive structures that align agent performance with churn-reduction goals, ensure integrity of incentive-driven metrics, and integrate retention and care analytics into strategic planning.
Mentor analysts and enforce best practices in SQL, Python, Tableau, and statistical modeling to ensure scalable, reproducible, and best-in-class retention and care analytics.