Senior Data Engineer

Satori is an Analytics Agency made with one simple vision: to give clarity in decision making through data analytics.

Whether it’s a cloud-based big data ecosystem for a global fintech or a machine learning model predicting churn for a leading airline group, Satori develops cutting edge analytics solutions, providing real value to its clients. Services cover the whole data lifecycle from ingestion and warehousing to ML and AI applications.

Satori is a scale-up, well on track to become the leading data and analytics company in South-Eastern Europe and already a 95+ specialized tech team, consisting of Data Engineers, Data Scientists, Software Engineers, QAs, and CRM Specialists, delivering innovative data, tech, and customer experience solutions. The majority of our clients are household names and global brands in FMCG, retail, ecommerce, financial services, and travel, with a footprint in Greece but also across Europe and beyond.

We are currently looking for a Senior Level Data Engineer to join our team!

Your day to day

You will be working in a vibrant, fast-paced environment, so you can never expect to have just another typical day at work. Sometimes you will feel out of your comfort zone, but you will probably never feel bored! 

As part of the team, you will work with Solution Architects, Developers, Data Engineers, Product Owners, Business Analysts, Project Managers, and QAs to ensure the validity of work. You will also liaise with clients and stakeholders as part of a project team. You will be using the latest tools, techniques and methodologies.

On any particular day you will be doing several of the following:

• 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.

• Perform technical analysis for migrating on-premise data to a hybrid or fully cloud based data infrastructure, that is a state of the art, modern, and scalable data estate.

• 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.

We guarantee one thing, working with the latest cloud tech stack and investing in your continuous growth and development!

Requirements

Your professional expertise

You are at home in many different aspects of Data Engineering, whether it’s creating stored procedures to upsert data into Fact and Dimension tables or migrating data from one system to another.

Let's talk numbers!

You are expected to have 3+ years minimum experience on:

• SQL Server 2012 – 2019 – Data Engineering / DBA experience.

• At least one cloud technology (AWS, GCP, Azure).

• Experience with 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.

• Experience with SQL Server SSAS and data cubes.

• Experience in the design and development of SSIS packages.

You will stand out if you have  +2 years minimum experience working hands on a clo