Senior Data Warehouse Engineer

Description

Summary: Seeking a Data Engineer to design and optimize data models, ETL pipelines, and Power BI dashboards, ensuring data accuracy and supporting data-driven decision-making. Highlights: 1. Design and develop data models, ETL pipelines, and data integration processes 2. Implement data quality controls, monitoring, and governance standards 3. Access to a certified training plan for continuous skill updates ###### **WORKPLACE:** **Lisbon (Hybrid)** ###### **ROLE:** * Design and develop data models, ETL pipelines, and data integration processes, integrating data from various sources (databases, APIs, streaming platforms, etc.); * Ensure the accuracy, efficiency, and scalability of Data Warehouse processes through monitoring, tuning, and platform optimization; * Support the expansion of Data Warehouse and Data Mart data models by designing robust structures, tables, and objects; * Implement data quality controls, monitoring, and governance standards; * Design and develop Power BI reports and dashboards (operational, strategic, and analytical); * Define and implement best practices, guidelines, and reusable processes to drive efficiency and quality; * Deliver insights that support the business in monitoring KPIs and making informed, data\-driven decisions. ###### **PROFILE:** * Degree in Information Technology or a related field; * Minimum of 5 years of professional experience in similar roles; * Strong knowledge of Data Warehousing, Data Lakes, and modern Data Warehouse architecture; * Experience with Public Cloud (good understanding of Compute, Storage, Networking, Identity, etc.); * Proficiency with CI/CD pipelines, Git, and DevOps practices; * Professional experience configuring and using Databricks on any public cloud (Azure preferred); * Knowledge of ETL processes handling large volumes of data; * Strong expertise in SQL Server and performance optimization; * Good knowledge of Fabric and PostgreSQL is a plus; * Familiarity with developing and optimizing Power BI dashboards; * Fluency in Portuguese and English; * Spanish language skills are a plus; * Excellent communication and interpersonal skills, with the ability to collaborate across different teams and companies; * Proactive, autonomous, and a strong team player; * Strong analytical and critical thinking skills. ###### **WORK WITH US:** * With more than 30 years of experience, Rumos has a team of professionals specialized in IT; * At Rumos, consultants integrate highly challenging projects, based on the latest technology and in the most diverse sectors of activity; * Rumos consultants have access to a certified training plan, which offers a constant update of technical skills; * Rumos, as an employer, has job opportunities based on equity, integrity and diversity. Based on these values, we work so that no person is discriminated against on the basis of age, degree of disability, gender, marital status, pregnancy and maternity, race, beliefs or sexual orientation. We believe in everyone's abilities, because we have in our DNA team spirit and mutual help, empathy and respect.