Job Summary

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.

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.

Qualifications

Bachelor'sdegree 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; and 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. $169,541/yr. Email resume to [redacted] and ref: Staff Data Analyst. 40 hrs./wk, 9:00-5:00.

Pay is competitive and based on a number of job-related factors, including skills and experience. The starting pay rate/range at time of hire for this position in the posted location is $169,541 - $202,694.00 / year. The rate/range provided herein is the anticipated pay at the time of hire, and does not reflect future job opportunity.