Senior Data Modeler - Evolve Today
Aplică extern

Senior Data Modeler

Publicat 10.10.2024 | Expiră 24.11.2024

Descriere job

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.

 

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.

 

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
Evolve Today

Evolve Today

24 anunțuri active

5.00

1 evaluare

Oportunități de avansare

Pachet salarial

Timp la birou vs. timp liber

Management

Proceduri și valori

Criterii job

Tip job Full-time
Orașe Bucuresti