Sr. Data Scientist - Gen AI Automation

About Pinterest: Millions of people around the world come to our platform to find creative ideas, dream about new possibilities and plan for memories that will last a lifetime. At Pinterest, we’re on a mission to bring everyone the inspiration to create a life they love, and that starts with the people behind the product. Discover a career where you ignite innovation for millions, transform passion into growth opportunities, celebrate each other’s unique experiences and embrace the flexibility to do your best work. Creating a career you love? It’s Possible. At Pinterest, AI isn't just a feature, it's a powerful partner that augments our creativity and amplifies our impact, and we’re looking for candidates who are excited to be a part of that. To get a complete picture of your experience and abilities, we’ll explore your foundational skills and how you collaborate with AI. Through our interview process, what matters most is that you can always explain your approach, showing us not just what you know, but how you think. You can read more about our AI interview philosophy and how we use AI in our recruiting process here. Are you passionate about applying GenAI to improve efficiency and accelerate business execution—grounded in strong data foundations? Join Pinterest’s IT Enterprise Systems team to build analytics engineering and GenAI capabilities that power our go-to-market and corporate operations. You’ll create trusted data models and pipelines across core enterprise platforms and layer in LLM-enabled workflows with clear evaluation, observability, and guardrails. What you'll do:

• Build production-grade GenAI-enabled analytics solutions that integrate enterprise data sources (e.g., Salesforce, Gong, Oracle, IBM Planning Analytics, and other SaaS platforms).
• Establish end-to-end LLM pipelines (retrieval/orchestration) with evaluation frameworks, observability, and validation guardrails to ensure reliability and safety.
• Lead technical scoping for GenAI use cases, assessing feasibility, accuracy expectations, risk, and ROI—then translating into clear technical plans.
• Design and own analytics-ready data models, including dimensional modeling (star schemas, fact/dimension tables, SCD Type 2) that support reporting, forecasting, and downstream applications.
• Develop and maintain robust data pipelines and orchestration (Airflow and/or dbt or similar), including data quality checks, SLAs, monitoring, and failure recovery.
• Write and optimize complex SQL for transformation and analysis across enterprise datasets (joins, window functions, CTEs, performance tuning).
• Partner closely with business stakeholders, turning ambiguous questions into well-scoped requirements, success metrics, and deliverables; communicate tradeoffs and constraints clearly.
• Use AI tools to accelerate development responsibly (e.g., drafting SQL/Python, iterating on prompts, summarizing findings), while applying rigorous testing and verification.
• Define best practices for GenAI in analytics engineering, including prompt patterns for analytics tasks, model selection, and cost/latency optimization.

What we're looking for:

• 8+ years in analytics engineering, data engineering, data science, or related roles (or equivalent experience).
• Bachelor’s degree in Computer Science, Statistics, Data Science, Mathematics, or a related field (or equivalent experience).
• Strong understanding of LLM fundamentals and practical tradeoffs, including:
• Capabilities, limitations and common failure modes.
• Tokenization, context windows, latency/cost considerations.
• RAG vs. fine-tuning vs. prompting/tools for use cases.
• Expert SQL skills (complex joins, window functions, CTEs, query optimization).
• Hands-on experience with dimensional modeling (star schemas, SCD Type 2) and workflow orchestration tools such as Airflow, dbt.
• Demonstrated ability to validate AI-assisted output.
• High integrity and ownership to handle sensitive enterprise data appropriately and remain accountable for final outputs.
• Strong stakeholder communication with the ability to explain technical constraints to non-technical partners.
• Experience with GenAI coding tools (e.g., Cursor, Claude Code) to accelerate development while maintaining code quality and maintainability.

Relocation Statement:

• We recognize that the ideal environment for work is situational and may differ across departments. What this looks like day-to-day can vary based on the needs of each organization or role.

In-Office Requirement Statement:

• This role will need to be in the office for in-person collaboration 1-2 times/quarter every 6-months and therefore can be situated anywhere in the country.
• This position is not eligible for relocation assistance. Visit our PinFlex page to learn more about our working model.

#LI-NM4 #LI-REMOTE At Pinterest we believe the workplace should be equitable, inclusive, and inspiring for every employee. In an effort to provide greater transparency, we are sharing the base salary range for this position. The position is also eligible for equity. Final salary is based on a number of factors including location, travel, relevant prior experience, or particular skills and expertise. Information regarding the culture at Pinterest and benefits available for this position can be found here. US based applicants only $139,764—$287,749 USD Our Commitment to Inclusion: Pinterest is an equal opportunity employer and makes employment decisions on the basis of merit. We want to have the best qualified people in every job. All qualified applicants will receive consideration for employment without regard to race, color, ancestry, national origin, religion or religious creed, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender, gender identity, gender expression, age, marital status, status as a protected veteran, physical or mental disability, medical condition, genetic information or characteristics (or those of a family member) or any other consideration made unlawful by applicable federal, state or local laws. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements. If you require a medical or religious accommodation during the job application process, please complete this form for support.