Data Analyst

About Insticator

At Insticator, we believe three things – the future of social media is distributed and not siloed in the walled gardens of today; publishers deserve a one-stop shop for maximizing ad revenue; and local brick-and-mortar businesses thrive with digital media automation.

That's why our suite of engagement, ad monetization, and SaaS and media products do just that. Beyond tangible ROI from working with us, the first-party data we collect puts publishers back in the driver's seat to better understand and index audience behavior and allows for extreme precision targeting for the brands we represent.

Insticator's engagement products are geared towards helping publishers establish a strong sense of social community within their ecosystems by enticing users to be more engaged with site content and amongst each other. OKO's ad monetization platform is the ultimate toolkit for publishers. And our newest sister company, Balihoo, supercharges digital media for franchise brands as the leader in multi-location marketing.

We collectively reach over 350 million consumers monthly across our network of premium publishers and advertisers, including Kohler, Pearle Vision, Trek, Ancestry, Investing Channel, Brit+Co, Evolve Media, and many more.

Insticator is proud to be a 6x recipient of the Inc 5000 list of America's fastest-growing private companies, a 2x recipient of Deloitte's Fast 500, recognized on Crain's New York Fast 50 list, recognized by Digiday's Digiday Media Awards as a company working to modernize digital media, and awarded as one of AdWeek's Top 10 Fastest Growing Solution Providers globally.

Insticator’s Core Values

• Sleeves Up: At Insticator, we provide you with the autonomy and creativity needed to own your role. We encourage iteration where necessary so that you can drive massive impact.

• 100% Viewability: Insticator is passionate about open feedback at all levels of the company. This allows us to fail fast, create in real-time, and build an open company culture.

• Be Definitely Great: We're defiant, and that's in our blood. Challenging the status quo is a central part of who we are. We're capable of much more than what others deem impossible.

About the Role

This is an opportunity to join the ad operations team and help company gain more insights from data while supporting stakeholders with their analytical needs. Your day-to-day routine would involve activity tracking, optimization, suggesting improvements to the existing processes based on research. This is a great role for an organized, result driven, enthusiastic analytical person.

We operate with 2000 sites and are focused on increasing their revenue and
engagement. With hundreds of millions of rows of data per day, it is the job of the
analytics team to make sense of the data and visualize it for stakeholders use.

The data analyst will work with fellow teammates on the engineering, ad operations
and account management teams to ensure we:

1. Develop novel and effective analytic approaches

2. Optimize SSP performance

3. Manage UPRs pricing in Google Ad Manager

4. Increase process efficiency and maintain accuracy

5. Maximize the value our clients can derive from our data

Responsibilities and Duties

• • Analyze large sets of data daily using Looker, Tableau
  • ETLs, data preparation using different frameworks and SQL

• Generate suggestions on how to run the processes/ad monetization more efficiently

• Optimize auction floors (Google Ad Manager, SSP/RTB)

• Work with stakeholders to prepare reports that will help them on daily basis

• Maintain set of reports with data being accurate and timely

• Visualize data and make it meaningful

• Collaborate with engineering team to automate daily routine for better efficiency

Qualifications

Professional Competencies

• 2+ years of experience in an analytical position of Advertising-related
  company

• Experience with Google Ad Manager and pricing rules optimization

• Experience with data analysis methods

• Advanced skills in Spreadsheet Software, such as Excel or Google Sheets
  required, including SQL (ability to write complex queries and ETLs)

• Experience with Business Information Software, such as Tableau or Looker
  (with skills of data visualization)

• Strong presentation skills, attention to detail, and communication abilities

• Experience working in a fast-changing environment, adaptability to the
  changes and shifting priorities

• Strong analytical, organizational, and task management skills.

Cultural Competencies

• Must be able to work primarily between the hours of 9:30 AM - 6:30 PM ET

• Must have a player/coach mentality, willing to both execute and lead

• Ability to juggle multiple projects concurrently and set and meet deadlines

• Skilled at receiving and providing direct feedback

• Collaborative mindset and great teamwork skills

• Entrepreneurial & adaptable; great learning skills

• Curious, research-minded, data-informed

• Able to search for possible solutions and apply them

• Creative confidence

• Proactive communicator

• A sense of humor and a love of online culture

• Thrives in a start-up culture

Benefits

• Competitive Salary
• Paid Time Off
• Flexible work schedule