1-2 Data Engineers – Cloud migration of ETL and BI

By 23 mars, 2020 april 1st, 2020 Data/IT
Roll BI
 Kompetensområde Data/IT
 Startdatum 2020-04-13
 Slutdatum 2020-12-31
 Omfattning 100%
 Ort Stockholm
Land Sweden
 Sista svarsdatum 2020-03-26 (Offerter kommer att behandlas löpande)
 Kontaktperson Edwin Landgraff (cv@keyman.se)
 Referens nr 1875368
Övergripande uppdragsbeskrivning

We are now looking for 1-2 Data Engineers – within cloud migration of ETL and BI, to our customer.

Description Working tasks:
Our customer is looking for a senior consultant data engineer to contribute to their significant effort of migrating an extensive data warehouse, with its ETL process, data and reporting solutions to an AWS cloud environment.

The solution to be migrated houses historic data of financial trades from decades back.

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

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.

Skallkrav

An academic degree in relevant field
At least 5 years of relevant working experience
Experience migrating data solutions into AWS
Mastery of AWS and Redshift
Expertise in data warehousing (normalized data models, slowly changing dimensions, ETL processes etc) in a SQL Server environment
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
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
Fluent in English, both written and spoken

Börkrav

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

Övriga krav

Offert för detta uppdrag måste skickas in via KeySourcingTool. Svar via mail kommer att få begränsad feedback
Om konsulten anlitas för uppdrag hos kunden kommer en bakgrundskontroll att genomföras (bl.a. utdrag från belastningsregistret) vilket konsulten härmed godkänner.
CV måste vara på engelska. Bifogas i wordformat under fliken Dokument.

Personliga egenskaper

Structured
Analytical
Thorough in your work -in order to handle a migration of an extensive and complex solution at the end of its lifecycle.

Övrig information

Start as soon as possible, upon agreement.

För eventuella frågor kontakta Edwin Landgraff på 076-765 40 46.

 


 

Att offerera på detta uppdrag

OFFERERA PÅ DETTA UPPDRAG VIA KEYSOURCINGTOOL (Prioriterad)

Mailofferter ska innehålla följande information

  1. Konsultens CV bifogat (helst i Wordformat)
  2. En kortfattad summering (ska beskriva konsultens kompetens jämfört med uppdragets krav och behov)
  3. Konsultens timarvode (SEK exkl moms)
  4. Konsultens tillgänglighet (Startdatum och omfattning)
  5. Bekräftelse på att ni accepterar, GDPR och “KeyMans allmänna villkor”

OFFERERA PÅ DETTA UPPDRAG VIA E-POST
OBS! Begränsad återkoppling erhålls för offerter som kommer via e-post.


 

Tillbaka till aktuella uppdrag