Ihre Aufgaben:
1. Design, develop, and maintain ETL workflows using SSIS to integrate data from multiple sources into a centralized Data Warehouse
2. Create and optimize complex SQL and PL/SQL scripts, stored procedures, and functions for SQL Server and Oracle databases
3. Develop and maintain dynamic, visually appealing reports using SSRS and advanced dashboards using Power BI
4. Automate database maintenance, deployment, and other repetitive tasks using PowerShell and other scripting tools
5. Implement and manage CI/CD pipelines for database development, testing, and deployment
6. Automate the generation of Data Warehouse structures based on metadata to improve efficiency and reduce development time
7. Collaborate with cross-functional teams in an agile environment to gather requirements and deliver scalable, high-quality data solutions
8. Develop custom tools and applications using .NET to enhance database and Data Warehouse functionality
9. Actively participate in agile ceremonies such as sprint planning, daily stand-ups, and retrospectives to ensure continuous improvement and team alignment
10. Ensure the performance, security, and reliability of database systems
Ihr Profil:
11. 5+ years of experience in SQL Server (SSIS, SSRS) and Oracle database development
12. Strong expertise in ETL processes, data integration, and Data Warehouse architecture
13. Proficiency in Power BI for creating advanced dashboards and visualizations as well as proficiency in PowerShell scripting for automation and database maintenance
14. Hands-on experience with DevOps practices, including continuous integration, automated testing, and deployment
15. Knowledge of object-oriented programming languages, particularly .NET
16. Relevant certifications such as Microsoft Certified: Azure Data Engineer Associate, Power BI Data Analyst Associate, or Oracle PL/SQL Developer Certified Associate are a big plus
17. Experience in automating the deployment and maintenance of Data Warehouse solutions
18. Strong problem-solving and analytical skills, with a focus on performance optimization
19. Fluent in English; German language skills are a plus but not required