Chicago - N. State
17 days ago
Lead Analyst, Analytics (Solutions & Onboarding)

This role is remote-friendly.

The Lead Analyst, Analytics (Solutions & Onboarding) position 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

You will report to VP, Data and Analytics

Qualifications:

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, Micro strategy, 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.

The annual salary range for this position is $78,000-$126,500. Placement within the salary range is based on a variety of factors, including relevant experience, knowledge, skills, and other factors permitted by law.

Benefits available with this position include:

• 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, and

• Paid parental leave.

Dentsu also complies with applicable state and local laws regarding employee leave benefits, including, but not limited to providing time off pursuant to the Colorado Healthy Families and Workplaces Act, in accordance with its plans and policies. For further details regarding Dentsu benefits, please visit www.dentsubenefitsplus.com.

To begin the application process, please click on the “Apply” button at the top of this job posting. Applications will be reviewed on an ongoing basis, and qualified candidates will be contacted for next steps.

#LI-Remote

#LI-AB2

Confirm your E-mail: Send Email