Optimum Media is seeking an experienced Senior Data Analyst to lead data initiatives and deliver actionable insights that drive strategic business decisions.
Requirements
- Strong coding skills in SQL, with experience handling large-scale relational databases
- Programming skills in Python, with experience in data manipulation, automation, and advanced analytics
- Solid understanding of ETL processes, data modeling, and data warehouse design
- Proficiency in BI reporting tools such as Domo, Tableau, Power BI, or Looker
- Experience with cloud platforms (Google Cloud, AWS, etc.) and modern data stack tools (dbt, Airflow, Git, etc.)
Responsibilities
- Design, develop, and optimize complex SQL queries to extract, transform, and analyze large datasets.
- Work with large relational and cloud-based databases (e.g., BigQuery, Snowflake, Redshift).
- Build and maintain data workflows to ensure data accuracy and availability.
- Leverage Python (pandas, NumPy, etc.) for advanced analytics and automation.
- Develop dashboards and reports using BI tools to visualize and communicate insights.
- Monitor data quality, troubleshoot anomalies, and propose improvements in data processes.
- Contribute to strategic decisions by identifying opportunities for business growth and process optimization.
Other
- 3+ years of professional experience in data analysis, business intelligence, or a related role.
- Media Industry experience is a plus
- Excellent research, writing, collaboration and communication skills
- Ability to work in a team-oriented, fast-paced environment managing multiple priorities
- Applicants must be authorized to work for ANY employer in the U.S. Please note that at this time, we do not provide visa sponsorship for employment.
