Data Engineering Intern

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 Brazil during the internship
Duration: 6 months with possibility of extension, working 30 hours per week

How you will make a difference day-to-day

• Analyze, extract, transform, and load data from multiple internal and external sources into a Snowflake warehouse to support data analysis and business intelligence efforts.
• Use SQL and API calls to extract data, then transform and load it using SQL-based processes.
• Use Airflow in Google Cloud to manage and orchestrate data flows, ensuring seamless data pipeline operations.
• Participate in daily team huddles, working alongside other engineers, report developers, and product teams to ensure alignment and progress.
• Work closely with report developers to create useful target tables and views, supporting various business intelligence reports.
• Partner with product owners, release managers, and QA staff to validate and promote code to production.
• 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.
• English proficiency.

Benefits & Perks

• Private health insurance including family dependents
• Dental plan (optional, at the employee’s expense)
• Life insurance
• Meal/Food voucher (Flexible Benefits category)
• Wellhub (former Gympass) partnership
• Total Pass partnership
• EAP (Employee Assistance Program)
• Mental health assistance
• Birthday off
• Employee referral program
• Free Rocket Lawyer account with online access to an extensive legal documents library and brilliant licensed attorneys at discounted rates

Interview Process:

• Recruiter Phone Screen
• Role Assessment(s)
• Hiring Manager Interview

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