DATA ENGINEER

Department: Software Development

Location: Bucharest

Work mode: Hybrid

Contract: B2B, Employment (fixed-term)

About the Position

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 to the defined schema
Building ingestion pipelines from multiple sources: GL files (Micros/Simphony) via Azure SFTP or Azure Blob Storage with Snowpipe, POS data via REST API, Microsoft SQL Server via direct connection, ERP Microsoft Dynamics
Migrating historical data from Oracle – a 280GB database with tables over 100M rows
Developing and maintaining Snowflake Tasks and Streams for incremental processing
Writing SQL logic for data transformation for final reports
Automating the reconciliation of fiscal Z reports (POS vs ERP vs fiscal printer)
Setting up and managing DEV, UAT, and PROD environments in Snowflake
Managing users, roles, and permissions across all environments
Monitoring and optimizing warehouse sizing and compute costs
Implementing and maintaining security policies and data access controls
Maintaining platform documentation: environments, roles, access matrix

Requirements

3+ years of experience with Snowflake (Tasks, Streams, Snowpipe, Snowpark)
Proficiency in Python or Snowpark for scripting and automation ingestion
Knowledge of Snowflake RBAC: roles, privileges, ownership
Understanding of Snowflake security: network policies, data masking
Advanced SQL skills: window functions, merge statements, complex transformations
Experience with Azure Storage, Storage, and SFTP flows
Multi-environment management (DEV/UAT/PROD)
Data migration from Oracle or MS SQL Server (plus)
REST API integration and semi-structured data processing (JSON/VARIANT)
Familiarity with Medallion Architecture (Bronze/Silver/Gold)
Expertise in cost management and Snowflake warehouse optimization
Snowflake SnowPro Core or Admin 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

We Offer

Competitive salary
Opportunity to work in a dynamic and innovative environment
Professional development opportunities
Flexible working hours and remote work options

About the Company

[Company description if present]

Code932

Open jobs

DATA ENGINEER

Similar companies