Staff Cloud Data Engineer (d/m/f)

Alerta Emprego; Portugal; Híbrido; EUR 70 000 - 100 000; Tempo integral

Resumo da oferta

ams OSRAM seeks a senior data engineer to design and optimize cloud-based data solutions that meet business needs. You will collaborate with data scientists and analysts to translate requirements into scalable data models and robust pipelines.

The role requires 5+ years in data engineering, strong SQL/Python skills, and experience with Snowflake, Databricks, and Power BI. Hybrid work model offered with a focus on data security and governance.

Qualificações

• Bachelor’s degree or higher in CS, Software Eng or similar.
• Minimum 5 years of experience with cloud data warehouse technologies (Snowflake/Databricks).
• Hands-on data warehouse modelling (Data Vault 2.0 or Star Schema).
• Strong SQL and ETL framework knowledge.
• Experience with Python for data staging and data pipelines.
• Proficient in data visualization with Power BI.
• Experience with NiFi, Azure Data Factory and data integration tools.
• Knowledge of data security and governance practices.

Responsabilidades

• Work with data scientists and analysts to translate data requirements into models.
• Design and implement cloud-based data solutions aligned with business needs.
• Share knowledge and best practices across the team.
• Build scalable data pipelines from multiple source systems.
• Apply business rules using SQL or Python.
• Secure data models with object and row-level security.
• Document best practices and promote their adoption across the team.
• Address data integrity issues and optimize pipelines.
• Communicate effectively with stakeholders about issues and solutions.
• Optimize data transfer costs and throughput.
• Continuously monitor and improve pipeline performance.

Conhecimentos

Cloud data warehouse

SQL

Python

Data modelling

ETL frameworks

Data visualization

Power BI

dbt

Apache Airflow

Data governance

Formação académica

Bachelor’s degree in Computer Science, Software Engineering or similar

Ferramentas

Snowflake

Databricks

Power BI

Apache NiFi

Theobald Universal Xtract

Azure Data Factory

dbt

Apache Airflow

Descrição da oferta de emprego

• Bachelor’s degree and above in Computer Science, Software Engineering or similar
• Minimum 5 years of related working experience with cloud data warehouse technologies, preferably Snowflake and/or Databricks
• Hands-on experience in data warehouse modelling preferably with data vault 2.0 and/or star schema
• In-depth understanding of relational databases (SQL) and ETL (Extract, transform, load) frameworks
• Experienced in data staging with SQL and Python, data visualization with tools such as PowerBI, data integration using Apache NiFi, Theobald Universal Xtract, and Azure Data Factory, as well as orchestrating data pipelines with dbt and Apache Airflow
• Problem-solving attitude and excellent communication skills
• Excellent organizational skills with the ability to communicate project goals and objectives, project status and deliverables
• Fluent in English for communicating with global teams and stakeholders

• Work closely with data scientists, business analysts and other stakeholders to understand their data requirements and translate them into technical specifications and data models
• Collaborate with data architects to design and implement cloud-based data solutions that align with business needs
• Facilitate internal knowledge sharing to ensure team members are informed about the latest best practices
• Implement scalable and robust data pipelines from various source systems
• Apply business rules and transformations using SQL or Python
• Secure data models applying object and row level security
• Develop and document best practices and ensure they are effectively implemented across the team
• Analyze and address issues related to data integrity, data design and both functional and technical aspects of the Cloud Data Warehouse
• Communicate effectively about issues, solutions, and best practices with relevant stakeholders
• Perform cost and performance-based optimization of data transfer processes
• Continuously monitor and improve the efficiency and performance of data pipelines

• Work Model: Hybrid 50 %

ams OSRAM is an Equal Employment Opportunity Employer. Diversity, equity and inclusion is strongly established in our corporate culture and we firmly believe it makes us more successful as a company. All qualified applications will receive consideration for employment regardless of ethnic, national or social origin, gender, gender identity, sexual orientation, color, religion, age, physical and mental abilities.