lock-svg project Successfully occupied
View project information dropdown icon
Wallet icon Coin icon Rate 140 000 CZK - 180 000 CZK / month info
Timer icon Form of cooperation Full-time
Briefcase icon Sector Information Technology
Location icon Location 100% Remote

info The reward is calculated upon delivery of 20 MD per month (1MD=8h)

Project duration 9 months with possibility of extension
Period of cooperation 03.03.2025 - 03.12.2025
Start date 03.03.2025 or by agreement
Technology
  • AWS Amazon Web Services
  • SQL
  • Sybase Power Designer
  • Azure Databricks
  • Amazon S3 Simple Storage Service
Languages
  • English flag English - active, B2/C1/C2

Project description

  • design and maintenance of dimensional data models (Kimball) and possibly data vaults, with a focus on high scalability
  • creation of robust SQL scripts and ETL pipelines for transforming and loading data from staging zones into data marts
  • writing and executing unit tests, ensuring data quality and solving performance problems (performance tuning)
  • using cloud technologies such as AWS S3, AWS Redshift and Databricks for storing and processing large volumes of data
  • working with orchestration tools such as Airflow and DBT (Data Build Tool) for planning and versioning data transformations
  • cooperation in an agile team, participation in daily stand-ups, sprint plans and retrospectives
  • communication with internal and external stakeholders, collection of requirements and design of suitable solutions
  • ensuring best practices in the field of data engineering, including code versioning and code review
  • analytical processing of data requirements, identification of possible risks and search for optimization opportunities

Project requirements

  • experience with the design and implementation of data models according to the Kimball methodology, experience with data vault is an advantage
  • Experience in ETL development and data warehousing, including solutions for slowly changing dimensions and performance optimization
  • knowledge of the cloud (AWS S3, Redshift, Databricks) and tools for orchestration (Airflow) and transformation versioning (DBT)
  • orientation in tools such as SAP Power Designer or Erwin for data modeling
  • experience with testing data processes, preferably using unit tests and DBT test tools
  • basic knowledge of working in agile teams (Scrum, Kanban), ability to work effectively in a team
  • English at a communicative level for written and spoken interaction, ability to present and defend proposed solutions
  • Deeper knowledge of big data platforms such as Spark or Snowflake and practical experience with DataOps is an advantage
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!
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!
30 071

Titans that have
joined us

684

Clients that have
joined us

534 535

Succcessfully supplied
man-days