We are seeking a Senior Data Engineer with strong experience in Snowflake, high-volume data processing, and geospatial datasets to support one of our clients in enhancing their data ecosystem. This role is ideal for someone who enjoys solving complex data challenges, optimizing pipelines, and working with large-scale, high-performance architectures, particularly within the AdTech domain.

About First Factory

We are a software development company with over two decades of experience, boasting a dynamic team of 175+ professionals actively engaged in diverse projects across various industries. We invite you to join us on this journey as we thrive and embrace fresh challenges.

Key Responsibilities

• Design, build, and optimize large-scale data pipelines and ETL workflows.
• Implement and maintain data models, transformations, and testing using DBT or similar tools.
• Work with Snowflake to design performant schemas, optimize compute usage, and ensure data quality.
• Handle high-volume data processing, including ingestion, transformation, and aggregation for analytical and transactional needs.
• Design and operate workflows that leverage AWS services (e.g., S3, Lambda, Step Functions).
• Perform advanced SQL development, including analytical queries, indexing strategies, and performance tuning.
• Integrate and process geospatial data, using frameworks such as H3 and geospatial SQL operations.
• Support AdTech-related data flows involving impressions, pixels, events, and campaign performance metrics.
• Collaborate with cross-functional teams to define requirements, ensure alignment, and deliver reliable, well-structured data solutions.
• Promote engineering best practices, code quality, and scalable design patterns.

Requirements

• 7+ years of experience in data engineering or backend engineering with a strong data focus.
• Strong hands-on expertise with Snowflake (performance tuning, scripting, compute optimization).
• Experience with high-volume data processing and distributed ETL pipelines.
• Advanced SQL skills, including optimization, indexing, and analytical functions.
• Experience with DBT for modeling, transformations, and testing.
• Strong knowledge of AWS data workflows, especially S3-based architectures.
• Experience with Kubernetes (AKS preferred) for deployment and operational workflows.
• Solid understanding of data structures, algorithms, and software engineering best practices.
• Experience working with event-driven or streaming data systems (nice if present).
• Strong communication and collaboration skills.

Nice to have

• Experience in the AdTech ecosystem (DSPs, pixels, impressions, attribution, audience data).
• Familiarity with geospatial operations, such as H3, ST_WITHIN, or geospatial indexing.
• Experience with analytics engineering practices.