Senior Data Modeler

Short company description

At Evolve today we offer complex Human Resources services, from business consulting to headhunting and recruitment. We have extensive experience in finding talented professionals, for a variety of industries, especially in the IT sector.
We started with a dream: to create a Human Resources company with a strong, unique profile on the market, deeply shaped by our core values: commitment to performance, professionalism, a balanced approach and deep satisfaction for our clients.
From that moment, we nurtured special relationships and we continuously evolved, being flexible, but staying true to our values. We aim higher and higher and we invite you to EVOLVE with us!

Requirements

For our business partner, one of the largest integrators of IT and physical security solutions for national and European critical infrastructure, we are looking for a Senior Data Modeler who will play a critical role in the design, implementation, and optimizing data models for our Business Intelligence (BI) and Data Warehousing (DW) solutions.

The ideal person should have a solid knowledge of OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) along with advanced data modeling expertise.

Requirements:

Bachelor’s Degree in Computer Science or equivalent;
Minimum 5+ years of BI/DW, OLTP, and data modeling experience
Knowledge of data warehousing, ETL and BI architectures, concepts and frameworks
Deep knowledge of the Kimball and Inmon approaches and the basic differences
Experience in data modeling principles/methods including conceptual, logical, and physical data models
Able to facilitate data discovery sessions involving subject matter experts
Experience translating/mapping relational data models to Database Schemas
Experience with modeling tools (such as ERWin and ER/Studio)
Knowledge of RDBMS platforms (eg Oracle, SQL Server, DB2) with experience generating DDL)
Ability to create and maintain conceptual/business, logical, and physical data models
Ability to translate a logical model into a physical model by adding appropriate physical objects needed to create the database, e.g. Indicators
Experience maintaining a model repository
Ability to synchronize models to ensure database structures match models

Responsibilities

Responsibilities:

Design and development of conceptual, logical, and physical data models for OLTP and Data Warehousing (DW) applications.
Implementing robust data modeling solutions to support Business Intelligence and reporting initiatives.
Working with business teams and stakeholders to understand data requirements and translate those needs into effective data models.
Development and optimization of database structures to support OLTP and OLAP processes.
Create and manage technical documentation for data models and define data modeling standards.
Collaborating with ETL and data engineering teams to implement and optimize data loading and processing processes.
Monitoring data performance and integrity, ensuring scalability and reliability of data models.
Validate and verify data models against business requirements to ensure compliance and optimization of reporting processes.
Ensuring data integrity, security, and confidentiality at all levels of the data architecture.