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]