DataJobs.io
← Back to all jobs

Job Description

The Associate Data Engineer will contribute to the design, development, testing, and ongoing support of data integration solutions, including ETL/ELT processes and data pipelines. This role operates under guidance from senior team members and works alongside solution architects, business analysts, and senior data engineers in Agile delivery teams.

Responsibilities

  • Develop and maintain ETL/ELT jobs, workflows, and data pipelines.
  • Perform data extraction, transformation, and loading from multiple source systems.
  • Create and run unit tests, integration tests, and data validation scripts.
  • Support User Acceptance Testing (UAT) and assist with issue resolution.
  • Monitor data pipelines and troubleshoot data processing issues.
  • Conduct data cleansing, profiling, and validation activities.
  • Build SQL queries, stored procedures, and scripts to support reporting and analytics.
  • Assist in implementing data quality controls and data governance standards.
  • Support cloud migration and modernization initiatives.
  • Collaborate in Agile delivery teams with solution architects, business analysts, and senior data engineers.

Requirements

  • 2 years of experience in data engineering, software development, analytics, or a related technical role.
  • SQL development and query optimization.
  • Basic Python programming and scripting.
  • Understanding of relational databases.
  • Familiarity with ETL/ELT concepts.
  • Basic understanding of data warehousing concepts.
  • Knowledge of data quality and validation techniques.
  • Understanding of Agile development methodologies.
  • Bachelor’s degree in Computer Science, Information Technology, Engineering, Mathematics, or a related discipline.

Technology Stack

  • ETL/ELT, SQL, Python
  • Snowflake, Azure Synapse, Databricks, BigQuery, Redshift
  • Azure, AWS, GCP
  • Airflow, Data Factory, Informatica, Talend, SSIS
  • Spark, Hadoop, Kafka
  • DevOps, DataOps

Preferred

  • Experience with Snowflake, Azure Synapse, Databricks, BigQuery, Redshift, or similar platforms.
  • Exposure to cloud platforms such as Azure, AWS, or GCP.
  • Experience with Airflow, Data Factory, Informatica, Talend, SSIS, or equivalent data integration tools.
  • Exposure to Spark, Hadoop, or Kafka.
  • Knowledge of DevOps and DataOps practices.

Compensation

The base compensation range for this role in the posted location is $54,380 - $99.650 per year.

Benefits

  • Paid time off based on employee grade (A-F), defined by policy: Vacation 12-25 days depending on grade, company-paid holidays, personal days, and sick leave.
  • Medical, dental, and vision coverage (or provincial healthcare coordination in Canada).
  • Retirement savings plans (for example, 401(k) in the U.S. or RRSP in Canada).
  • Life and disability insurance.
  • Employee assistance programs.
  • Other benefits as provided by local policy and eligibility.

Job Location

Onsite in Nashville, TN.

Similar Jobs