The Staff Data Analyst will build data pipelines analyze retention metrics and automate dashboards while mentoring other analysts in SQL Python and Tableau.

Are you looking to Optimize your life? Start your exciting path to a rewarding career today!
We are Optimum a leader in the fast-paced world of connectivity and we're seeking driven and enthusiastic professionals to join our team empower lives fuel businesses and drive innovation. Connectivity is now longer a luxury but a necessity. A career at Optimum means you'll be enabling progress and enhancing lives by providing reliable high-speed connectivity solutions that keep the world connected. Our successes now and in the future are powered by our amazing product a commitment to our people and culture and the connections we make in our communities.
If you are resourceful collaborative and passionate about delivering consistent excellence Optimum is for you!
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. $169541/yr. Email resume to [email protected] and ref: Staff Data Analyst. 40 hrs./wk 9:00-5:00.
At Optimum every action and interaction we take part in is driven by our three Guiding Principles: Do What's Right Drive One Optimum and Make It Happen. These aren't just words they help us build trust create real community and embrace new ways of thinking. Our employees are empowered to do the right thing for our customers and co-workers and to recognize and reward these behaviors when we see them. It's all part of the bigger picture of "Be The Difference" where each employee knows they have the power to enact real change share new ideas and understand that learning never stops.
If you have the drive to succeed and are ready to embark on a thrilling career seize this opportunity today and join our winning team. Together we'll shape the future of connectivity.
All job descriptions and required skills qualifications and responsibilities for a particular position are subject to modification by the Company from time to time in the Company's discretion based on business necessity.
We are an Equal Opportunity Employer committed to recruiting hiring and promoting qualified people of all backgrounds regardless of gender race color creed national origin religion age marital status pregnancy physical or mental disability sexual orientation gender identity military or veteran status or any other basis protected by federal state or local law.
The Company collects personal information about its applicants for employment that may include personal identifiers professional or employment related information photos education information and/or protected classifications under federal and state law. This information is collected for employment purposes including identification work authorization FCRA-compliant background screening human resource administration and compliance with federal state and local law.
Applicants for employment with The Company will never be asked to provide money (even if reimbursable) as part of the job application or hiring process. Please review our Fraud FAQ for further details.
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 $169541 - $202694.00 / year. The rate/range provided herein is the anticipated pay at the time of hire and does not reflect future job opportunity.
Nearest Major Market: Brooklyn
Nearest Secondary Market: New York City