Offer summary

Qualifications:

Senior undergraduate student pursuing a Bachelor's degree in Computer Science or a related field., Proficiency in SQL, Python, Git, and Linux., Familiarity with Google Cloud Platform, Airflow, and Snowflake., Ability to work collaboratively in a fast-paced, team-oriented environment..

Key responsabilities:

Analyze, extract, transform, and load data into a Snowflake warehouse to support business intelligence efforts.

Use SQL and API calls to manage data extraction and transformation processes.

Orchestrate data flows using Airflow in Google Cloud to ensure seamless operations.

Collaborate with report developers and product teams to create and validate data outputs.

Job description

About Rocket Lawyer

We believe everyone deserves access to affordable and simple legal services. Founded in 2008, Rocket Lawyer is the largest and most widely used online legal service platform in the world. With offices in North America, South America, and Europe, Rocket Lawyer has helped over 30 million people create over 50 million legal documents, and get their legal questions answered.

We are in a unique position to enhance and expand the Rocket Lawyer platform to a scale never seen before in the company’s history, to capture audiences worldwide. We are expanding our team to take on this challenge!

About your role

As a Data Engineering Intern, you will work with the Business Intelligence team to help extract, transform, and load (ETL) data from both internal and external sources into a Snowflake data warehouse. You’ll gain hands-on experience using tools such as SQL, Airflow, and Google Cloud to orchestrate data flows and support data-driven decision-making across the organization. You’ll collaborate closely with a diverse team of report developers, product owners, and QA staff to help ensure smooth and accurate data operations, and you'll get to experience working in an agile environment.

Reports to: Principal Data Engineering Architect
Location: Remote, but you must be located in CA, AZ, CO, NC, or UT during the internship
Duration: June 16, 2025 - August 18, 2025, working 40 hours per week

How you will make a difference day-to-day

Data Integration: Analyze, extract, transform, and load data from multiple internal and external sources into a Snowflake warehouse to support data analysis and business intelligence efforts.
SQL & API Calls: Use SQL and API calls to extract data, and then transform and load it using SQL-based processes.
Orchestrate Data Flows: Use Airflow in Google Cloud to manage and orchestrate data flows, ensuring seamless data pipeline operations.
Team Collaboration: Participate in daily team huddles, working alongside other engineers, report developers, and product teams to ensure alignment and progress.
Collaboration with Report Developers: Work closely with report developers to create useful target tables and views, supporting various business intelligence reports.
Collaboration with Product & QA Teams: Partner with product owners, release managers, and QA staff to validate and promote code to production.
Agile Workflow: Update a JIRA Kanban board during certain weeks and a sprint board in others, helping to manage and track progress in an agile environment.

What you’ll need

Senior Undergraduate Student pursuing a Bachelor’s degree in Computer Science or a related field.
Proficiency in SQL, Python, Git, and Linux.
Ability to work collaboratively in a fast-paced, team-oriented environment.
Familiarity with Google Cloud Platform, Airflow, and Snowflake.

Interview Process:

Recruiter Phone Screen
Role Assessment(s)
Hiring Manager Interview

Rocket Lawyer is proudly committed to recruiting and retaining a diverse and inclusive workforce. As an Equal Opportunity Employer, we never discriminate based on race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, military or veteran status, status as an individual with a disability, or other applicable legally protected characteristics. We particularly welcome applications from veterans and military spouses.

All your information will be kept confidential according to EEO guidelines.

You may request reasonable accommodations by sending an email to hr@rocketlawyer.com.

Compensation:

Utah, Arizona, North Carolina: $29.60
California (Outside of San Francisco Bay area) and Colorado: $31.45

Actual compensation packages are determined by various factors unique to each candidate, including but not limited to skill set, depth of experience, certifications, specific work location, and performance during the interview process.

$29.60—$31.45 USD

By applying for this position, your data will be processed as per Rocket Lawyer Privacy Policy.

Required profile