Time zones: EST (UTC -5), CST (UTC -6), MST (UTC -7), PST (UTC -8), AKST (UTC -9), HST (UTC -10)

• Proactively drive the vision for data foundation and analytics to accelerate building and improvement of cross platform components across Instagram, and define and execute on plan to achieve that vision.
• 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.
• Build cross-functional relationships with Data Scientists, Product Managers and Software Engineers to understand data needs and deliver on those needs.
• 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 use cases across different products or domains.
• Solve our most challenging data integrations 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.

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

• BS/BA in Technical Field, Computer Science or Mathematics.
• 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.