This job has expired, please see additional jobs below
Business Intelligence - Data Engineer
Yelp
San Francisco, CA, United States
Job Details - this job has expired, please see similar jobs below
Summary
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. We’re looking for someone who has a passion for diving into data, unraveling the complexities, and building powerful business intelligence solutions.
The right candidate will be adept at data warehousing concepts including data profiling and analysis, data extraction and transformation, and dimensional modeling. The ideal candidate also should 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 stakeholders 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, design and implement ETL pipelines, relational and dimensional data models, and other business intelligence infrastructure to address needs.
• Create and distribute documentation and train analysts and other stakeholders.
• Become a subject matter expert on Yelp’s data and share knowledge with other analysts, engineers, and business stakeholders.
• 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 and modeling data in a BI context
• Strong expertise in creating and optimizing complex SQL queries
• Strong expertise in REST, SOAP, and other web API technology
• Strong expertise writing ETL jobs (SnapLogic preferred) and using scripting languages (Python preferred)
• Good understanding of financial management and human capital management systems like Oracle EBS and Workday, and CRM systems like Salesforce is a big plus
• Knowledge of open source technologies like Kafka, Hadoop, Hive, Presto, and Spark is a plus
• Experience with Redshift database administration is a plus
Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.
Yelp values diversity. 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.
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.