Manager, BI Data Engineering
Manager, BI Data Engineering (Foursquare Labs, Inc., Los Angeles, CA)
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).