Job details

Data Engineering Intern - SQL/dbt

Get a free resume review

This is a remote position that could be based anywhere in the United States or Canada.

Calix is looking for a Data Engineer intern to join our Information Security team. In this role, you will be part of a unique and award-winning internship program within the company. The program provides the opportunity to learn new skills through training and on the job learning.

This is a remote position that could be based anywhere in the United States or Canada.

Calix is looking for a Data Engineering Intern to join our team for the summer months. This is an exciting opportunity for a rising Junior or Senior in an accredited four-year college or university on track to earn their degree. You will build and maintain our cloud-based enterprise data platform. Key areas that you will be involved in include data pipeline flow, data warehousing, security, data integrity processes, and data QA best practices. You will buildout the end-to-end ETL/ELT data environment, integrating with new technologies, and the development of new processes to support the creation and deployment of trusted, accurate and secure decision support tools to the Calix operational business units. The duration of the program is expected to be 90 days.

Responsibilities and Duties:

Implement data ingestion, ETL / ELT, data modeling, and data integration development using our cloud-based tooling including Snowflake, AWS, Fivetran, dbt, Airflow and GitHub.
Establish and maintain a DataOps approach for our data pipeline infrastructure and processes.
Create automation systems and tools to configure, monitor, and orchestrate our data infrastructure and our data pipelines.
Ensure data quality throughout all stages of acquisition and processing.
Evaluate new technologies for continuous improvement in data engineering.
Participate in project meetings, providing input to project plans and providing status updates.
A desire to work in a collaborative, intellectually curious environment.

Qualifications:

Currently pursuing an Bachelor's degree at an accredited university and returning back to school in the Fall.
Understanding of data, databases, and data structures.
Knowledge of SQL, Python or Java.
Passion for troubleshooting data issues.
High degree of organizational skill and problem-solving ability; specifically, the ability to work as self-starter.
Desire to grow professionally and collaborate with others.
Able to prioritize/execute to achieve desired company and project goals with prudence and sense of urgency.
Able to work for the complete summer break (May - August or June - September).

Location:

Remote-based position located in the United States or Canada.

#LI-Remote

Compensation will vary based on geographical location (see below) within the United States. Individual pay is determined by the candidate's location of residence and multiple factors, including job-related skills, experience, and education.

For more information on our benefits click here.

There are different ranges applied to specific locations. The average base pay range (or OTE range for sales) in the U.S. for the position is listed below.

San Francisco Bay Area Only:

23.00 - 29.90 USD Hourly

National Major Cities plus, CA, CO, NY Metro area:

20.00 - 26.00 USD Hourly

Regional plus NY:

18.00 - 23.40 USD Hourly

Average salary estimate

$49000 / YEARLY (est.)

min

max

$36000K

$62000K

If an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.

What You Should Know About Data Engineering Intern - SQL/dbt, Calix

Join us at Calix as a Data Engineering Intern, where you can work remotely from anywhere in the United States or Canada! We're on the lookout for an enthusiastic intern to become part of our innovative Information Security team. This isn't just another internship; it's a unique opportunity designed for rising juniors or seniors in accredited four-year institutions, where you'll gain hands-on experience in building and maintaining our cloud-based enterprise data platform. During your time with us, you'll get your hands dirty with data pipeline flow, warehousing, security, and data integrity processes. You’ll be immersed in crafting the end-to-end ETL/ELT data environment, utilizing cutting-edge tools including SQL, dbt, and AWS. You will be encouraged to think creatively and evaluate new technologies to enhance our data engineering efforts. With a project duration of 90 days, expect to participate actively in project meetings, contributing valuable insights as you build automation systems for our data infrastructure. If you're passionate about collaborating in a curious environment and eager to deepen your technical skills, this internship is the perfect summer job for you, running from May to August or June to September!

Frequently Asked Questions (FAQs) for Data Engineering Intern - SQL/dbt Role at Calix

What are the responsibilities of a Data Engineering Intern at Calix?

As a Data Engineering Intern at Calix, your responsibilities will include implementing data ingestion, ETL/ELT, and data modeling processes using advanced cloud-based tools like Snowflake, GitHub, and Airflow. You'll focus on maintaining data quality, establishing a DataOps approach, and collaborating within project teams to deliver insights effectively.