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. $169,541/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 $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.
Nearest Major Market: Brooklyn
Nearest Secondary Market: New York City
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. $169,541/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 $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.
Nearest Major Market: Brooklyn
Nearest Secondary Market: New York City
Similar Jobs at Optimum
AdTech • Digital Media • Internet of Things • Marketing Tech • Mobile • Retail • Software
Design, develop, and maintain AI-driven software applications. Collaborate on feature development, optimize model performance, and enforce coding standards within Agile teams.
Top Skills:
APIsDialogflowGitGoogle CesGCPGrpcJavaScriptNode.jsPythonRest
AdTech • Digital Media • Internet of Things • Marketing Tech • Mobile • Retail • Software
Manage small-to-medium customer experience, operations, field service, sales, marketing or product release projects. Own scope, cost, schedule, risks, resources, communications and change control; coordinate cross-functional teams to deliver projects on time, on budget, and with required functionality.
Top Skills:
AgileChatbotsExcelIvrMedalliaMessagingMicrosoft ProjectMicrosoft TeamsPowerPointSharepointSmartsheetsSmsVerintVisioWaterfall
AdTech • Digital Media • Internet of Things • Marketing Tech • Mobile • Retail • Software
Sell Optimum connectivity products (internet, voice, TV) to enterprise customers, develop new and existing accounts, meet monthly quotas, use Salesforce for CRM, submit forecasts and reports, collaborate with operations, complete required training, and maintain strong customer relationships.
Top Skills:
Coax (Coaxial Internet)Database ToolsInformation TechnologySales Force AutomationSalesforceTelecommunications
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
