Data Engineer Snowflake/dbt

Who we are.

We are a team of passionate experts with a clear ambition: applying digital technology to advance what matters for our clients and society.

Together we createreliable and responsive digital foundations for the world’s businesses, institutions, and communities.

With a 10 year history in Romania and over 2000 employees, Atos has a presence in 2 of the largest cities in Romania: Bucharest and Timisoara. Our Global Technology Center in Romania offers cutting-edge, best in class, end-to-end IT services for clients located around the world.

Learn more on Advancing what matters

About the Role

We are seeking an experienced Data Engineer to join our team and contribute to the design, development, and maintenance of our Snowflake and dbt-based data pipelines. You will be responsible for implementing robust ELT solutions that efficiently transform data and provide valuable insights to the organization.

Key Responsibilities

• Design, develop, and maintain high-performance ELT data pipelines using Snowflake and dbt
• Model data at both conceptual and technical levels based on business requirements
• Optimize SQL queries and dbt models to ensure optimal performance
• Implement and maintain DataOps infrastructure for deployment automation
• Configure and manage data security (RBAC, Row-Level Security, Dynamic Data Masking)
• Ensure efficient data ingestion from AWS S3 to Snowflake
• Orchestrate data flows through dbt and create DAGs with proper tag management
• Implement data quality testing via dbt tests
• Manage administrative aspects of Snowflake databases

Required Technical Skills

• Snowflake:
• Mastery of advanced Snowflake features (Time Travel, Zero-Copy Cloning)
• Configuration and optimization of Snowflake warehouses
• Management of external stages and Snowpipe for ingestion from AWS S3
• Configuration and implementation of RBAC, RLS, and Dynamic Data Masking security mechanisms
• Snowflake database administration (object creation/management, monitoring, optimization)
• dbt (data build tool):
• Advanced SQL model development in dbt
• Creation and optimization of data models (dimensions, facts, etc.)
• Use of Jinja macros to create dynamic and reusable SQL code
• Configuration of dbt tests for data validation
• Implementation of dbt snapshots for change tracking
• Creation of optimized DAGs with proper tag and dependency management
• Data model documentation
• DataOps & Automation:
• Use of schemachange for schema migration automation
• Continuous integration and deployment (CI/CD) for data pipelines
• Experience with Git and collaborative development workflows
• AWS & Integration:
• Knowledge of AWS S3 and its integration with Snowflake
• Configuration of external stages and ingestion processes

Preferred Qualifications

• Experience with Snowflake Tasks and Dynamic Tables
• Knowledge of data mesh and data governance principles
• Familiarity with data testing frameworks
• Experience in pharmaceutical or life sciences industry

Certifications (Preferred)

• SnowPro Core Certification - highly valued
• dbt Analytics Engineering Certification - a plus
• AWS certifications (Solutions Architect, Data Engineer, or similar) - a plus

Soft Skills

• Excellent problem-solving skills and analytical mindset
• Rigor and attention to detail
• Ability to work in a team and communicate effectively
• Adaptability to an evolving technical environment

Experience and Education

• Minimum 3-5 years of experience in data engineering
• Significant experience with Snowflake and dbt
• Degree in Computer Science, Data Science, or similar field

Advanced Snowflake certifications appreciated (SnowPro Advanced

Learn more about us:

At Atos, we embrace diversity as the ultimate engine of ingenuity for our clients, and we constantly strive to create a culture where people feel supported and encouraged. Read more about our commitment here.

Whether it is fighting climate change, promoting digital inclusion, or ensuring trust in data management - tech for good sits at the core of our identity. With numerous global recognitions for our ESG practices, we are committed to building a better future for all by harnessing the power of technology. Learn more here.