Job Title: Data Warehouse Specialist Location: Preferably Hybrid in Porto Work Regime: Full-time Overview / Summary: LUZA Group is looking to expand our team with qualified professionals who are passionate about working with state-of-the-art technologies, especially in the development and optimization of Data Warehouse systems.
If you have experience working with large data volumes, integrating data sources, and optimizing storage solutions, this is the perfect opportunity for you!
Responsibilities and Tasks: Plan, implement, and optimize Data Warehouse systems to store data efficiently.
Create and maintain data integration processes across various sources, ensuring data quality and integrity.
Work closely with BI teams and other departments to ensure data transformation and delivery according to business needs.
Develop and optimize ETL (Extract, Transform, Load) processes and queries using tools such as SSIS or Azure Data Factory.
Perform performance analysis on Data Warehouse systems and implement continuous improvements.
Mandatory Requirements: Hands-on experience with SQL Server , Azure Synapse Analytics , Power BI , and other data analysis tools.
Proficiency in data integration tools (ETL), such as SSIS , Azure Data Factory , or other integration platforms.
Experience with data modeling and ETL processes (Extract, Transform, Load).
Ability to optimize and transform data into efficient solutions for analysis and decision-making.
Knowledge of SQL and programming languages for process automation and advanced querying.
Experience with cloud environments , especially Azure , is highly desirable.
Languages: Portuguese and English, both fluent.
Desirable Qualifications: Microsoft Certified: Azure Data Engineer Associate or Azure Solutions Architect Expert certification.
Experience with PowerShell and other process automation tools.