DATA ENGINEER

← Back to all jobs
Open position

DATA ENGINEER

Department: Software Development Work mode: hibrid Contract: permanent

ABOUT THE ROLE

As a Senior Data Engineer, you will play a key role in designing, building, and maintaining a scalable and secure data platform centered around Snowflake. You will work with data coming from multiple systems and technologies, developing reliable ingestion and transformation pipelines while ensuring data quality, performance, and availability across DEV, UAT, and PROD environments.

The role combines hands-on data engineering with platform ownership. You will be involved in architecture decisions, complex data migrations and integrations, security and access management, as well as performance and cost optimization. You will work with technologies such as Snowflake, Python/Snowpark, Azure Storage, REST APIs, Oracle, and Microsoft SQL Server to deliver robust data solutions that support reporting and business needs.

RESPONSIBILITIES

  • Defining an optimal architecture
  • Implementing and maintaining tables in Snowflake according tothedefined schema.
  • Building ingestion pipelines from multiplesources: GLfiles (Micros/Simphony) via AzureSFTP orAzure Blob Storage with Snowpipe, POSdata via RESTAPI, Microsoft SQLServer via direct connection, ERP Microsoft Dynamics.
  • Migrating historical data from Oracle – a 280GBdatabase with tablesover 100M rows.
  • Developing and maintaining SnowflakeTasks and Streams for incremental processing.
  • Writing SQL logicfordata transformationfor final reports.
  • Automating the reconciliation of fiscal Z reports (POSvs ERP vs fiscal printer).
  • Setting up and managing DEV, UAT, and PRODenvironments in Snowflake.
  • Managing users, roles, and permissions across all environments.
  • Monitoring and optimizing warehousesizing and computecosts.
  • Implementing and maintaining security policies and data accesscontrols.
  • Maintaining platform documentation: environments, roles, access matrix.

REQUIREMENTS

  • 3+ years of experience with Snowflake (Tasks, Streams, Snowpipe, Snowpark)
  • Proficiency in Python or Snowparkfor scripting and automation ingestion
  • Knowledge of Snowflake RBAC: roles, privileges, ownership
  • Understanding of Snowflake security: network policies, data masking
  • Advanced SQL skills: windowfunctions, mergestatements, complex transformations
  • Experience with AzureStorage, Storage, and SFTPflows
  • Multi-environment management (DEV/UAT/PROD)
  • Data migrationfrom Oracleor MS SQLServer (plus)
  • RESTAPI integration and semi-structured data processing (JSON/VARIANT)
  • Familiarity with Medallion Architecture (Bronze/Silver/Gold)
  • Expertise in cost management and Snowflake warehouse optimization
  • SnowflakeSnowPro CoreorAdmin certification (plus)

NICE TO HAVE

  • Hands-on experience with large-scale data migrations and high-volume datasets
  • Experience designing and implementing end-to-end data architectures
  • Experience with Oracle and/or Microsoft SQL Server migrations
  • Familiarity with Microsoft Dynamics or other ERP/POS systems
  • Experience working with semi-structured data (JSON/VARIANT) and REST API integrations
  • Good understanding of Medallion Architecture (Bronze/Silver/Gold)
  • Experience with data reconciliation and data quality processes
  • Strong understanding of Snowflake performance tuning and cost optimization
  • Experience with CI/CD and automation for data platform deployments
  • Knowledge of data governance, security, and access management best practices
  • Snowflake SnowPro Core, SnowPro Advanced, or Admin certification

Apply for this role

The secure application form will be added in the next step.