Middle Data Engineer

Sigma Software

20h•Remote

About The Position

Join a remote engineering team building and maintaining scalable, cloud-based data platforms for analytics, reporting, business intelligence, and operational decision-making. The role focuses on developing and optimizing ETL/ELT pipelines, data transformations, data models, datasets, integration solutions, and cloud-based data architectures using distributed processing technologies and cloud infrastructure. The engineer will help ensure data quality, consistency, and reliability, and contribute to platform performance and continuous improvement. The position involves collaboration with analysts, engineers, and business stakeholders, as well as participation in code reviews and technical discussions. It also includes troubleshooting pipeline and performance issues and creating and maintaining technical documentation. The team values collaboration, continuous learning, knowledge sharing, and technical excellence. The role is suited to an engineer interested in developing expertise in modern data engineering practices and growing within a remote team.

Requirements

At least 3 years of experience in Data Engineering or Software Engineering.
Upper-Intermediate English level.
Strong SQL skills and understanding of relational and dimensional data modeling.
Hands-on experience with Python for data processing and automation.
Experience building and maintaining ETL/ELT pipelines.
Hands-on experience with Databricks and Apache Spark.
Experience working with Snowflake.
Understanding of data warehousing and modern data platform concepts.
Experience working with cloud environments, preferably AWS.
Familiarity with CI/CD, Git, and software engineering best practices.
Strong analytical, troubleshooting, and communication skills.

Nice To Haves

Experience with streaming data processing.
Knowledge of orchestration tools such as Airflow or Dagster.
Experience with infrastructure as code practices.
Familiarity with data quality and observability frameworks.
Exposure to large-scale distributed data systems.
Experience working in Agile environments.

Responsibilities

Design, develop, and maintain ETL/ELT pipelines.
Build and optimize data transformations for analytics and reporting needs.
Develop and maintain data models, datasets, and integration solutions.
Ensure data quality, consistency, and reliability through testing and monitoring.
Troubleshoot and resolve data pipeline and performance issues.
Collaborate with analysts, engineers, and business stakeholders to deliver data-driven solutions.
Contribute to the development and maintenance of cloud-based data platforms.
Participate in code reviews and technical discussions.
Create and maintain technical documentation for implemented solutions.
Continuously improve existing data processes and platform performance.