What are the responsibilities and job description for the Junior Data Engineer position at AceStack?
Role: Junior Data Engineer
Location: : Plano, TX – US - Onsite
Position Type: Fulltime Permanent – FTE
Salary: $80K-$100K/ Year
About the Role: We are looking for a motivated and detail-oriented Junior Data Engineer with 2-4 year of experience to join our development team. The ideal candidate will contribute to designing, developing and optimizing business process automation solutions and data driven solutions, leveraging cutting-edge AI technologies and modern containerization practices to build scalable and resilient applications.
Responsibilities
Design, develop, and maintain scalable ETL/ELT pipelines to process structured and unstructured data
• Design, develop, and maintain data pipelines using Snowflake and dbt
• Build efficient and scalable data models (star/snowflake schemas) using dbt
• Develop and optimize SQL queries for high-performance data transformation
• Implement ELT workflows leveraging Snowflake architecture
• Collaborate with analysts and business stakeholders to translate requirements into data solutions
• Schedule and monitor jobs using tools like Control-M
• Perform data validation, testing, and ensure high data quality
• Troubleshoot pipeline failures and performance bottlenecks
• Work with semi-structured data (JSON, Parquet) in Snowflake
• Maintain documentation for data pipelines and models
• Working knowledge of Python for data processing and scripting
• Experience with UNIX/Linux commands and shell scripting
• Familiarity with Control-M or any job scheduling/orchestration tools
• Basic understanding of data pipeline orchestration and monitoring
Qualifications
- Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related field.
- 2-4 years of experience in Data Engineering, ETL/ELT development, or Data Warehousing.
- Hands-on experience with Snowflake and dbt (Data Build Tool).
- Strong SQL skills with experience in query optimization and data transformation.
- Experience designing and maintaining ETL/ELT pipelines.
- Knowledge of dimensional data modeling, including Star Schema and Snowflake Schema.
- Experience working with semi-structured data formats such as JSON and Parquet.
- Basic to intermediate Python programming skills for data processing and automation.
- Proficiency in UNIX/Linux commands and shell scripting.
- Experience with job scheduling and orchestration tools such as Control-M, Airflow, or similar.
- Understanding of data quality validation, testing, monitoring, and troubleshooting.
Salary : $80,000 - $100,000