Middle Data Engineer ID87373

AgileEngine is an Inc. 5000 company that creates award-winning software for Fortune 500 brands and trailblazing startups across 17+ industries. We rank among the leaders in areas like application development and AI/ML, and our people-first culture has earned us multiple Best Place to Work awards.

WHY JOIN US

If you're looking for a place to grow, make an impact, and work with people who care, we'd love to meet you!

ABOUT THE ROLE

We are looking for a Data Engineer to own ETL pipelines that power institutional analytics for colleges and universities. This person designs and maintains data workflows using SQL, Python, and Apache Airflow, moving data from source systems into a cloud data warehouse. Comfort adapting shared pipelines for individual clients while keeping code clean matters here.

WHAT YOU WILL DO

- Design, build, and maintain ETL pipelines and data workflows across multiple environments (development, staging, and production).

- Implement and extend data models and datasets to support analytical and reporting needs.

- Adapt and customize shared data pipelines for individual clients while maintaining a clean, reusable codebase.

- Monitor and support production data pipelines, investigate failures, and deliver fixes in a timely manner.

- Write and maintain database DDL, data validation queries, and deployment scripts.

- Contribute to platform modernization initiatives, including infrastructure upgrades and adoption of new data technologies.

- Collaborate with client teams, analysts, and stakeholders to gather requirements and deliver solutions.

MUST HAVES

- 3-4 years of experience in data engineering or a closely related software engineering role.

- Strong SQL , including complex joins, window functions, and dimensional / star-schema modeling.

- Strong Python programming skills.

- Hands-on Apache Airflow experience (DAGs, operators, scheduling, and troubleshooting failed jobs).

- Working knowledge of ETL patterns and cloud data warehouse design ( Amazon Redshift or similar: Snowflake, BigQuery, Synapse).

- Git and GitLab (or GitHub/Bitbucket) for day-to-day version control.

- Docker / Docker Compose .

- Understanding of data management concepts.

- Ability to translate client and business requirements into SQL, configuration, and DAG changes.

- Upper-intermediate English level.

NICE TO HAVES

- Familiarity with Tableau / Tableau Server REST API and/or PowerBI and associated APIs a plus.

- Familiarity with Spark.

- Familiarity with Amazon Redshift or another columnar warehouse.

PERKS AND BENEFITS

- Growth without limits : build your skills through mentorship, internal TechTalks, challenging projects, and a dedicated annual learning budget

- Competitive compensation : get recognition that reflects your skills and impact, with regular performance and compensation reviews

- Flexibility : work 100% remotely with flexible hours that support focus, autonomy, and a healthy work rhythm

- Meaningful, modern projects : build impactful products using modern technologies alongside global teams and leading brands

- Collaborative culture : join a supportive environment with zero micromanagement where ideas are welcomed and contributions are recognized

- Well-being & support : access local well-being programs and people-focused support tailored to your location