Data Analytics Lead

Job Summary

Lead Data Analyst

The Lead Data Analyst is responsible for providing custom analytics for various clients of Optimum Media. This includes multi-screen reporting and attribution analyses, requiring data integration and querying skills to mine for insights across numerous TV & Digital data sources.

Responsibilities

The Lead Data Analyst will be expected to work closely with the Director of Analytics & Insights to lead projects and allocate resources to meet timelines for deliverables. The Lead Data Analyst will also drive innovation within the team by applying creative technical approaches to ensure quality and leading-edge reporting and analytics. This position is also client facing and the Lead Data Analyst will be expected to articulate often complex technical matters in a clear and concise manner as a subject matter expert. This position will act as a technical liaison for other Data Management & Product Development functions within the organization, translating feedback gathered from client exposure in order to develop new analytic product offerings. The Lead Data Analyst will also mentor and develop the skills of Analysts on the team to enhance their career development and build flexibility within the team when managing project workloads.

The Lead Data Analyst will be responsible for understanding the business objectives of Optimum Media clients, mining data and ultimately analyzing, reporting and presenting those findings with actionable insights. To accomplish this, the incumbent must be intimately familiar with both internal and external data sources. The incumbent will need to access raw data via SQL programming and then aggregate to summarize results for use by the analysts and ultimately the clients. The Lead Data Analyst will also be expected to create complex ad hoc reports and analyses which require the use of multiple data stores and to acquire and stage data for use by numerous analysts within and outside the department.  The Lead Data Analyst will analyze and recommend areas for additional analysis and troubleshoot automated processes as necessary.

Qualifications

• Strong SQL and Python programming skills a mandatory requirement

• Bachelor's /Master’s Degree in Computer Science/Computer Engineering/Information Science/Mathematics or related field or equivalent job experience. (Graduate degree in related field preferred)

• Strong understanding of data structures and integration approaches
• Minimum 4-6 years’ experience in data analysis and database systems
• 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 and accuracy.
• 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.

• Familiarity with business intelligence and data visualization software

• Comfortable with communication to audience members across all management levels internally and externally
• Proven track record of demonstrating the ability to summarize and present analytic findings
• Previous background in media analytics in a media agency or organization strongly preferred