Lead Analyst, Analytics (Solutions & Onboarding)

About the Role

Key Responsibilities

• Provide analytics and technical support for solutions dealing with media performance data both on reporting and analytics side
• Use advanced SQL (view tables, CTEs, multi-table joins) to automate data manipulation
• Create ETL processes in high-level scripting languages (e.g. Python) to pull and refresh data from media APIs
• Use Tableau to visualize client data, highlighting key metrics and insights
• Develop relationships with client partners, and communicate/interpret results in meetings with clients
• Lead a small team of junior associates, overseeing their day-to-day work, providing direction, and administering feedback

Requirements

• 3+ years experience with Python and SQL programming
• 3+ years experience with on or multiple cloud platforms (Google, Snowflake, and Azure)
• 1+ year experience in Azure Data Factory and Databricks is preferred
• Knowledge of BI or digital analytics tools (Tableau, MicroStrategy, Adobe Analytics, Google Analytics, DMP insight tools)
• Experience with media platforms (Google Ads, Facebook, Campaign Manager, etc.) and site analytics platforms (Google Analytics, Adobe, etc.)
• Ability to analyze/synthesize data to provide insights with recommendations/action
• Understanding of digital data including the systems and processes used to generate and manipulate it by media type web, ad, email, mobile, etc.

Nice to Have

• Experience in Azure Data Factory and Databricks

Qualifications

• No specific formal educational qualifications specified in the description

Benefits & Perks

• Medical, vision, and dental insurance
• Life insurance
• Short-term and long-term disability insurance
• 401k
• Flexible paid time off
• At least 15 paid holidays per year
• Paid sick and safe leave
• Paid parental leave