Data Warehouse Modeler

Data Warehouse Modeler
Lisboa
Lisboa, Lisboa, Portugal

About the Role

We are looking for a Data Warehouse Modeler to support the design and evolution of data warehouse solutions. In this role, you will work closely with data engineers, analysts, and stakeholders to define and maintain robust data models , ensuring they align with business needs and support efficient reporting, analytics, and governance.

Responsibilities:

• Design and maintain conceptual, logical, and physical data warehouse models;
• Apply data modeling best practices to ensure scalability, consistency, and performance;
• Work with data engineering teams to translate models into implementable structures;
• Develop and maintain supporting scripts for model deployment and updates;
• Support integration requirements and data flows, including basic API concepts where relevant;
• Contribute to documentation, standards, and continuous improvement of modeling practices;
• Collaborate with
  - functional teams to ensure data models meet business and reporting needs.

Required Skills & Experience:

• Strong understanding of data modeling concepts and techniques (dimensional modeling, normalization, star/snowflake schemas);
• Experience using data modeling tools/software (e. g. , ERwin, Power
  Designer, ER/Studio, Sparx, or similar);
• Ability to develop scripts supporting data model implementation and maintenance (SQL or related scripting);
• Understanding of API concepts and how they relate to data integration flows;
• Strong analytical mindset and attention to detail;
• Ability to communicate effectively with technical and business stakeholders;
• English level B2

Nice to Have

• Experience with CI/CD pipelines applied to data/analytics environments;
• Knowledge of Data Governance practices, standards, and data quality concepts.