Job Title: Data Warehouse Specialist
Location: Preferably Hybrid in Porto
Work Regime: Fulltime
Overview / Summary:
LUZA Group is looking to expand our team with qualified professionals who are passionate about working with stateoftheart 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:
- Handson 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 decisionmaking.
- 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.