Optimum Media is looking for an experienced Lead Data Analyst to bridge the gap between data engineering and advanced analytics, focusing on onboarding new data sources, delivering high-quality analytical insights, and supporting clients with data-driven strategies.
Requirements
- 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)
- 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.
- Hands-on experience with data visualization tools (e.g., Tableau, Domo, Power BI)
- Minimum 4-6 years’ experience in data analytics/engineering with at least 2 years in a senior or lead role
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.
Other
- Bachelor's /Master’s Degree in Computer Science/Statistics/Information Science/Mathematics or related field or equivalent job experience. (Graduate degree in related field preferred)
- 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
- Previous background in media analytics in a media agency or organization strongly preferred
