We are currently looking for an exceptional Data Engineer to join our team.

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.

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
• Expertise in the design and development of SSIS packages
• Experience with data warehouse development e.g. building fact and dimension tables with complex transformations and type 1 and type 2 changes
• Experience with SQL Server SSAS and data cubes.
• Knowledge of best practices around indexing and query performance
• Experience working with clients throughout all phases of a development project

We would really appreciate any experience on:

• Azure SQL / Data Warehouse / Azure Data Factory / Analysis Services
• AWS RDS / Redshift / Athena / Glue / Kinesis
• No SQL Databases - MongoDB / DynamoDB / Cosmos DB
• Business Intelligence tools such as Tableau/Power BI/Quicksight
• PowerShell scripting and automation

You will be working in a vibrant environment, so you can never expect to have just another typical day at work. It’s definitely not your comfort zone, but you will never get bored, that is a promise. 

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!