Wise IT logo

Wise IT Stockholm Heltid

Data Engineer – Cloud migration of ETL and BI

Detta jobb är inaktivt och går inte att söka längre.

About the job

Job description

We are looking for a senior consultant data engineer to contribute to the significant effort of migrating an extensive data warehouse, with its ETL process, data and reporting solutions to an AWS cloud environment.

Location: 100% Onsite Stockholm
Start: July 19th – April 18th 2022

Must Haves:

  • +10 years of relevant working experience in database area
  •  Experience migrating data solutions into AWS
  • Expertise in data warehousing in a SQL Server environment

Roles and responsibilities for the consultants

  • Contribute to the migration of a data warehouse and BI environment from a traditional to an AWS cloud platform, by providing AWS expertise and applying best practice
  • Gather requirements and communicating them to developers
  • Suggest design improvements in the areas of data modelling, BI layers and report
  • Ensuring business documentation of requirements and solutions
  • Contributing to and coordinating with SMEs regarding quality assurance, testing and reconciliation
  • Identify opportunities to streamline, simplify or reduce the existing scope of reports and solutions
  • Support analysts and other data consumers in the transition to the new cloud environment, including support with data queries, trouble shooting and training

The migration will cover: 

  • ETL solutions in SQL Server (stored procedures, SSIS) and the occasional command, R or Python scripts
  • SQL Server data warehouse, with several databases and data models, including the historic data
  • QlikView apps and their dashboards and their server-side views
  • A SAP Business Objects universe and an extensive set of reports used by several business stakeholders

We expect the consultants to have

  • A degree in relevant field
  • +10 years of relevant working experience in database area (must)
  • Experience migrating data solutions into AWS (must)
  • Mastery of AWS
  • Expertise in data warehousing (normalized data models, slowly changing dimensions, ETL processes etc) in a SQL Server environment (must)
  • Expertise in how to work in and govern production environments, and ensuring documentation throughout product lifecycle
  • Experience from business intelligence tools SAP Business Objects and QlikView (desired)
  • Experience in designing solutions, creating reports and dashboards to allow leveraging Tableau and Pentaho reporting/BI solutions across business areas through scalability and maintainability Experience working with and designing solutions for large data volumes – millions or 100x observations daily (desired)
  • Fluent English language skills

It would be great if the consultants have (desired)

  • Broad experience with cloud service providers and relevant micro services
  • Experience with programming languages R and Python, and scripting languages powershell and vbasic
  • Familiarity with trading data; trades and quotes
  • A good understanding of statistical analysis and advanced analytics

In order to succeed in this role, we believe that you are structured, analytical and thorough in your work in order to handle a migration of an extensive and complex solution at the end of its lifecycle

Bild #0 - Wise IT
Bild #1 - Wise IT
Bild #2 - Wise IT

Uptrail AB • Katarinavägen 15, 116 45 Stockholm
© 2014-2022