Data Engineer, Analytics

Every month, billions of people leverage Facebook 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 a Generalist, you are adaptable and a flexible problem solver with technical expertise, analytics skills, and product sense to successfully pivot/context-switch amongst many projects with a variety of scale and complexity. With your breadth of knowledge, you are often sought after for guidance and mentorship as well. As we continue to expand and create, we have a lot of exciting work ahead of us!

• Conceptualize and own the data architecture for multiple large-scale projects, while evaluating design and operational cost-benefit tradeoffs within systems.
• Create and contribute to frameworks that improve the efficacy of logging data, while working with data infrastructure to triage issues and resolve.
• Collaborate with engineers, product managers, and data scientists to understand data needs, representing key data insights visually in a meaningful way.
• Define and manage SLA for all data sets in allocated areas of ownership.
• Determine and implement the security model based on privacy requirements, confirm safeguards are followed, address data quality issues, and evolve governance processes within allocated areas of ownership.
• Design, build, and launch collections of sophisticated data models and visualizations that support multiple use cases across different products or domains.
• Solve our most challenging data integration problems, utilizing optimal ETL patterns, frameworks, query techniques, sourcing from structured and unstructured data sources.
• Assist in owning existing processes running in production, optimizing complex code through advanced algorithmic concepts.
• Optimize pipelines, dashboards, frameworks, and systems to facilitate easier development of data artifacts.
• Influence product and cross-functional teams to identify data opportunities to drive impact.
• Mentor team members by giving/receiving actionable feedback.

• 5+ years experience in the data warehouse space.
• 5+ years experience in custom ETL design, implementation and maintenance.
• 5+ years experience with object-oriented programming languages.
• 7+ years experience with schema design and dimensional data modeling.
• 7+ years experience in writing SQL statements.
• Experience analyzing data to identify gaps and inconsistencies.
• Experience managing and communicating data warehouse plans to internal clients.
• Bachelor's degree in Computer Science, Computer Engineering, relevant technical field, or equivalent practical experience.

• Experience working with either a MapReduce or an MPP system.
• Knowledge and practical application of Python.
• Experience working autonomously in global teams.
• Experience influencing product decisions with data.