Senior Analytics Engineer

The RoleSailPoint 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 BigQuery that transform raw data into clean, reliable, analysis-ready datasets.Write performant, well-structured SQL, and optimize BigQuery 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 BigQuery 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 BigQuery.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 gathering requirements from business users and translating them into data solutions.Strong attention to detail and a commitment to data accuracy.Clear written and verbal communication skills, with the ability to explain technical concepts to non-technical and executive audiences.Preferred:Bachelor's degree in a STEM, business, or related field, or equivalent experience.Experience with HR or workforce data, such as headcount, attrition, and recruiting funnel reporting.Experience with Workday data, including custom reports or integrations that feed downstream analytics.Experience using AI tools for analytical querying or building AI-assisted self-service reporting.Experience with Python for data pipelines, automation, or analysis.Experience with data ingestion tools such as Fivetran, Airbyte, or similar.Familiarity with Google Cloud Platform services beyond BigQuery.Experience in a SaaS or cybersecurity environment.Plan for Success:Days 1–30: Integration & Core Tech OnboardingFocus on gaining environment access, mapping pipeline architectures, and aligning with key stakeholders.Tech Stack Setup: Set up your developer environment and establish full access to Google BigQuery, dbt, Git, and Tableau.Architecture Mapping: Conduct a deep dive into active dbt models and data pipelines, specifically analyzing how data flows from systems like Workday into BigQuery.Compliance & Security: Review security protocols for PII data, focusing on Row-Level Security implementations in Tableau.Stakeholder Alignment: Set up regular syncs with your manager, team peers, and key HR/People Analytics stakeholders.Days 31–60: Active Development & Core DeliverablesTransition from learning to active execution, contributing to production code and standardizing business metrics.Deploy First dbt Model: Build, test, and deploy your first modular dbt model transforming raw workforce data in BigQuery.Standardize Metrics: Collaborate with HR partners to define and codify a core business metric (e.g., attrition or recruiting funnel metrics) within dbt.Tableau Visualization: Develop, secure, and publish a targeted Tableau dashboard answering a specific HR operational query.Workflow Support: Actively participate in the team’s Git pull request reviews and support basic data pipeline monitoring.Days 61–90: Autonomous Ownership & Strategic OptimizationOperate with full autonomy, owning end-to-end projects, improving system performance, and driving innovative pilots.End-to-End Delivery: Own an analytics project from initial stakeholder requirements gathering to the final certified Tableau dashboard.Query Optimization: Identify and optimize a complex BigQuery query or dbt model to improve processing speed and lower warehouse costs.AI Analytics Pilot: Coordinate a small prototype testing AI-assisted querying (such as using Google Gemini on BigQuery) for business users.Cross-Functional Scope: Extend analytical support to other business verticals beyond HR as team priorities shift.Benefits and Compensation listed vary based on the location of your employment and the nature of your employment with SailPoint.As a part of the total compensation package, this role may be eligible for the SailPoint Corporate Bonus Plan or a role-specific commission, along with potential eligibility for equity participation. SailPoint maintains broad salary ranges for its roles to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect SailPoint’s differing products, industries, and lines of business. Candidates are typically placed into the range based on the preceding factors as well as internal peer equity. We estimate the base salary, for US-based employees, will be in this range from (min-max, USD): $108,600 - $183,018.00Base salaries for employees based in other locations are competitive for the employee’s home location.Benefits Overview1. Health and wellness coverage: Medical, dental, and vision insurance2. Disability coverage: Short-term and long-term disability3. Life protection: Life insurance and Accidental Death & Dismemberment (AD&D)4. Additional life coverage options: Supplemental life insurance for employees, spouses, and children5. Flexible spending accounts for health care, and dependent care; limited purpose flexible spending account6. Financial security: 401(k) Savings and Investment Plan with company matching7. Time off benefits: Flexible vacation policy8. Holidays: 8 paid holidays annually9. Sick leave10. Parental support: Paid parental leave11. Employee Assistance Program (EAP) and Care Counselors12. Voluntary benefits: Legal Assistance, Critical Illness, Accident, Hospital Indemnity and Pet Insurance options13. Health Savings Account (HSA) with employer contributionSailPoint is an equal opportunity employer and we welcome all qualified candidates to apply to join our team. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other category protected by applicable law. Alternative methods of applying for employment are available to individuals unable to submit an application through this site because of a disability. Contact View email address on click.appcast.io or mail to 11120 Four Points Dr, Suite 100, Austin, TX 78726, to discuss reasonable accommodations. NOTE: Any unsolicited resumes sent by candidates or agencies to this email will not be considered for current openings at SailPoint.SummaryLocation: United States; Headquarters (Austin, Texas, USA)Type: Full time