Manager, BI Data Engineering (Foursquare Labs, Inc., Los Angeles, CA)

Los Angeles

Applications have closed

Foursquare

Foursquare provides businesses with the opportunity to list on City Guide, & consumers can search for places they love.

View company page

Use strong communication skills (verbal and written) to work closely with a range of stakeholders and team members to understand and finalize their business requirements for reporting and data aggregations. Design, develop, and maintain analytical databases based on business requirements. Design, develop, and test ETL (extract, transform, load) and ELT (extract, load, transform) data workflows from a variety of data sources. Perform hands on implementation and maintenance of production ETL processes. Write and tune structured query language (SQL) and other types of queries to support internal customer requests. Support ad-hoc data analysis requests. Audit quality and repair data from data sources for accuracy. Design schemas, import (ETL) processes, and establish proper indexing or data warehousing approaches to power insights and analytics. Design metrics, aggregations, and sampling techniques from our data repositories to help answer critical business questions that will guide product and investment decisions.

MINIMUM REQUIREMENTS: Bachelor’s degree or U.S. equivalent in Electronics Engineering, Computer Science, or related field, plus 5 years of professional experience performing and maintaining production warehouse and ETL pipelines (including building, designing, developing, testing, and implementing production ETL processes) to perform data analytics. Must also have the following: 3 years of professional experience using a programming language (including Python, Scala, SQL, or Java); 2 years of professional experience analyzing database platforms to devise business intelligence platform architectures and recommend optimization; 1 year of professional experience with cloud data infrastructure to maintain data architecture code; 1 year of professional experience designing and developing data marts, meta data, and data models for postgres relational database (including defining logical and physical design).

CONTACT: Please submit resume online at: https://foursquare.com/careers or email resume to: recruiting@foursquare.com.  Please specify ad code KSAP. EOE. MFDV.

Tags: Business Intelligence Computer Science Data analysis Data Analytics Data Warehousing ELT Engineering ETL Pipelines PostgreSQL Python Scala SQL Testing

Region: North America
Country: United States
Job stats:  12  1  0

More jobs like this

Explore more AI, ML, Data Science career opportunities

Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.