lock-svg project Successfully occupied
View offer information dropdown icon
Wallet icon Coin icon Rate 280 € - 360 € / man-day
Timer icon Form of cooperation Full-time / 95% Remote
Briefcase icon Sector Energy
Location icon Location Praha
Project duration 24 months with the possibility of extension
Period of cooperation 01.10.2024 - 30.09.2026
Start date ASAP or by agreement
Technology
  • MS SQL Server
  • ETL
  • SSAS SQL Server Analysis Services
  • SSIS SQL Server Integration Services
Languages
  • English flag English - active, B2/C1/C2
  • Slovak or Czech flag Slovak or Czech - active, B2/C1/C2

Project description

  • cooperation in the creation of new and maintenance of existing solutions on an established project in the field of energy
  • design, development, testing, optimization and implementation of ETL processes
  • development and support of mapping from various data sources to DWH and Data Marts
  • support of implemented solutions, their expansion and modification
  • root cause analysis, design and development of problem fixes and change requests
  • cooperation with business analysts and users
  • cooperation within the entire testing cycle, especially unit, regression and UAT testing
  • cooperation on the creation of documentation
  • cooperation possible in almost complete REMOTE mode + occasional ON-SITE ad-hoc as needed [Czech Republic]
  • the final reward depends on the experience of the candidate and the progress of the selection process

Project requirements

  • min. 4 years of proven experience with application development with advanced experience in the field of DWH development
  • min. 2 realized customer projects in the field of 3-layer Data Warehouse development in the Microsoft SQL database environment
  • advanced experience with:
    • by developing ETL processes
    • SQL databases
    • Microsoft SQL Server Management Studio [SSMS]
    • Microsoft SQL Server Integration Service [SSIS]
    • Microsoft SQL Server Analysis Services [SSAS]
  • experience with/with:
    • knowledge of Microsoft SQL Server
    • tuning and optimizing the performance of databases
    • data modeling
  • min. 6-24 months (cumulative for several projects) experience with/with:
    • at least one of the tools: IBM Data Architect, Enterprise Architect or PowerDesigner
    • by modeling the Microsoft data warehouse for a company or companies in the field of distribution, sale or transmission of electricity, gas, heat or water
    • by building a 3-layer Data Warehouse on the Microsoft platform
    • by participating in the implementation of a project or projects, each of which had to have a minimum financial volume of EUR 400,000 excluding VAT (amount for implementation or development without the establishment of infrastructure or any type of license)
  • active knowledge of the Slovak or Czech language at a communicative level (C1-C2)
  • active knowledge of the English language at a communicative level (B2-C1)
  • independence
  • excellent communication skills
  • team player
Are you interested in this project?
Recommend an IT specialist Do you know anyone who could use this project? Recommend him and get a reward 720 €!
New to the world of IT freelancing ?

Freedom, flexibility, greater control over finances and career. Freelancing has evolved and offers much more today. See what's in store for you and how it will change your life.

Are you interested in this project?
Recommend an IT specialist Do you know anyone who could use this project? Recommend him and get a reward 720 €!

32 008

Titans that have
joined us

667

Clients that have
joined us

444 346

Succcessfully supplied
man-days