Data Engineer - Build Scalable ETL Pipelines & Analytics

iClassPro - Class Management Software; Longview (TX); On-site; USD 90,000 - 150,000; Full time

Benefits offered by this job

Competitive compensation

27 days PTO

Health benefits

401(k) plan

Team events

Career growth opportunities

Job summary

iClassPro is the world’s leading class management software. We are seeking a Data Engineer who enjoys turning data into meaningful insights and scalable solutions.

Join a team that builds reliable data solutions for gyms, swim, dance, and cheer centers. In this role you will design and maintain ETL/ELT pipelines in Python with Airflow, craft dbt transformations, and work with Redshift, Athena, Glue, and Terraform on AWS.

Qualifications

• Bachelor's degree in CS/engineering or related quantitative field or equivalent practical experience.
• Strong Python skills with data manipulation libraries.
• Experience with AWS data services and data warehousing is preferred.
• AWS certification preferred.

Responsibilities

• Design, build, and maintain ETL/ELT pipelines in Python with Airflow.
• Write and maintain dbt models for clean, documented datasets.
• Create dbt tests to validate data quality before downstream use.
• Build ingestion jobs in AWS Glue and query data with Athena.
• Optimize Amazon Redshift for performance and cost.
• Deploy and manage cloud resources with Terraform.
• Monitor pipelines, troubleshoot issues, and implement alerting.
• Participate in code reviews, document, and contribute to governance.

Skills

Python

pandas

Advanced SQL

Window functions

CTEs

Data manipulation

Education

Bachelor's degree in Computer Science, Engineering, or related quantitative field

Tools

AWS Redshift

Amazon MWAA

Amazon Athena

AWS Glue

AWS Lambda

Terraform

Job description

iClassPro is the world’s leading class management software. We are seeking a Data Engineer who enjoys turning data into meaningful insights and scalable solutions.

Join a team that builds reliable data solutions for gyms, swim, dance, and cheer centers. In this role you will design and maintain ETL/ELT pipelines in Python with Airflow, craft dbt transformations, and work with Redshift, Athena, Glue, and Terraform on AWS.