Data Analyst

About Optimum Media

Optimum Media is a cutting-edge multiscreen advertising sales and media consultancy committed to serving a wide range of clients from small to medium-sized businesses, national entities, political campaigns, media, entertainment, and agencies throughout the United States. Our diverse team includes professionals across sales, software engineering, data analysis, ad operations, marketing, and product management.

Role Overview

We are looking for a Data Analyst skilled in analytical techniques and emerging data engineering to enhance our reporting, analytics, and data workflow capabilities organization-wide. This role involves collaborating with business and technical teams to conduct data analysis, create automated reporting systems, maintain cloud-based data pipelines, and ensure dependable data infrastructures.

Key Responsibilities

• Craft clear, accurate, and maintainable SQL queries for data extraction, transformation, and analysis.
• Design, implement, and sustain automation of reporting, analytic workflows, and scalable solutions utilizing SQL, Python, and cloud data platforms.
• Address analytical challenges beyond mere reporting, investigating data for insights.
• Proactively detect and initiate improvements in current reporting and analytic processes.
• Formulate hypotheses, validate them analytically, and deliver actionable insights to business stakeholders.
• Partner with senior analysts to assess model effectiveness, identify root issues, and suggest enhancements.
• Execute quality assurance checks to guarantee data integrity, consistency, and reliability across reports and pipelines.
• Own analytical initiatives from the initial data exploration stage through to deployment.
• Work collaboratively with engineering, product development, and business teams to produce scalable analytical solutions.
• Provide ad hoc analysis and support strategic projects as business needs shift.

Qualifications

• Bachelor's degree in Statistics, Mathematics, Computer Science, Economics, or a related discipline.
• Up to 2 years of experience in data analytics, including internships or academic projects.
• Proficient in SQL for data querying and manipulation.
• Experience using Python for data analysis, automation with libraries like pandas, and modeling using scikit-learn.
• Working knowledge of fundamental machine learning concepts such as regression, tree-based models, and model evaluation.
• Familiarity with data warehousing concepts, ETL/ELT methodologies, and cloud data services like Google Cloud, Azure, or AWS.
• Experience with business intelligence tools including Domo, Tableau, and Power BI.
• Excellent communication skills to effectively articulate technical results to non-technical stakeholders.

Additional Information

We are an Equal Opportunity Employer that hires and promotes individuals without regard to gender, race, color, creed, national origin, religion, age, marital status, pregnancy status, disability, sexual orientation, gender identity, military status, or any other protected classifications set by law.

Personal data collected during the hiring process may include identifiers, professional info, photos, education history, and legally protected information to ensure compliance with employment and background screening requirements.

Applicants will never be required to pay money as part of the application or hiring process.

Salary

The annual pay range for this role in New York is expected between $77,112 and $126,684. Compensation depends on relevant skills, experience, and job-related factors.

Eligibility and Work Authorization

Candidates must be authorized to work legally for any employer in the United States; currently, visa sponsorship is not available.