Junior Data Engineer

The Advocate
Chicago, IL, United States
4 days ago
Apply on www.careerjet.com
Prepare application

Role details

Contract type
Internship / Graduate position
Employment type
Full-time (> 32 hours)
Experience level
Starter
Experience required
0 years minimum
Compensation
$70,000.0 - $90,000.0
Working hours
Regular working hours
Languages
English

Tech stack

Application Programming Interfaces (APIs) Airflow Amazon Web Services Business Analytics Applications Data Analysis Microsoft Azure Microsoft Basic Data Partition BigQuery Cloud Computing Cloud Database Code Review Databases
+37 more
Continuous Integration Data Validation Information Engineering Data Integration Extract Transform Load (ETL) Data Transformation Data Mining Data Structures Data Systems Data Warehousing Relational Databases Database Design Document-Oriented Databases Github JSON Python (Programming Language) Power BI Standard Sql Software Engineering SQL Databases Tableau (Software) Data Processing Scripting Google Cloud Snowflake Apache Spark Git Data Lakes Information Technology Apache Kafka Data Management Api Design Software Version Control Data Pipelines Docker Amazon Redshift Databricks

Job description

  • Assist in developing and maintaining ETL/ELT data pipelines.
  • Collect, transform, validate, and prepare data from multiple sources.
  • Write and optimize SQL queries for data extraction and transformation.
  • Develop Python scripts and applications to automate data-processing tasks.
  • Assist with maintaining databases, data warehouses, and data lakes.
  • Monitor data pipelines and troubleshoot data-quality or processing issues.
  • Perform data validation and testing to ensure accuracy and reliability.
  • Support data integration projects involving APIs, applications, and third-party systems.
  • Assist senior engineers with data modeling and database design.
  • Document data pipelines, processes, and technical procedures.
  • Participate in code reviews and follow software-development best practices.
  • Work with data analysts, data scientists, software engineers, and business teams.
  • Learn and apply cloud-based data engineering technologies.
  • Identify opportunities to automate repetitive data-management processes., Please submit your resume and, if available, a GitHub profile, portfolio, or examples of data-engineering projects. Candidates are encouraged to highlight experience with SQL, Python, ETL/ELT pipelines, databases, cloud platforms, APIs, or data-engineering projects. Candidates may be asked to complete a technical assessment covering SQL, Python, data transformation, and basic data-pipeline concepts.

Requirements

We are seeking a motivated and detail-oriented Junior Data Engineer to join our data team and help build, maintain, and improve the systems that collect, transform, store, and deliver data across the organization. This is a full-time position offering $70,000-$90,000 per year, depending on experience, technical skills, education, and qualifications. Candidates with strong SQL and Python skills, relevant internships or project experience, and familiarity with cloud platforms or data pipelines may be considered toward the upper end of the compensation range. The ideal candidate is eager to learn, enjoys solving technical problems, and wants to build a career in data engineering. You will work alongside experienced engineers and analysts while gaining hands-on experience with modern data technologies., * Bachelor’s degree in Computer Science, Data Engineering, Information Technology, Mathematics, Engineering, or a related field, or equivalent practical experience.

  • 0-2 years of experience in data engineering, software engineering, analytics engineering, or a related technical field.
  • Working knowledge of SQL.
  • Basic to intermediate proficiency in Python.
  • Understanding of relational databases and data structures.
  • Familiarity with ETL/ELT concepts and data pipelines.
  • Strong analytical and problem-solving skills.
  • Excellent attention to detail.
  • Ability to learn new technologies quickly.
  • Strong communication and teamwork skills.

Preferred

  • Internship or project experience involving data engineering.
  • Experience with AWS, Azure, or Google Cloud.
  • Familiarity with Snowflake, BigQuery, Redshift, Databricks, or similar platforms.
  • Exposure to Apache Airflow, dbt, Spark, Kafka, or similar technologies.
  • Familiarity with Git and version-control systems.
  • Basic knowledge of Docker or CI/CD.
  • Experience working with APIs and JSON data.
  • Familiarity with data modeling and data-warehouse concepts.
  • Experience with Power BI, Tableau, or other analytics platforms.

Benefits & conditions

The compensation for this position is $70,000-$90,000 per year, depending on technical experience, education, project work, and qualifications. Candidates with strong SQL and Python skills, relevant internships, cloud-platform experience, or demonstrated experience building data pipelines may be considered toward the upper end of the range. Additional benefits may include:

  • Health, dental, and vision insurance
  • Paid time off
  • Paid holidays
  • 401(k) or retirement plan
  • Remote or hybrid work flexibility
  • Professional development and technical training
  • Company-provided equipment
  • Opportunities for advancement into Data Engineer and Senior Data Engineer roles

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerjet.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

6:21 min

Investigating push inefficiencies with upstream Git experts

Jonathan Creamer · Coffee With Developers

3:47 min

Exploring JSON, CBOR, and JOSE for data serialization

Aaron Russell · LIVE

6:36 min

Funding open source through GitHub Accelerator and Sponsors

Stormy Peters · World Congress 2023

1:34 min

Bringing diverse skills to industrial data science roles

Katja Träumner

56 sec

Favorite git commands and the importance of patch commits

Eileen Uchitelle Eileen Uchitelle +1 · Coffee With Developers

Videos

See all

Related articles

See all