Sr. Business Insights (BI) & Analytics Engineer

Yahoo Mail is the ultimate consumer inbox with hundreds of millions of users. It’s the best way to access your email and stay organized from a computer, phone or tablet. With its beautiful design and lightning fast speed, Yahoo Mail makes reading, organizing, and sending emails easier than ever.

About the Role

At Yahoo, we connect the world through our daily habits. Yahoo Mail is a core part of this mission, serving 200 million monthly active users and generating terabytes of data daily, with a mission to be the best platform to help our users manage their “business of life.” 

As a Senior BI & Analytics Engineer on the Mail Data & Analytics team, you'll be instrumental in building the critical analytics systems and pipelines that power our analytics and BI programs.

You will work at an immense scale, tackling complex technical challenges in areas like efficient query processing and advanced analytics. This is a role for someone who is passionate about harnessing data at a petabyte scale to provide timely and accurate insights to executives, product managers, and developers.

A Little About You

As part of the Mail Data & Analytics Engineering team, you will be responsible for designing, building, and maintaining our analytics data models and pipelines. You'll ensure our stakeholders have fast, reliable, and trustworthy data to drive strategic decisions and optimize our products. We are looking for a self-driven, detail-oriented, and collaborative individual who thrives on solving complex challenges and is passionate about data and its applications.

Your Responsibilities

• Data Modeling & Transformation: Architect, develop, and maintain a robust and scalable data warehouse. You will create and optimize complex data models to transform massive volumes of raw data into a clean, well-defined, and business-ready "single source of truth."

• Analytics Engineering & BI: Design and build our analytics semantic layer to provide a consistent and governed view of our data. You'll define key metrics, dimensions, and business logic to power our BI platform and ensure data integrity.

• Pipeline & ELT Development: Build, manage, and optimize data pipelines to ingest, clean, and enrich data from various sources. You'll ensure data freshness, accuracy, and reliability across all mission-critical data systems.

• Advanced Analytics & Engineering: Develop complex queries, analytics applications, and software programs to solve advanced analytics and data mining problems. This may involve prototyping new metrics, troubleshooting data issues, and contributing to our next-generation AI-based analytics products.

• Collaboration & Communication: Partner with data analysts, data scientists, product managers, and software engineers to understand business requirements and deliver effective data solutions. You will champion data quality and governance, and provide engineering consultation on complex BI & analytics projects.

You Must Have

• Experience: 6+ years of experience in a business intelligence, analytics engineering, or data engineering role within a fast-paced internet or tech company.

• Technical Expertise:

  • Expert-level SQL: Highly proficient in writing complex, performant, and well-structured SQL.

  • Data Warehousing: Strong, hands-on experience with a modern cloud data warehouse (e.g., Google BigQuery).

  • BI Tools: In-depth experience with BI platforms, with a strong focus on Looker (LookML development, administration, and optimization).

  • Google Cloud Platform (GCP): significant experience working on GCP

  • Programming: proficiency in Python/Java for data scripting and automation.

  • Experience with modern pipeline orchestration tools like Airflow.

• Skills:

  • Demonstrated ability to translate complex business needs into data models and reporting solutions.

  • Strong understanding of product analytics and business metrics.

  • Solid fundamentals in algorithms and data structures.

  • Exceptional communication skills, with the ability to bridge the gap between technical data teams and business stakeholders.

  • A proactive, self-driven, and collaborative attitude with a passion for enabling data users.

Preferred Qualifications

• BS/MS/PhD in Computer Science, Electrical Engineering, or a related engineering discipline.

• Experience with embedded analytics or API integrations.

• Experience in UI frameworks such as React a plus

• Familiarity with data governance principles and privacy regulations.

• Exp