Database & Business Intelligence Developer, Digital Advertising

Location: Los Angeles, CA

Department: Analytics and Data Infrastructure

Type: Full Time

Min. Experience: Mid Level

Come party with a million people a day in celebrating important events in their lives! Evite, the world’s leading digital platform, is looking for passionate and creative Database & Business Intelligence Developer, Digital Advertising to join our team in Los Angeles. We are looking for people who will contribute to our mission of bringing people together to celebrate their most important life moments.

Evite’s Analytics & Data Infrastructure team is seeking a Database & Business Intelligence Developer, Digital Advertising to support the Digital Advertising Sales/Ad Operations aspects of our business.

CORE CAPABILITIES

  • Proven track record defining Digital Advertising business objectives and transforming them into database and Business Intelligence solutions, including mapping data from various source systems into a unified Ad Tech database
  • Proven track record working collaboratively with business stakeholders in Ad Tech/Sales to create data-driven solutions that drive value for the business and advertising clients.  Ability to see the business challenge behind data & analytics challenges
  • Proven track record as a power user of Tableau (or similar Business Intelligence tool), SQL and Ad Tech platforms (DoubleClick preferred)

THE 3C'S (Candidate must have all three C’s)

  • Communication - You’re an eloquent speaker who can explain anything to everyone. You are also a clear and concise writer.
  • Critical thinking - You love logic and data. Thinking strategically is your forte. You enjoy diagnosing complex problems and formulating plans of attack to resolve them. You enjoy an environment where everyone is encouraged to add value at the most strategic level.
  • Cultural fit - You have a craving to fit in a fast-paced, high-integrity, low hand-holding environment (but you will get a hug if you need it). EQ as important as IQ. Bullies need not apply. You want to help bring our “What If” philosophy to life.

RESPONSIBILITIES

  • Maintain our Digital Advertising database mapping data from transactional source systems into tables optimized for Business Intelligence reporting. 
    • Maintain ETL pipelines, including: SQL scripts, ODBC connections and API calls. 
    • Define KPIs & business requirements and build advanced SQL queries, tables and views and to support Tableau dashboards and ad hoc reporting.
    • Identify and resolve bugs in the data and database scripts that are causing errors in our automated dashboards.
  • Work collaboratively with our Advertising/Sales team to advise Sales staff and clients on how to best use data and Business Intelligence tools to achieve their advertising goals
  • Subject Matter Expert (SME) on Ad Tech data and processes to both translate business processes and goals into data solutions and communicate the capabilities and constraints of data solutions to the non-technical business stakeholders
  • Create Tableau dashboards/reports and maintain our library of self-serve Tableau dashboards to support business users in the Sales and Ad Operations teams
  • Use analytical tools (e.g. Google Analytics, Salesforce Analytics, comScore)
  • Help the Ad Sales & Strategy teams tell stories with data to close ad sales and support advertiser clients

OTHER PREFERRED REQUIREMENTS

  • Master’s Degree in Engineering, Computer Science or similar with an emphasis on databases and analytics
  • 3+ years of experience with SQL – advanced SQL skills a must (SQL Server and RedShift preferred)
  • 3+ years of experience supporting digital advertising with all data and analytics needs, preferably in high data volume environments
  • 3+ years of experience with Tableau (or similar BI platform).  Ideally a Tableau power user
  • Strong experience with data modeling, data warehousing and ETL
  • Strong Experience with DoubleClick Platform - SSP/DSP data and reporting, programmatic advertising a strong plus
  • Experience with Google Analytics (or similar) a strong plus
  • Experience with Salesforce Analytics and comScore (or similar) a strong plus
  • Shell scripting and knowledge of command line utilities a plus
  • Knowledge of Python and/or R a plus
  • MS-Excel and PowerPoint skills

Note: No relocation assistance provided for this position. Duties, responsibilities, and activities may change at any time with or without notice. Evite, Inc. is committed to equal employment opportunity and values a diverse workforce. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or perception, national origin, age, marital status, disability, veteran status, genetics or other legally protected characteristics.

 

Apply for this Position
* Required fields
First name*
Last name*
Email address*
Location
Phone number*
Resume*

Attach resume as .pdf, .doc, .docx, .odt, or .rtf (limit 5MB) or paste resume

Paste your resume here or attach resume file

Cover Letter
In 150 characters or fewer, tell us what makes you unique. Try to be creative and say something that will catch our eye!*