Data Engineer II (REMOTE)

SailPoint is the leader in identity security for the cloud enterprise. Our identity security solutions secure and enable thousands of companies worldwide, giving our customers unmatched visibility into the entirety of their digital workforce, ensuring workers have the right access to do their job – no more, no less.

SailPoint is seeking a Data Engineer II to work remotely in Mexico.

Responsibilities

• The Data Engineer will primarily work in DBT modeling with our site and activity data to provide accessibility to our most important data

• The Data Engineer will also support the movement and modeling of new data sources in DBT/GitHub

• You will support other analytic and data science partners who are designing and developing applications/pipeline

• Collaborate with software engineers and analysts in data collection and data usage to model analytics tables from raw format to useable fact tables

• Build and maintain data warehouses and data marts

• Configure DBT models to keep the cost per query down and query speeds high for the team

Qualifications

• 2-5 years of professional experience as a data engineer in a high-growth medium-sized company

• At least 5 years of experiences with ETL modeling and scheduling with tools like DBT, Airflow, Databricks etc.

• Experience with big data technologies such as Hadoop, Spark, and Kafka

• Strong experience with SQL, Python, and other data engineering technologies

• Strong proficiency in using cloud data warehouse (Redshift,  Snowflake)

• Hands-on knowledge and experience with common technologies used in software engineering such as bash, git and docker

• Experience with data security and governance best practices

• Preferred but not required: Bachelors or higher degree in Computer Science, Math or a related STEM field

In the first 30 Days you will:

• Follow Product Analytics Onboarding and request access to tools and services.  

• Connect with the DEPO team and get access set up for GitHub Repository

• Contact Marcelo Herrera and get access set up for all Snowflake Instances

• Work with the current data engineering team to get access to OpenSearch

In the first 90 Days you will:

• Data Engineers should be set up and submitting code for approval to Product Analytics Snowflake via GitHub

• Pull data via Python from OpenSearch and moving data to Snowflake

• Take existing data structures from Tableau Prep and converting them to tables in Snowflake

By the end of the first year you will be:

• Working regularly with analysts and engineers to understand the data needs for our analytic objectives and building those out in reporting schemas for more efficient analysis

• Work with the DEPO team and other engineers to set up new data pipelines and validate new data sources for analytics purposes

SailPoint is committed to providing our Crew Members with a benefits program that is both comprehensive and competitive. Our benefits program offers medical/pharmacy and dental coverage, as well as financial security for our Crew Members and their families. All premiums are paid by SailPoint.

• Full time remote employment

• Competitive salaries

• Company sponsored healthcare coverage for you and your family

• Annual performance bonus

• Phone and internet reimbursement

• Private equity at certain levels

• 33% prima vacaciones

• Christmas Bonus equivalent to 30 days of salary

SailPoint is an equal opportunity employer and we welcome everyone to our team.  All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.