DATA MODELER

Empowered by our motto, "making data matter," Keyrus stands at the forefront of global consultancy in Data & Analytics, AI & Machine Learning, and Digital Transformation.
With a presence in 27 countries across 4 continents, we're on a mission to elevate the impact of data.
As a Data Modeler, you will play a crucial role in designing, implementing, and maintaining data models that support the organization's business objectives.
You will collaborate closely with stakeholders from various departments to understand their data needs and translate them into efficient and scalable data models.
This role requires a deep understanding of database design principles, data modeling techniques, and proficiency in relevant tools and technologies.
How the day by day looks like in this job? Develop conceptual, logical, and physical data models that accurately reflect the organization's data requirements and business processes.
Collaborate with business analysts, data engineers, and other stakeholders to gather and analyze requirements for new data models or modifications to existing ones.
Design database schemas, tables, views, and indexes to optimize data storage, retrieval, and performance.
Apply normalization techniques to ensure data integrity and minimize redundancy, while also considering denormalization where necessary to improve query performance.
Design data integration solutions to facilitate the seamless flow of data between different systems, databases, and applications.
Implement data quality checks and validation rules to ensure the accuracy, completeness, and consistency of data across the organization.
Monitor database performance and identify opportunities for optimization through indexing, partitioning, query optimization, and other techniques.
Create and maintain documentation for data models, including entity-relationship diagrams (ERDs), data dictionaries, and metadata definitions.
Work closely with cross-functional teams, including software developers, data scientists, and business stakeholders, to align data models with business requirements and technical constraints.
Stay updated on emerging trends, best practices, and technologies in data modeling and database design, and proactively recommend improvements to existing processes and methodologies.
For this specific job we need people with.
Proven experience in data modeling, database design, and development.
Proficiency in SQL and database management systems (e.
., Oracle, MySQL, PostgreSQL, SQL Server).
Familiarity with data modeling tools such as ERwin, ER/Studio, or PowerDesigner.
Strong analytical and problem-solving skills, with the ability to translate complex business requirements into data models.
Experience with Agile development methodologies and version control systems (e.
., Git) is a plus.
Fluent in English Must be a Portuguese or European citizen or have a work permit for Portugal   What we offer at Keyrus Portugal.
Salary based on your skills and experience and according to the Data market practices Meal allowance of €8.
per day Private Medical Insurance 22 days of annual leave Training Program through KLX (Keyrus Learning Experience) Why Keyrus? Joining Keyrus means joining a market leader in the Data Intelligence field and an (inter)national player in Management Consultancy and Digital Experience.
You will be part of a young and ever learning enterprise with an established international network of thought leading professionals driven by bridging the gap between innovation and business.
You get the opportunity to meet specialized and professional consultants in a multicultural ecosystem.
Keyrus gives you the opportunity to showcase your talents and potential, to build up experience through working with our clients, with the opportunity to grow depending on your capabilities and affinities, in a great working and dynamic atmosphere.