Data & Analytics
Chicago

Data Analyst Lead

Why join frog?

Joining frog means you’ll be joining the “pond,” a global network of studios, each with a thriving in-person and vibrant virtual culture. As a leading global creative consultancy that is part of Capgemini Invent, frog challenges the status quo to craft and build transformative human experiences that win hearts and move markets. Partnering with passionate leaders and visionary entrepreneurs, we apply creativity, strategy, design and data to re-invent businesses, drive growth and orchestrate customer-centric transformation. Together we strive to shape a regenerative future that is both sustainable and inclusive for businesses, people and planet. Our culture is open, flexible, inclusive and engaging. Working at frog means being empowered to Make Your Mark on every project, in your studio, your community—and the world at large.

What will you be doing? 

As a Data Analyst Lead, you will provide extensive troubleshooting and technical expertise in identifying data issues that impact data metrics. The Data Analyst Lead will solve data discrepancies and provide business intelligence insights. Additionally, the Data Analyst Lead will monitor data extract, transform, load (ETL) jobs and respond to any job failures. 

Technical skills: 

  • Good Microsoft SQL & ETL skills (like MSBI stack)
  • Working knowledge of Microsoft PowerBI 
  • Strong data analytical skills 
  • Ability to make business conclusions from data, connect scenarios & provide solutions  
  • Strong knowledge on Excel – Pivots, PowerPivots, Charts  
  • Understanding Data Management & BI concepts, Data Analysis, Analytics, Cubes, Reporting Technologies, ETL 
  • Stakeholder management - Clients, Partners, Offshore,..
  • Good to have Prior experience in Microsoft landscape
  • Must have 5 years of related experience.

Responsibilities include:  

  • Troubleshoot complex data related issues escalated from Tier 1
  • Application and database testing after releases
  • Provides extensive troubleshooting and technical expertise in identifying data issues that impact data metrics. 
  • Gather and Confirms project requirements by studying user requirements; conferring with others on project team. 
  • Provides support to the users on any data related questions/issues reported. 
  • Maintains client confidence and protects operations by keeping information confidential 
  • Documenting the different processes 
  • Solving data discrepancies and providing business intelligence insights.  
  • Monitor data extract, transform, and load (ETL) jobs and respond to any job failures. 
  • Flexibility to support production issues during off hours 
  • Ability to improve existing processes, build tools to automate 

Equal Opportunities at frog

frog is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status, or any other characteristic protected by law.

frog is a global business with teams working across the world. To help us process your application, please ensure that your application documents (CV, cover letter, portfolio, etc.) are all in English.