Senior Data Modeller

B2B Project: Senior Data Modeller

Hays IT Contracting is a cooperation based on B2B rules. We connect IT specialists with the most interesting technological projects on the market. For our client, currently delivering a cloud-first transformation of its enterprise data platform, we are looking for a specialist for the position of Senior Data Modeller.

• Rate: 175–220 PLN/h net (+ VAT)
• Cooperation type: B2B, through Hays Poland
• Language: English

Project Description The project focuses on the cloud-first transformation of an enterprise data platform and on defining how data is structured, understood and governed across reporting, analytics, regulatory and operational use cases. The Senior Data Modeller will provide end-to-end data modelling expertise, from source analysis and requirements discovery through conceptual and logical modelling to approved physical designs and implementation assurance. The services will be delivered in an Agile environment in collaboration with Data Engineers, Business Analysts, Solution Architects, QA specialists and business stakeholders.

Technology environment

• Kimball dimensional modelling
• Conceptual, logical and physical data modelling
• Databricks
• Apache Spark / PySpark
• Delta Lake
• Lakehouse architecture
• Medallion Architecture
• SQL Server
• Azure SQL
• Azure Data Lake Storage
• Azure data services
• ERD
• Source-to-target mapping
• Data dictionaries
• Data lineage, metadata and governance

Scope of services

• Analyse source systems, data structures and business requirements to define appropriate target data models.
• Translate business concepts and requirements into conceptual, logical and physical data models.
• Define data grain, keys, relationships, history strategies and data-quality expectations.
• Design dimensional models based on Kimball methodology.
• Design lakehouse and Delta structures as well as Medallion Architecture layers.
• Select appropriate normalised, dimensional or hybrid modelling approaches depending on specific use cases.
• Maintain modelling standards, naming conventions, data dictionaries, glossaries and source-to-target mappings.
• Maintain appropriate lineage, metadata and modelling documentation.
• Provide modelling guidance to Data Engineers and support the implementation of approved designs.
• Collaborate with QA specialists, architects, analysts and business stakeholders throughout project delivery.
• Participate in architecture reviews and support data governance and Master Data Management initiatives.
• Provide expert guidance to colleagues and contribute to strengthening data modelling capabilities across delivery teams.

Required competencies

• 5+ years of relevant experience, based on the senior benchmark used for this project. The project specification does not define an explicit minimum, so this requirement is subject to confirmation.
• Strong knowledge of Kimball dimensional modelling.
• Practical experience in designing conceptual, logical and physical data models.
• Experience with Databricks, Spark / PySpark and Delta Lake.
• Understanding of Lakehouse and Medallion Architecture concepts.
• Experience with SQL Server, Azure SQL, Azure Data Lake Storage and Azure data services.
• Practical experience with ERD and source-to-target mapping.
• Knowledge of data dictionaries, lineage, metadata and data governance.
• Ability to translate business concepts and requirements into appropriate data structures and modelling solutions.
• English communication skills sufficient for collaboration with business and technical stakeholders.

Nice to Have

• Inmon methodology
• Data Vault 2.0
• Microsoft Fabric
• Azure Synapse
• Unity Catalog
• Microsoft Purview
• Power BI semantic models

Cooperation process

• Profile and experience review by the Hays team
• A conversation with a Hays consultant about the project and scope of services
• A technical meeting with project representatives, up to 2 stages
• Agreement on cooperation terms
• Welcome to the project!

The cooperation is carried out between independent businesses (B2B model) and covers the performance of services within the agreed project scope. The Contractor independently organizes and manages the manner in which the services are performed, taking into account the project requirements, security obligations, and the necessary communication with the client. Any information regarding location, availability, or project meetings is provided solely for organizational purposes and shall not be construed as creating an employment relationship, employer-like supervision, or performance of work under the direction or control of the client.

#li-dni

#1201860 - Daria Kuras