Data Engineer – Cloud migration of ETL and BI

By 20 oktober, 2020 december 4th, 2020 Data/IT
Roll Övrig
 Kompetensområde Data/IT
 Startdatum 2020-11-09
 Slutdatum 2021-09-30
 Omfattning 100%
 Ort Stockholm
Land Sweden
 Sista svarsdatum 2020-10-23 (Offerter kommer att behandlas löpande)
 Kontaktperson Edwin Landgraff (cv@keyman.se)
 Referens nr 2160861
Övergripande uppdragsbeskrivning

We are now looking for a Lead Software Engineer to our customer.

Description Working tasks:
We are looking for a senior consultant data engineer to contribute to our customer´s 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, with extensive reference data.

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 applying best practices, performing migration and implementing potential improvements to the Kimball-based data model
• Gather requirements and ensure good communication with stakeholders and other 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
• SAP Business Objects universes 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

A degree in relevant field
Many years of relevant working experience
Experience designing data models and migrating data warehouses
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, preferably 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
Mastery of AWS and Redshift
Experience with programming languages R and Python, and scripting languages powershell and vbasic
Familiarity with trading data; trades, orders 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

För eventuella frågor kontakta Edwin Landgraff mobilnummer 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