Apply now »

Sr. Data Analyst

Location: 

Long Island City, NY, US, 11101

Brand:  Optimum Media
Requisition #:  10271

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 Summary

We are seeking an experienced Senior Data Analyst to lead data initiatives and deliver actionable insights that drive strategic business decisions. The ideal candidate will be highly proficient in SQL, skilled at working with large-scale datasets and databases, and comfortable using Python for automation, analysis, and data processing. This role requires both strong technical expertise and the ability to collaborate with cross-functional teams.

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.
  • Collaborate with business stakeholders to define data requirements and deliver actionable 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.

Qualifications

  • Bachelor’s or Master’s degree in Statistics, Mathematics, Computer Science, Data Science, Economics, or a related field
  • 3+ years of professional experience in data analysis, business intelligence, or a related role. Media Industry experience is a plus
  • 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.)
  • Excellent research, writing, collaboration and communication skills
  • Ability to work in a team-oriented, fast-paced environment managing multiple priorities

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 $92,534.00 - $152,021.00 / year. The rate/range provided herein is the anticipated pay at the time of hire, and does not reflect future job opportunity.

 

We appreciate your interest in this opportunity. 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.


Nearest Major Market: Brooklyn
Nearest Secondary Market: New York City

Apply now »