Summary

The job is for a Data Engineer at Satori, an analytics agency in South-Eastern Europe. The role involves working with Solution Architects, Developers, Data Engineers, Product Owners, Business Analysts, Project Managers, and QAs to ensure the validity of work. Responsibilities include participating in agile meetings, liaising with clients/BAs/Product Owners, creating and maintaining ETL pipelines, performing technical analysis for data migration, ensuring automated tasks run smoothly, documenting current data processes, and having experience with SQL Server 2012-2019, Python and/or Pyspark, Data warehouse development, client facing business analysis, and fluent English.

Requirements

SQL Server 2012 – 2019 - Data Engineering / DBA experience
Python and/or Pyspark
Data warehouse development e.g., building fact and dimension tables with complex transformations and type 1 and type 2 changes
Knowledge of best practices around indexing and query performance
Client facing business analysis and requirements gathering
Experience working with clients throughout all phases of a development project
Fluent English, spoken and written
At least 1 year experience working hands on in a Cloud environment
Experience in the design and development of SSIS packages

Responsibilities

Participate in agile meetings such as daily stand ups, sprint planning and retrospectives
Liaise with clients / BAs / Product Owners to understand detailed requirements
Participate in design sessions with a Solution Architect, Developers, and other Data Engineers
Create, enhance and maintain current business logic, normally through the use of SQL stored procedures, for both OLTP and OLAP systems
Create, enhance, and maintain ETL pipelines using technologies such as Azure Data Factory/Databricks
Perform technical analysis for migrating on-premise data to a hybrid or fully cloud based data infrastructure
Migrate on-premise databases to the cloud. This includes all aspects of an on premise system for example SSIS packages, Analysis services, Reporting services, Roles and Permissions, extended stored procedures etc
Ensure that all automated tasks are running smoothly
Document current data processes

Preferred Qualifications

Databricks and/or Snowflake
ETL / Connector technologies (such as Airbyte / Airflow / dbt)
No SQL Databases - MongoDB / DynamoDB / Cosmos DB
Business Intelligence tools such as Tableau / Power BI / Quicksight
PowerShell scripting and automation
Working in an Agile team

Benefits

Competitive salary based on experience
Hybrid work model: amazing offices in the center of Athens and flexibility to work from home or remotely (fully remote work if you live in the EU also an option)
Dedicated training time and budget for courses in Greece, London or/and online
Dedicated time and budget for official certifications
Private Insurance
A great and fast laptop to do your magic
Opportunity to work with latest tech stack and real tech experts
Also: Living abroad and thinking of relocating to Greece? Let us know and we will try to make your decision easier!

Satori Analytics is hiring a Data Engineer