Data Engineer II (REMOTE)

SailPoint; United States; Remote; USD 80,000 - 110,000; Full time

Job summary

Join a forward-thinking company as a Data Engineer II, where you will play a pivotal role in shaping data accessibility and analytics. In this remote position, you will work with cutting-edge tools and technologies to model and manage data, ensuring optimal performance and security. Collaborate with software engineers and analysts to build robust data pipelines and warehouses that empower decision-making across the organization. This is an exciting opportunity to contribute to innovative projects in a dynamic environment that values your expertise and offers competitive benefits and growth potential.

Benefits

Medical/Pharmacy Coverage

Dental Coverage

Company-sponsored Healthcare

Annual Performance Bonus

Phone Reimbursement

Internet Reimbursement

Private Equity Opportunities

33% Vacation Bonus

Christmas Bonus

Qualifications

• 2-5 years as a data engineer in a medium-sized company.
• Experience with ETL tools like DBT, Airflow, and Databricks.
• Strong SQL and Python skills required.

Responsibilities

• Model data using DBT and support data movement.
• Build and maintain data warehouses and marts.
• Collaborate with teams to model analytics tables.

Skills

ETL Modeling

DBT

SQL

Python

Data Security

Cloud Data Warehousing

Big Data Technologies

Data Governance

Education

Bachelor's Degree in Computer Science

Degree in Math or related STEM field

Tools

Airflow

Databricks

Hadoop

Spark

Kafka

Git

Docker

Snowflake

Redshift

Job description

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 usable 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 experience 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: Bachelor's 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 move data to Snowflake.
• Take existing data structures from Tableau Prep and convert 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.