We are looking for a senior candidate for the role of Enterprise Data Modeler with experience in SQL and data modeling for our client in the energy sector on a project to build a modern data lakehouse platform.
architectural design of data structures for a newly built data lakehouse / DWH solution and support for migration to a new platform with an emphasis on consistency and traceability of changes
close collaboration with a team of 6 specialists (architects, data governance and data quality specialists) led by the head of data management
utilization of a modern technology stack built on Databricks, Spark and Python in a cloud environment
definition of standards and methodologies in data management, reporting and advanced analytics
ensuring smooth data migration and integration of diverse data sources into the new warehouse
gathering business requirements for data model changes, designing solutions including impacts, dependencies and prioritization in cooperation with data architecture
setting parameters for the quality of master data, reference data and metadata
design and management of logical and physical data models for integration and analytical use-cases (e.g., ER diagrams, dimensional modeling, Data Vault, Medallion architecture)
collaboration in a 50% onsite in Prague and 50% remote mode
Requirements
advanced experience with:
data modeling (conceptual, logical and physical models)
creating ER diagrams and dimensional modeling
working with SQL for complex analysis and querying
experience with:
Python, Spark or Databricks technologies
Data Vault or Medallion architecture principles
data migration and data integration processes
knowledge of:
data lakehouse architecture or modern cloud data warehouses
Czech or Slovak language at a communicative level (essential for internal collaboration)
advantageous:
experience in the energy sector
knowledge of metadata management and data governance tools
Are you interested in this offer?
Recommendan IT specialistDo you know anyone who could usethis project? Recommend him
and get a reward!
Hirean IT specialistDo you need a similarIT freelancer for your project?
Hire a specialist