Data Engineer

Data Engineer – Snowflake Data Platform

About Intelactsoft

Since our creation in 2012, we have been guided by two essential questions:

Is there a way to serve clients better, faster, and smarter?

Do our work and initiatives have a positive impact on people’s lives, be they clients or employees?

Our mission is to create a warm and creative environment where employees and partners collaborate to deliver high-performing technology solutions that make a difference. We embrace challenges, strive for audacious goals, and remain true to our values and beliefs.

We are Intelactsoft. Join us to create a positive impact and help us grow together with you!

About the Project

We are currently running a digital transformation program focused on building a centralized data platform that will serve as the single source of truth for reporting, analytics, and AI capabilities.

The platform integrates data from multiple business-critical systems, including:

• GL Files (Micros/Simphony) via Azure SFTP and Azure Blob Storage
• POS platforms via REST APIs (Pizza Hut, E-commerce)
• Microsoft SQL Server databases
• Oracle historical databases
• Microsoft Dynamics ERP

We are looking for a Data Engineer with strong Snowflake expertise to help design, build, and operate the end-to-end data platform, covering data ingestion, transformation, governance, and platform administration.

PLEASE NOTE:

Engagement model: B2B collaboration preferred.

Project duration: Initial engagement of up to 6 months, with the possibility of extension based on project needs and performance.

Working model: Hybrid, with regular on-site presence at the client's office in Bucharest, particularly during the initial phase of the project.

Responsibilities:

• Define and implement the optimal architecture for the Snowflake data platform.
• Design, develop, and maintain Snowflake database structures and data models.
• Build and maintain ingestion pipelines from multiple sources:
• Azure Blob Storage and Azure SFTP using Snowpipe
• REST APIs
• Microsoft SQL Server
• Microsoft Dynamics ERP
• Other operational systems
• Migrate historical data from Oracle databases, including large-volume datasets exceeding 100 million records.
• Develop and maintain Snowflake Tasks and Streams for incremental processing and automation.
• Implement complex SQL transformation logic supporting reporting, analytics, and business requirements.
• Automate reconciliation processes across operational, ERP, and fiscal systems.
• Manage Snowflake environments across DEV, UAT, and PROD.
• Administer users, roles, permissions, and access controls.
• Monitor and optimize Snowflake warehouse sizing, performance, and compute costs.
• Implement and maintain security controls, governance standards, and access policies.
• Create and maintain technical documentation, including environment setup, access matrices, and platform architecture.
• Collaborate closely with business stakeholders, reporting teams, and source system owners.

Tools / Software Knowledge & Competencies:

Mandatory

• 3+ years of hands-on Snowflake experience.
• Strong experience with:
• Snowpipe
• Tasks
• Streams
• Snowpark
• Advanced SQL skills:
• Window functions
• MERGE statements
• Complex transformations
• Performance optimization
• Python and/or Snowpark for automation and ingestion processes.
• Experience integrating data through REST APIs.
• Experience working with semi-structured data (JSON, VARIANT).
• Azure Storage, Azure Blob Storage, and SFTP-based integrations.
• Snowflake RBAC administration:
• Roles
• Privileges
• Ownership
• Experience managing DEV, UAT, and PROD environments.
• Understanding of Medallion Architecture (Bronze / Silver / Gold).
• Experience with Snowflake warehouse optimization and cost management.

Nice to Have

• Experience migrating data from Oracle and/or Microsoft SQL Server.
• Snowflake security administration:
• Network Policies
• Data Masking
• Access Governance
• Experience working in enterprise-scale data platforms.
• SnowPro Core Certification.
• SnowPro Administrator Certification.

Education & Soft Skills:

• Bachelor’s degree in Computer Science, Engineering, Information Technology, or a related field.
• Strong analytical and problem-solving skills.
• Excellent communication and stakeholder management abilities.
• Ability to work independently and take ownership of platform components.
• Detail-oriented mindset with a strong focus on data quality and reliability.
• Collaborative approach and willingness to work across technical and business teams.
• Continuous learning mindset and passion for modern data technologies.

Benefits:

• Access to impactful financial projects.
• Continuous professional development.
• Attractive compensation based on experience.

Advantages:

• Friendly team and collaborative work environment.
• Projects of high complexity.
• Numerous team-building activities.

DISCLAIMER: Only shortlisted candidates will be contacted for the next stages.

Is this interesting enough for you?

Start a conversation with us by email at [email protected].

What’s next?

1. Getting to know each other meeting
2. Technical skills assessment
3. Client meeting
4. Onboarding

Let the challenge begin!

Stalk us!

Website: www.intelactsoft.com

Facebook: facebook.com/intelactsoft