Senior Data & AI Platform Engineer

Summary

Join Guild as a Senior Data & AI Platforms Engineer and become part of a high-performing team building a robust data ecosystem. Partner with data analysts, stakeholders, and engineering teams to design data solutions for analytics and product innovation. This high-impact role demands end-to-end ownership and a deep understanding of data systems and business contexts. Long-term platform thinking is crucial, focusing on building systems for future challenges. The position involves architecting, developing, and maintaining data pipelines, managing data models, collaborating on model design, integrating data from various sources, and upholding data quality. Mentorship of junior team members and providing enterprise-wide guidance on data initiatives are also part of the role.

Requirements

• 6–10 years of experience in data engineering or related roles
• Expert-level skills in SQL (window functions, CTEs, performance tuning) and Python (data pipelines, API integrations, automation)
• Hands-on experience with Snowflake, dbt, and Fivetran
• Can navigate unix systems, terraform, and git as appropriate
• Deep familiarity with relational databases (Postgres, MySQL, AuroraDB) and NoSQL systems like DynamoDB
• Extremely comfortable using AI tools to boost individual and team productivity
• Experience building out data platforms for AI Agents / AI Products
• Strong understanding of data modeling, warehousing best practices, and ETL/ELT frameworks
• Proven ability to work cross-functionally and connect technical design with commercial objectives
• Experience in a high-growth, agile environment with modern data stack tools
• Exposure to data governance, privacy, and compliance best practices
• Strong understanding of engineering best practices related to delivery (CI/CD, continuous delivery, change management)
• Experience with CDC (Change Data Management)

Responsibilities

• Architect, develop, and maintain data pipelines using Fivetran, dbt, S3, Glue, orchestrators, and custom Python jobs
• Manage and optimize data models in dbt, ensuring they are scalable, accurate, and aligned to business use cases
• Collaborate with analytics and commercial teams to design models and marts in our visualization tools that empower decision-making
• Integrate and transform data from a variety of sources, including AuroraDB, Snowflake Postgres, MySQL, and DynamoDB
• Uphold data quality through testing, validation, and observability best practices
• In the future, mentor junior team members and contribute to evolving our data engineering standards and processes
• Partner with stakeholders to deeply understand business domains and ensure data design meets real-world needs
• Mentor and upskill team members
• Provide enterprise-wide guidance and prototyping on key data initiatives, especially as the data platforms team expands its scope to support production engineering from the warehouse

Benefits

• Access to low-cost, high-quality health care options through Cigna and Kaiser (due to coverage limitations, Kaiser is currently only available in CA & CO)
• Access to a 401k to help save for the future
• Open vacation policy for employees to rest and recharge
• 8 days of fully-paid sick leave, to take the time to heal and or recover
• Family-friendly benefits, including 12 weeks of parental leave for non-birthing parents and 18-20 weeks for birthing parents; 4-week ramp-up period for when employees return from a leave of 6 weeks or more; as well as employer-paid short-term and long-term disability, employer-sponsored life insurance, fertility and caregiving benefits
• Well-rounded wellness benefits including free and low cost mental health resources and financial wellbeing support services
• Education benefits and tuition assistance to help your future development and growth