Location: Long Island City,NY, USA
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
The Data Solutions Team is a core part of Optimum Media. Our team incorporates data engineering, data management, data onboarding and data analysis into a singular group. We are the data specialists that ensure the highest operational efficiency of reporting and analytics within the organization.
The Data Analyst will be responsible for working with various data sets utilizing advanced scripting and SQL queries to support Data Solutions team initiatives including, but not limited to custom onboarding, custom segmentation, data quality and ad hoc requests. The Data Analyst will ensure compliance with Data Solutions team requirements by extracting data and performing data quality audits and analyses. Further, the Data Analyst will begin to apply statistical modeling and simple machine learning techniques under supervision, aiming to identify trends and insights that can inform campaign strategies and customer segmentation. This position will require interacting across teams, including Client Services, Data Management, Engineering and Product and will require the ability to effectively communicate often complex data analytics to a variety of audiences.
Responsibilities
Work with large data sets in an advanced database structure (Google BigQuery, Snowflake, Redshift, etc).
Write advanced SQL queries for data analysis and reporting, and build Python scripts for process automation and data modeling.
Identify automation opportunities within current analytics processes and work closely with EIT to implement the solution.
Actively research and stay informed about the latest trends in data analytics. Experiment with new methodologies and tools to enhance analytical capabilities and provide innovative solutions.
Produce information/datasets which can be turned into client-facing materials for mid- to senior-management.
Onboard and investigate data from multiple sources, identify and trouble-shoot issues that reside in first-party and third-party datasets.
Document development of information, data architecture and process flows.
Well versed with coding best practices and initiate implementation of such practices to close out any gaps and drive efficiency.
Qualifications
Bachelor's /Master's Degree in Data Science/Statistics/Computer Science/Computer Engineering/Information Science/Mathematics or equivalent job experience. (Graduate degree in related field preferred)
1-2 Years minimum relevant working experience in a data driven environment required
Strong SQL programming skills, data structure in relational databases, data manipulation and transformation knowledge required
Intermediate proficiency programming in Python with a strong focus on data extraction, manipulation, and model testing
Basic to intermediate knowledge of statistical modelling and machine learning techniques (such as hypothesis testing, regression, logistic regression, random forest, etc.)
Advanced Excel, data visualization or dashboarding skills preferred
Experience working cloud-based technologies, preferably AWS EC2 and Compute Engine etc. a plus
Excellent communication and presentation skills with the ability to translate business objectives into technical requirements and communicate with various teams and stakeholders
Excellent problem-solving skills, research-oriented mindset with a continuous desire to learn and apply new analytics methodologies
Experience working in Media, Television or Digital Marketing, 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 FAQfor further details.
This position is identified as being performed in/or reporting to company operations in New York State. Salary ranges are supplied in compliance with New York State law. 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 are an Equal Opportunity Employer M/F/Disability/Vet and maintain a drug-free and smoke-free workplace
Minimum Salary: 31200.00 Maximum Salary: 31200.00 Salary Unit: Yearly