Senior Analytics Engineer

** The Role
** SailPoint is the leader in identity security for the cloud enterprise. Our solutions help thousands of organizations worldwide see and govern who has access to what, so every identity has exactly the access it needs.

SailPoint is seeking an Analytics Engineer to join our IT Data Engineering team. In this role, you will build and maintain the data models and pipelines that serve as the trusted foundation for reporting and analytics across SailPoint, with a particular focus on supporting our HR and People Analytics partners. You'll own data from ingestion through the reporting layer, writing the SQL, tests, documentation, and access controls that keep it accurate, secure, and easy for others to build on.
** Responsibilities:
*** Design, build, and maintain modular dbt models in Big Query that transform raw data into clean, reliable, analysis-ready datasets.
* Write performant, well-structured SQL, and optimize Big Query queries and models for speed and cost.
* Build and support data ingestion pipelines that bring data from source systems and SaaS applications, including Workday, into the warehouse.
* Develop and maintain orchestration and scheduling for data workflows, and monitor pipelines to make sure data arrives on time and complete.
* Define and standardize business metrics, such as headcount, attrition, and recruiting funnel measures, so the same number shows up consistently in every report and dashboard.
* Implement dbt tests, documentation, and code review practices to ensure data quality and make models easy for others to understand and extend.
* Enforce data privacy and access controls for sensitive and PII data across models, data sources, and dashboards, including Row-Level Security.
* Build and maintain Tableau data sources and dashboards on top of your models, including operational and executive-level views used by HR and leadership.
* Support Tableau administration for the content you own, including user permissions, publishing workflows, and refresh schedules.
* Build datasets that support workforce analytics and forecasting use cases, such as attrition and recruiting capacity planning.
* Explore and help implement AI-assisted analytics, such as self-service query tools built on Big Query and Google Gemini, for HR and other business partners.
* Troubleshoot data issues end to end, from source system through transformation to reporting, and drive root-cause fixes.
* Contribute to CI/CD, version control, and deployment practices for the team's data projects.
* Partner with business stakeholders to gather requirements, define KPIs, and scope new data products and visualizations.
* Contribute to data modeling standards, naming conventions, and reusable patterns for the broader data team.
** Requirements:
*** 5 - 8 years of experience in analytics engineering, data engineering, or a similar role.
* Advanced SQL skills, including window functions, CTEs, and query performance tuning.
* Hands-on experience building and maintaining data models in dbt, including tests, macros, and documentation.
* Experience working in a cloud data warehouse, preferably Big Query.
* Experience building or supporting data pipelines and working with orchestration tools such as Airflow, Cloud Composer, or similar.
* Hands-on experience with Tableau Desktop and Tableau Server or Tableau Cloud, including published data sources, calculated fields, parameters, and Row-Level Security.
* Experience working with sensitive or PII data and applying data privacy and access controls.
* Proficiency with version control using Git and familiarity with CI/CD workflows.
* Strong understanding of data modeling concepts such as dimensional modeling, star schemas, granularity, and slowly changing dimensions.
* Experience…