Senior Data Engineer (Cybersecurity)

Sigma Software

About The Position

Join a high-impact cybersecurity project focused on protecting applications from automated attacks and malicious activity. The Senior Data Engineer will be a core member of a small, proactive engineering team working on a large-scale cybersecurity product. The role involves understanding existing systems, including legacy code and interconnected services, identifying inefficiencies and technical gaps, and driving improvements across the platform. The project develops and improves a cybersecurity solution that protects applications from automated attacks and malicious traffic. The team builds and maintains scalable, high-performance data infrastructure for security analytics, monitoring, and detection. The role combines modernization of legacy systems with the development of reliable and scalable data workflows, in close collaboration with cross-functional engineering teams. The engineer will maintain and enhance data processes, optimize pipelines and complex SQL queries, contribute to technical and architectural decisions, and support both near-term delivery and long-term platform evolution. Key technologies include Snowflake, DBT, SQL, Python, Elastic Stack, and Airflow.

Requirements

At least 5 years of commercial experience in Data Engineering.
Expert-level Python skills.
Expert-level SQL skills, including practical experience optimizing complex queries for performance and scalability.
Strong hands-on experience with DBT for data transformation and modeling.
Solid understanding of database concepts, including DDL, DML, indexing, normalization, and advanced SQL techniques.
Hands-on experience working with Snowflake.
Experience with Elastic Stack technologies.
Proven experience designing, building, and maintaining large-scale data pipelines.
Strong analytical thinking and problem-solving skills.
Ability to work independently in a high-autonomy engineering environment.
Experience driving technical initiatives from idea through implementation.
Strong communication and collaboration skills.
Upper-Intermediate English level or higher.

Nice To Haves

Experience with Airflow for workflow orchestration.

Responsibilities

Maintain and enhance existing data processes, focusing on reliability, scalability, and performance optimization.
Analyze existing data models, workflows, tables, and processing jobs in depth.
Identify technical gaps, bottlenecks, inefficiencies, and opportunities for architectural improvements.
Design, optimize, and support large-scale data pipelines and transformation processes.
Drive modernization initiatives across the data platform and contribute to its long-term architectural evolution.
Optimize complex SQL queries and improve data-processing latency and efficiency.
Collaborate with product engineering and cross-functional teams on technical solutions and implementation strategies.
Contribute to short-term delivery goals and long-term platform development initiatives.
Ensure adherence to data engineering, system reliability, and performance optimization best practices.
Participate in technical discussions, solution design, and continuous improvement initiatives.