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. frogs are curious, collaborative, and courageous, united by our passion for improving the human experience through design, while each bringing our unique and diverse skills and experiences to the table. We draw on our global reach and local knowledge to solve complex problems and design innovative, sustainable solutions that touch hearts and move markets. frogs prize humour, positivity, and community just as highly as performance and outcomes. 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.