Snowflake Expert (m/f/d)

Amadora, 11
Portugal


Job Description

Siemens Global Business Services (GBS) enables Siemens units worldwide and external customers to accelerate their business transformation into a sustainable and digital future.

Our goal is to optimize processes and provide services driven by expertise, in areas such as business administration, human resources, supply chain management, sales, marketing, and engineering. Through innovation and digitalization, we facilitate the achievement of a successful and sustainable transformation.

In our GBS Western Europe and Africa Hub we are already more than 1400 connected people, from over 57 different nationalities spread across 14 countries. Check here, and get to know more about GBS.

Are you ready to be part of the change? Come join us!

Your mission will be…

·       Architect and Design: Develop scalable and efficient data solutions using Snowflake, focusing on Iceberg tables for optimal performance and flexibility.

·       Integration: Integrate real-time data from various Siemens organizations into our data lake, ensuring seamless data flow and processing.

·       Data Lake Management: Design and manage a large-scale data lake using AWS services like S3, Glue, and Lake Formation.

·       Data Transformation: Apply various data transformations using dbt to prepare data for analysis and reporting, ensuring data quality and consistency.

·       Performance Optimization: Optimize data processing pipelines for performance, scalability, and cost-efficiency.

·       Data Modeling: Design and implement data models to support the creation of data products.

·       Security and Compliance: Ensure that all solutions adhere to security best practices and compliance requirements.

·       Collaboration: Work closely with cross-functional teams, including data engineers, data scientists, and application developers, to deliver end-to-end solutions.

·       Monitoring and Troubleshooting: Implement monitoring solutions to ensure the reliability and performance of data pipelines. Troubleshoot and resolve any issues that arise.

We are looking for someone with…

·       Experience: at least 5 years in Data Lake Projects, 4+ years in Snowflake, and 2+ years in AWS services bringing extensive expertise in optimizing large-scale data Projects

·       Technical Skills: Deep knowledge of Snowflake, including Iceberg tables, and experience with dbt. Must have knowledge of DBT, Snowflake SQL, Procedures, Snowpipes, Stages,UDF’s, Streams, Table functions

·       AWS Services: Familiarity with AWS services like S3, Glue, and Lake Formation.

·       Data Transformation: Expertise in applying data transformations within Snowflake using dbt.

·       SQL Proficiency: Strong skills in writing and optimizing SQL queries.

·       Data Modeling: Knowledge of data modeling techniques and best practices.

·       Big Data Technologies: Basic Knowledge of big data technologies such as Apache Spark, Hadoop or Flink.

·       Performance Optimization: Skills in optimizing Snowflake data pipelines for performance and cost-efficiency.

·       Security and Compliance: Understanding of Snowflake security best practices and compliance requirements.

·       Collaboration: Ability to work effectively with cross-functional teams.

·       Monitoring and Troubleshooting: Experience in implementing monitoring solutions and troubleshooting issues.

·       Certifications: Snowflake certifications are a plus.

What you can expect from us…

A hybrid and flexible working model to promote a better work-life balance, along with a budget for home office support and the opportunity to do 16 hours a year of volunteer work. A health insurance, access to our on-site medical center, plus the chance to join sports groups.

In addition, you'll have access to online learning platforms and discounts with our partners. A shuttle bus to commute to the facilities and the possibility of financial support to your studies.

What makes us proud as an employer:

·       Merco – Companies and Leaders with the Best Reputation in Portugal (#1 Tecnology/Manufacturing)

·       Forbes – World’s Best Employers (#1 Engineering & Manufacturing)

·       LinkedIn – LinkedIn Top Companies (#2)

·       OnStrategy – REPSCORE 2024: Brands’ Reputation in Portugal (#1 Engineering & Electronic Services)

·       Fortune – World’s Most Admired Companies (#1 Industrial Machinery)

·       SSON – Top 20 most admired Shared Services Organizations and Global Business Services in 2024

Please attach your CV in English.

#Siemens #PeopleAtSiemens #GBSpartnerofchoice

Siemens is committed to creating a diverse environment and is glad to be an equal opportunity employer. We strongly encourage applications from a diverse talent pool!