Lead Data Analyst

Optimum • New York, NY

5d

About The Position

Introducing Optimum Media. Driven by the power of Optimum, Optimum Media is our innovative multiscreen advertising sales and media consultancy business servicing small to medium business as well as national, political, media & entertainment and agency clients across the United States.

Our team is comprised of Sales Executives, Software Engineers, Data Analysts, Ad Operations, Marketing Professionals, Product Managers and more.

If you are tech-savvy, data-driven, client focused, and solutions oriented this brand is for you!Job SummaryWe are looking for an experienced Lead Data Analyst to join our dynamic and growing data analytics team. This role serves as a critical bridge between data engineering and advanced analytics, with a strong focus on onboarding new data sources, delivering high-quality analytical insights, and supporting clients with data-driven strategies. The ideal candidate is technically proficient, business-savvy, and capable of independently leading analytics projects from data ingestion through to insight delivery. The Lead Data Analyst will play a key role in understanding clients’ business objectives, translating those into data requirements, and transforming complex datasets into meaningful, actionable insights. This role requires deep expertise in accessing, manipulating, and analyzing data from both internal and external sources. In addition to delivering high-impact analysis, the Lead Data Analyst will mentor junior team members, fostering technical and professional growth to support their career development.

Requirements

• Bachelor's /Master’s Degree in Computer Science/Statistics/Information Science/Mathematics or related field or equivalent job experience.
• Minimum 4-6 years’ experience in data analytics/engineering with at least 2 years in a senior or lead role
• Strong SQL and Python programming skills are a mandatory requirement
• Experience working with large datasets and cloud-based enterprise data warehouse (experience with RedShift/Google Big Query/Databricks preferred)
• Hands-on experience with data visualization tools (e.g., Tableau, Domo, Power BI)
• Demonstrated ability to work independently and lead projects from data ingestion to insight delivery
• Strong communication to audience members across all management levels internally and externally
• Proven track record of demonstrating the ability to summarize and present analytic findings

Nice To Haves

• Graduate degree in related field preferred
• Previous background in media analytics in a media agency or organization strongly preferred

Responsibilities

• Act as a technical lead on projects involving data onboarding, processing, and integration across multiple platforms and data sources.
• Own the onboarding and validation of new data sources (1st-, 2nd-, and 3rd-party), ensuring data integrity, accuracy, and readiness for analysis.
• Guide project lifecycles from raw data acquisition through insight generation and strategic recommendation.
• Collaborate with stakeholders to define data requirements aligned with business goals.
• Mentor analysts on technical skills, best practices, and analytic methodologies.
• Design and optimize SQL queries, ETL processes, and data pipelines for performance and scalability.
• Write and maintain Python scripts for automation, data transformation, and API-based data ingestion.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level