Business Intelligence - Data Engineer

Yelp, San Francisco, CA

Connecting people with great local businesses

Are you passionate about diving into data, unraveling the complexities, and building powerful business intelligence solutions?

Yelp’s Business Intelligence and Data Integration team works with groups throughout the organization and data from an array of diverse sources. The team creates business intelligence solutions that enable business leaders to make quicker, more informed decisions.

You might be a great fit for this role if you are adept at data warehousing concepts including data profiling and analysis, data extraction and transformation, and dimensional modeling. You should also be very comfortable working with multiple teams and various levels of management to explore opportunities, elicit requirements, and collaborate on reporting and analytics projects.

What You Will Do:

  • Partner with business partners to understand data needs, how business processes are accomplished in various data systems, business rules and definitions, and current data and reporting challenges.
  • Analyze source system data and design and implement ETL pipelines, relational and dimensional data models, and other business intelligence infrastructure to address needs.
  • Create and distribute business and technical documentation and train analysts, engineers and business partners.
  • Become a subject matter expert on Yelp’s data and share knowledge with analysts, engineers, and business partners.
  • Explore emerging trends and new technologies to continue to improve Yelp’s business intelligence capabilities.

We Are Looking For:

  • Degree in Computer Science or related field.
  • 3+ years professional experience building ETL jobs, performing dimensional modeling, and using SQL/scripting languages in a BI context.
  • Excellent working experience creating and optimizing complex SQL queries.
  • Excellent working experience writing ETL jobs (SnapLogic preferred) and using scripting languages (Python preferred).
  • Working experience with REST, SOAP, and other web API technology.
  • Good understanding of financial management and human capital management systems like Oracle EBS and Workday, and CRM systems like Salesforce.
  • Knowledge of open source technologies like Kafka, Hadoop, Hive, Presto, and Spark is a plus.
  • Experience with Redshift database administration is a plus.

At Yelp, we believe that diversity is an expression of all the unique characteristics that make us human: race, age, sexual orientation, gender identity, religion, disability, and education — and those are just a few. We recognize that diverse backgrounds and perspectives strengthen our teams and our product. The foundation of our diversity efforts are closely tied to our core values, which include “Playing Well With Others” and “Authenticity.”

We’re proud to be an equal opportunity employer and consider qualified applicants without regard to race, color, religion, sex, national origin, ancestry, age, genetic information, sexual orientation, gender identity, marital or family status, veteran status, medical condition or disability.

Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

We are committed to providing reasonable accommodations for individuals with disabilities in our job application process. If you need assistance or an accommodation due to a disability, you may contact us at [email protected] or 415-969-8488.

Note: Yelp does not accept agency resumes. Please do not forward resumes to any recruiting alias or employee. Yelp is not responsible for any fees related to unsolicited resumes.

About Yelp

Yelp connects people with great local businesses. Our users have contributed approximately 127 million cumulative reviews of almost every type of local business, from restaurants, boutiques and salons to dentists, mechanics, plumbers and more. These reviews are written by people using Yelp to share their everyday local business experiences, giving voice to consumers and bringing “word of mouth” online.

Want to learn more about Yelp? Visit Yelp's website.