Senior Data Engineer - Snowflake (Remote)

Other Jobs To Apply

No other job posts for this day.

<p><b>About SailPoint</b></p><p>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.</p><p>Want to be on a team that’s full of results-driven individuals who are constantly seeking to innovate? At SailPoint, our Engineering team does just that. We value high-quality collaborative engineering driven by focused individuals. Our team creates products that are built on strong technical foundations, agility to respond to market demands, and frequent shipping to customers.</p><p></p><p><b>About the Team</b></p><p>SailPoint is seeking a <b><i>Senior Data Engineer</i></b> to help build a new cloud-based SaaS identity security product. We are seeking a highly motivated and experienced<i> Senior Data Engineer</i> to <i>design</i>, build, and maintain our robust data ecosystem. This role will focus on creating scalable and reliable data pipelines using a diverse and modern data stack. The ideal candidate will have hands-on experience with both <i>batch</i> and <i>streaming</i> data processing, as well as a strong understanding of various database technologies, including columnar, NoSQL, and graph databases.</p><p>As one of the first members on the team, you will be integral in building this product and will be part of an agile team that is in startup mode. This is a unique opportunity to grow a project that is in it’s early stages but with the backing of an organization that has the muscle to take it to market quickly, with a broad and engaged customer base.</p><p></p><p><b>Responsibilities</b></p><ul><li><p><i>Data pipeline</i> development: <i>Design</i>, construct, and optimize scalable <i>ETL</i>/<i>ELT</i> pipelines for both <i>batch</i> and <i>real-time</i> data using DBT, Apache Spark and Apache <i>Flink</i>.</p></li><li><p>Data <span style="overflow-wrap: break-word; display: inline; text-decoration: inherit; hyphens: auto;">warehousing: Develop</span> and manage data schemas and warehouses within <i>Snowflake</i>, ensuring data is organized for efficient querying and analysis.</p></li><li><p>Database <span style="overflow-wrap: break-word; display: inline; text-decoration: inherit; hyphens: auto;">management: Collaborate</span> with infrastructure teams to administer and optimize data storage solutions using <i>Cassandra</i> for high-velocity, wide-column data, and graph databases for complex relationship-based data.</p></li><li><p><i>Real-time</i> <i>streaming</i>: Build and maintain data ingestion workflows for <i>real-time</i> applications using Apache <i>Flink</i> to process data from sources like Apache Kafka.</p></li><li><p>Performance <span style="overflow-wrap: break-word; display: inline; text-decoration: inherit; hyphens: auto;">optimization: Tune</span> complex Spark, <i>Flink</i>, SQL, and CQL queries to improve performance and reduce cost within <i>Snowflake</i> and other database systems.</p></li><li><p>Data quality and <span style="overflow-wrap: break-word; display: inline; text-decoration: inherit; hyphens: auto;">governance: Implement</span> and enforce data quality standards, monitor pipelines, and establish data governance policies to ensure data integrity and security.</p></li><li><p>Infrastructure <span style="overflow-wrap: break-word; display: inline; text-decoration: inherit; hyphens: auto;">management: Collaborate</span> with DevOps teams to manage and automate the deployment of data applications using CI/CD pipelines.</p></li><li><p><span style="overflow-wrap: break-word; display: inline; text-decoration: inherit; hyphens: auto;">Collaboration: Work</span> with data scientists, BI analysts, and other stakeholders to translate complex data requirements into scalable engineering solutions.</p></li></ul><p></p><p><b>Requirements</b></p><ul><li><p><span style="overflow-wrap: break-word; display: inline; text-decoration: inherit; hyphens: auto;">Education: Bachelor's</span> degree in Computer Science, Engineering, or a related technical field.</p></li><li><p>Experience: 6+ years of professional experience in data engineering or a similar role.</p></li><li><p><span style="overflow-wrap: break-word; display: inline; text-decoration: inherit; hyphens: auto;">Programming: Strong</span> proficiency in programming languages like Python, Scala, or Java.</p></li><li><p>Data <span style="overflow-wrap: break-word; display: inline; text-decoration: inherit; hyphens: auto;">warehousing: Expert-level</span> knowledge of <i>Snowflake</i> for data warehousing, including <i>data modeling</i> and query optimization.</p></li><li><p><i>Batch</i> <span style="overflow-wrap: break-word; display: inline; text-decoration: inherit; hyphens: auto;">processing: Hands-on</span> experience with Apache Spark for large-scale data processing.</p></li><li><p><i>Streaming</i> <span style="overflow-wrap: break-word; display: inline; text-decoration: inherit; hyphens: auto;">processing: Experience</span> with Apache <i>Flink</i> for building <i>real-time</i> data <i>streaming</i> applications.</p></li><li><p>NoSQL <span style="overflow-wrap: break-word; display: inline; text-decoration: inherit; hyphens: auto;">databases: Strong</span> experience with <i>Cassandra</i> for managing and optimizing distributed data storage.</p></li><li><p>Graph <span style="overflow-wrap: break-word; display: inline; text-decoration: inherit; hyphens: auto;">databases: Solid</span> understanding and hands-on experience with graph databases and their query languages (e.g., Gremlin, Cypher).</p></li><li><p>Cloud <span style="overflow-wrap: break-word; display: inline; text-decoration: inherit; hyphens: auto;">experience: Familiarity</span> with a major cloud provider (e.g., AWS, Azure, GCP) and its data-related services.</p></li></ul><p></p><p><b>Preferred qualifications</b></p><ul><li><p>Experience with other components of the big data ecosystem (e.g., DBT, Apache Kafka, Airflow).</p></li><li><p>Experience with containerization technologies like Docker and Kubernetes.</p></li><li><p>Familiarity with data governance and observability tools.</p></li><li><p>Certifications related to <i>Snowflake</i>, AWS, or other cloud platforms.</p></li></ul><h3></h3><h3><b>What Success Looks Like in This Role</b></h3><p><b>30 days:</b></p><ul><li><p>Understand the current data infrastructure and workflows.</p></li><li><p>Get familiar with the team and ongoing projects.</p></li><li><p>Start contributing to small tasks and bug fixes.</p></li></ul><p><b>90 days:</b></p><ul><li><p>Take ownership of a scoped project or feature.</p></li><li><p>Collaborate with team members to <i>design</i> and implement data models.</p></li><li><p>Begin building data pipelines and orchestrating workflows.</p></li></ul><p><b>6 months:</b></p><ul><li><p>Lead the <i>design</i> and implementation of <i>ELT</i> processes.</p></li><li><p>Develop and maintain scalable data pipelines for both stream and <i>batch</i> processing.</p></li><li><p>Ensure data security, quality, and compliance in your areas of ownership.</p></li></ul><p><b>1 year:</b></p><ul><li><p>Spearhead complex data projects that power AI/<i>ML</i> products.</p></li><li><p>Collaborate with cross-functional teams to integrate diverse data sources.</p></li><li><p>Represent key data insights in a meaningful way to stakeholders.</p></li></ul><p></p><p style="text-align:inherit"></p><p style="text-align:inherit"></p><p style="text-align:left">Benefits and Compensation listed vary based on the location of your employment and the nature of your employment with SailPoint.</p><p style="text-align:inherit"></p><p style="text-align:left">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. <span>We estimate the base salary, for US-based employees, will be in this range from (min-mid-max, USD): </span></p>$105,500 - $150,700 - $195,900<p style="text-align:left"><span>Base salaries for employees based in other locations are competitive for the employee’s home location.</span></p><p style="text-align:inherit"></p><p style="text-align:left">Benefits Overview</p><p style="text-align:left">1. Health and wellness coverage: Medical, dental, and vision insurance</p><p style="text-align:left">2. Disability coverage: Short-term and long-term disability</p><p style="text-align:left">3. Life protection: Life insurance and Accidental Death & Dismemberment (AD&D)</p><p style="text-align:left">4. Additional life coverage options: Supplemental life insurance for employees, spouses, and children</p><p style="text-align:left"><span>5. Flexible spending accounts for health care, and dependent care; limited purpose flexible spending account</span></p><p style="text-align:left">6. Financial security: 401(k) Savings and Investment Plan with company matching</p><p style="text-align:left"><span>7. Time off benefits: Flexible vacation policy</span></p><p style="text-align:left">8. Holidays: 8 paid holidays annually</p><p style="text-align:left">9. Sick leave</p><p style="text-align:left">10. Parental support: Paid parental leave</p><p style="text-align:left">11. Employee Assistance Program (EAP) and Care Counselors</p><p style="text-align:left">12. Voluntary benefits: Legal Assistance, Critical Illness, Accident, Hospital Indemnity and Pet Insurance options</p><p style="text-align:left">13. Health Savings Account (HSA) with employer contribution</p><p style="text-align:inherit"></p><p></p><p></p><p></p><p>SailPoint 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.  </p><p></p><p>Alternative methods of applying for employment are available to individuals unable to submit an application through this site because of a disability. Contact <span style="overflow-wrap: break-word; display: inline; text-decoration: inherit; hyphens: auto;">applicationassistance@sailpoint.com</span> 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.</p>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...