Logo of Huzzle

Data Engineering Intern - SQL/dbt

image

Calix

11d ago

  • Internship
    Full-time
    Summer Internship
  • IT & Cybersecurity
  • Canada, +1
    Remote
  • Quick Apply

AI generated summary

  • You should be pursuing a Bachelor's degree, have SQL knowledge, experience with Python or Java, strong organizational skills, and a desire to troubleshoot and grow professionally.
  • You will implement ETL/ELT processes, maintain DataOps, automate data pipelines, ensure data quality, evaluate new technologies, and collaborate in project meetings to provide updates.

Requirements

  • 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).

Responsibilities

  • 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.

FAQs

Is this a remote position?

Yes, this is a remote position that can be based anywhere in the United States or Canada.

What are the eligibility criteria for the internship?

Candidates must be currently pursuing a Bachelor's degree at an accredited university and must be returning to school in the Fall.

What skills are required for this internship?

Candidates should have an understanding of data, databases, and data structures, along with knowledge of SQL, Python, or Java.

What will my responsibilities be as a Data Engineering Intern?

You will implement data ingestion, ETL/ELT processes, establish a DataOps approach, create automation systems, ensure data quality, evaluate new technologies, and participate in project meetings.

How long is the internship program?

The duration of the program is expected to be 90 days.

When is the internship expected to take place?

The internship is expected to take place during the summer months, either from May to August or June to September.

What kind of support will I receive during the internship?

You will have the opportunity to learn new skills through training and on-the-job learning as part of the company's unique internship program.

What is the compensation for this internship?

Compensation will vary based on geographical location, with hourly rates ranging from $18.00 to $29.90 depending on the location within the United States.

What is the focus of the Data Engineering Intern role?

The focus is on building and maintaining a cloud-based enterprise data platform, including data pipeline flow, data warehousing, security, data integrity processes, and data QA best practices.

Is experience in data engineering required?

While relevant experience is beneficial, a strong foundational understanding of data concepts and a passion for data troubleshooting are also valued.

To enable broadband service providers of all sizes to simplify, excite and grow.

Technology
Industry
1001-5000
Employees
1999
Founded Year

Mission & Purpose

Innovative communications service providers rely on Calix platforms to help them master and monetize the complex infrastructure between their subscribers and the cloud. Calix is the leading global provider of the cloud and software platforms, systems, and services required to deliver the unified access network and smart premises of tomorrow. Our platforms and services help our customers build next generation networks by embracing a DevOps operating model, optimize the subscriber experience by leveraging big data analytics, and turn the complexity of the smart home and business into new revenue streams.