Lead Analyst, Analytics (Solutions & Onboarding)

7 Hours ago • 3 Years + • $78,000 PA - $126,500 PA

Job Summary

Job Description

The Lead Analyst, Analytics (Solutions & Onboarding) will provide analytics and technical support for solutions dealing with media performance data, designing scalable ETL architectures and data pipelines. They will collaborate with clients on technical requirements, perform data modeling and schema design, create API integrations, review code, and create technical documentation. The role involves using advanced SQL and scripting languages like Python for data manipulation, visualizing data using Tableau, developing client relationships, and leading a small team of junior associates. This position reports to the VP, Data and Analytics.
Must have:
  • 3+ years experience with Python and SQL programming
  • 3+ years experience with on or multiple cloud platforms
  • Knowledge of BI or digital analytics tools
Good to have:
  • 1+ year experience in Azure Data Factory and Databricks is preferred
  • Experience with media platforms
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

Job Details

Job Description:

This role is remote-friendly.

Lead Analyst, Analytics (Solutions & Onboarding) responsibilities:

  • Provide analytics and technical support for solutions dealing with media performance data both on reporting and analytics side

  • Work with technical lead to design and implement scalable ETL architectures and data pipelines

  • Collaborate directly with clients on technical requirements and solution design

  • Perform data modeling and schema design for efficient data processing

  • Create robust API integrations for real-time data ingestion from various sources

  • Review code and engineering solutions for performance, scalability, and compliance with standards

  • Create comprehensive technical documentation for data pipelines and integrations

  • Design and implement API-based integration solutions

  • 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

Location:

Chicago - N. State

Brand:

Merkle

Time Type:

Full time

Contract Type:

Permanent

Dentsu is committed to providing equal employment opportunities to all applicants and employees. We do this without regard to race, color, national origin, sex , sexual orientation, gender identity, age, pregnancy, childbirth or related medical conditions, ancestry, physical or mental disability, marital status, political affiliation, religious practices and observances, citizenship status, genetic information, veteran status, or any other basis protected under applicable federal, state, or local law. 

 

Dentsu is committed to providing reasonable accommodation to, among others, individuals with disabilities and disabled veterans. If you need an accommodation because of a disability to search and apply for a career opportunity with us, please send an e-mail to ApplicantAccommodations@dentsu.com by clicking on the link to let us  know the nature of your accommodation request and your contact information. We are here to support you.  

Similar Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Similar Skill Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Jobs in Chicago, Illinois, United States

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Similar Category Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

About The Company

For over 120 years, innovation has been a core tenet of our offering – exploring new ways to reach, engage and nurture relationships with audiences. Together we drive a multiplier effect for clients at a global scale, through the development of Integrated Growth Solutions that are underpinned by our promise to clients: innovating to impact. Read MoreBe a force for good. Sustainability is a vital part of our business and an important area of focus for our clients. We’re leading the way – helping to build a more sustainable planet. Dream loud. In this moment of transformation, we need our people to be fearless, embracing change and ambiguity, driven by the love for their work and excitement for the future. Team without limits. We create opportunities for connection and collaboration between our colleagues and clients, building a sense of belonging and having some fun along the way.

Hong Kong (On-Site)

Detroit, Michigan, United States (Hybrid)

Charlotte, North Carolina, United States (On-Site)

Chicago, Illinois, United States (Remote)

Buenos Aires, Buenos Aires, Argentina (On-Site)

Warsaw, Masovian Voivodeship, Poland (Hybrid)

Sofia, Sofia City Province, Bulgaria (Hybrid)

Sofia, Sofia City Province, Bulgaria (Hybrid)

Sofia, Sofia City Province, Bulgaria (Hybrid)

Sofia, Sofia City Province, Bulgaria (Hybrid)

View All Jobs

Get notified when new jobs are added by Dentsu Aegis

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug