Jr. Data Engineer

We are seeking a motivated Junior Data Engineer with 1+ years of professional experience, including internship experience, to support the development, maintenance, and operation of enterprise data solutions. This role operates in a collaborative, fast-paced engineering environment with guidance and mentorship from senior team members. The ideal candidate will possess strong SQL and Python fundamentals, a solid understanding of data warehousing concepts, and a desire to learn modern cloud-based data technologies while contributing to production support and operational excellence.

Key Responsibilities

• Design, develop, and maintain ETL/ELT data pipelines to support business reporting, analytics, and operational needs.

• Write, optimize, and troubleshoot complex SQL queries, stored procedures, views, and database objects.

• Assist with developing and supporting data pipelines using Python, Snowflake, AWS, Informatica or Apache Airflow/Astronomer, and dbt

• Support data ingestion, transformation, validation, and loading processes across multiple data sources.

• Assist with data warehouse development, including dimensional modeling, fact tables, and dimension tables.

• Monitor production data pipelines and investigate data quality, performance, and reliability issues.

• Participate in on-call support rotations, incident triage, root cause analysis (RCA), and issue resolution activities.

• Provide Level 1 production support for data pipelines, ETL processes, data warehouse objects, and reporting solutions.

• Perform routine maintenance activities, including job validation, configuration updates, data reconciliations, deployment validation, and system health checks.

• Analyze alerts, logs, and monitoring dashboards to identify and resolve operational issues proactively.

• Create and maintain operational documentation, runbooks, support procedures, and knowledge base articles.

• Escalate complex issues to senior engineers while providing detailed troubleshooting findings.

• Collaborate with data engineers, analysts, and business stakeholders to deliver reliable and scalable data solutions.

• Contribute to documentation, code reviews, testing activities, and continuous improvement initiatives.

• Follow engineering best practices for development, deployment, monitoring, support, and maintenance.

Required Qualifications

• Bachelor's degree in computer science, Information Systems, Data Engineering, or a related field.

• 1+ years of hands-on Data Engineering experience, including internship experience.

• Strong SQL skills with experience writing complex queries, CTEs, window functions, joins, aggregations, and stored procedures.

• Knowledge of Data Warehousing concepts, including dimensional modeling, fact and dimension tables, and ETL/ELT processes.

• Experience with Python for data processing, automation, and scripting.

• Experience building, maintaining, or supporting ETL/ELT pipelines.

• Experience with one or more of the following technologies: dbt Core, Informatica or Apache Airflow / Astronomer

• Understanding version control systems such as Git and GitLab.

• Strong analytical, troubleshooting, and problem-solving skills.

• Willingness to participate in an on-call rotation and provide Level 1 production support, including monitoring, troubleshooting, documentation, incident triage, and escalation.

Preferred Qualifications

• Exposure to Snowflake, including SQL development, stored procedures, and cloud data warehousing concepts.

• Exposure to AWS services such as S3, Lambda, Glue, IAM, CloudWatch, and related cloud technologies.

• Exposure to Datadog or similar monitoring and observability platforms.

• Knowledge of at least one data integration, orchestration, or transformation tool, such as Informatica, Apache Airflow, Astronomer, or dbt.

• Basic understanding of ETL/ELT processes, data warehousing, dimensional modeling, and data quality practices.

• Familiarity with GitLab, CI/CD pipelines, and deployment best practices.

• Comfortable participating in production support, incident management, on-call rotations, and troubleshooting activities.

• Understanding of monitoring, alerting, SLA management, and operational support processes.

• Strong communication and collaboration skills with the ability to work effectively in a team environment.

Bachelor's degree in computer science, Information Systems, Data Engineering, or a related field.