Optimum

Compensation

Full Description

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 a Data Analyst with strong analytical and emerging data engineering skills to support reporting, analytics, and scalable data workflows across the organization. This role will partner with business stakeholders and technical teams to analyze data, develop automated reporting solutions, support cloud-based data pipelines, and help maintain reliable data infrastructure. The ideal candidate is comfortable working with SQL, cloud data warehouses, and automation tools while continuing to grow technical engineering capabilities.Responsibilities Write and maintain basic to intermediate SQL queries to extract and analyze data.  Assist in optimizing SQL queries, database structures, and reporting processes for performance and efficiency Work with cloud-based data warehouse environments such as BigQuery, Snowflake, or Redshift to support scalable analytics solutions.  Assist in designing, developing, and maintaining scalable ETL/ELT data pipelines and automated workflows supporting analytics and reporting use cases Utilize Python (e.g., pandas, scripting libraries) to automate data processing, reporting workflows, and data quality validation tasks Maintain and update recurring reports (e.g., performance, revenue, pacing, costs) using Excel, DOMO, SQL, and other toolsMonitor and troubleshoot data ingestion workflows, scheduled jobs, and pipeline execution issues to ensure data reliability and operational continuity Collaborate with engineering, product, and business teams to translate reporting and analytical requirements into scalable technical solutions Assist the operations team, programmatic team, and data strategy team with reporting requests and data analysis to monitor costs and performance trends Help automate data ingestion, transformation, and reporting processes while maintaining data accuracy, consistency, and governance standards Conduct quality checks to ensure data integrity and consistency across reports Support cross-functional teams by pulling data and preparing insights to meet business needs Assist with ad-hoc analysis and special projects as assigned Qualifications Bachelor’s degree in Statistics, Mathematics, Computer Science, Economics, or a related field 0–2 years of experience in data analysis, internships, or relevant coursework/projects Basic-to-intermediate SQL skills Exposure to cloud platforms such as Google Cloud Platform (GCP), AWS, or Azure preferred Understanding of data warehousing concepts, ETL/ELT processes, relational database design, and data transformation best practices Familiarity with Excel for data analysis and reporting Strong attention to detail and willingness to learn Good communication and teamwork skills Ability to manage multiple tasks in a fast-paced environment Experience with BI tools (e.g., Domo, Tableau, Power BI, or Looker) is a plus Familiarity with Python for data analysis (e.g., pandas) is a plus Familiarity with data quality validation, monitoring, and troubleshooting techniques is a plus 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 $77,112.00 - $126,684.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.