Menlo Park, California, US
Facebook's mission is to give people the power to build community and bring the world closer together. Through our family of apps and services, we're building a different kind of company that connects billions of people around the world, gives them ways to share what matters most to them, and helps bring people closer together. Whether we're creating new products or helping a small business expand its reach, people at Facebook are builders at heart. Our global teams are constantly iterating, solving problems, and working together to empower people around the world to build community and connect in meaningful ways. Together, we can help people build stronger communities - we're just getting started.
Every month, billions of people leverage Facebook Inc. products to connect with friends and loved ones from across the world. On the Data Engineering Team, our mission is to support these products both internally and externally by delivering the best data foundation that drives impact through informed decision making. As a highly collaborative organization, our data engineers work cross-functionally with software engineering, data science, and product management to optimize growth, strategy, and experience for our 3 billion plus users, as well as our internal employee community. In this role, you will see a direct correlation between your work, company growth, and user satisfaction. Beyond this, you will work with some of the brightest minds in the industry, and you'll have a unique opportunity to solve some of the most interesting data challenges around efficiency and integrity, at a scale few companies can match. As we continue to expand and create, we have a lot of exciting work ahead of us! This position has a 16-week duration. All candidates are expected to commit to a consecutive 16-week timeframe for successful completion of the program. At the end of the term, those participants who have demonstrated their ability to succeed and make an impact at Facebook will be considered for a full-time position. Roles are filled as candidates are identified. This program is open to all candidates who have relevant professional experience and have been out of the workforce for 2 years or longer immediately prior to the start of the program. New graduates with less than 1 year since matriculation, please apply for open positions through the students and grads career page.
Manage data warehouse development plans (such as scope, timelines, output deliverables) for a product or a group of products.
Collaborate with software engineers, product managers, other data engineers and data scientists to understand data needs.
Build data expertise and own data quality for allocated product areas.
Design, build and launch new data models in production.
Design, build and launch new data extraction, transformation and loading (ETL) processes in production.
Support existing data ETL processes running in production.
Define and manage Service Level Agreements (data availability, data quality etc.) for all data sets in allocated areas of product ownership.
Work with data infrastructure teams to triage infra issues and drive to resolution.
4+ years experience in the data warehouse/reporting space.
4+ years experience in designing, developing, optimizing and maintaining ETL using frameworks and/or programming languages.
4+ years experience in writing SQL statements.
3+ years of coding/development experience (such as Python, Java, C++, Scala etc.).
3+ years experience with schema design and dimensional data modeling.
Experience analyzing data to answer business questions.
Experience managing and communicating data warehouse plans to internal clients.
Must obtain work authorization in the country of employment at the time of hire, and maintain ongoing work authorization during employment.
BS/BA in Technical Field, Computer Science or Mathematics.
Experience working with either a MapReduce or an MPP system.
Experience with database and query performance tuning.
Knowledge and practical application of Python.