Sr. Data Scientist, Gen AI Automation

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.

• 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 optimise 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 trade‑offs and constraints clearly.
• Use AI tools to accelerate development responsibly (e.g., drafting SQL/Python, iterating on prompts, summarising 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 optimisation.

• 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 trade‑offs, including:
  • Capabilities, limitations and common failure modes.
  • Tokenisation, context windows, latency/cost considerations.
  • RAG vs. fine‑tuning vs. prompting/tools for use cases.
• Expert SQL skills (complex joins, window functions, CTEs, query optimisation).
• Hands‑on experience with dimensional modelling (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.

• We recognise 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 organisation or role.

• 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 Pin Flex page to learn more about our working model.

US based applicants only

$139,764—$287,749 USD

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, colour, 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.

By submitting this application, I certify that all information submitted in my application and throughout the hiring process is true, accurate, and complete to the best of my knowledge. I understand that any false statement, omission, or misrepresentation may disqualify me from employment consideration or result in termination if discovered after hire.