Job Description

Ihre Aufgaben:

• Design, develop, and maintain ETL workflows using SSIS to integrate data from multiple sources into a centralized Data Warehouse
• Create and optimize complex SQL and PL/SQL scripts, stored procedures, and functions for SQL Server and Oracle databases
• Develop and maintain dynamic, visually appealing reports using SSRS and advanced dashboards using Power BI
• Automate database maintenance, deployment, and other repetitive tasks using PowerShell and other scripting tools
• Implement and manage CI/CD pipelines for database development, testing, and deployment
• Automate the generation of Data Warehouse structures based on metadata to improve efficiency and reduce development time
• Collaborate with cross-functional teams in an agile environment to gather requirements and deliver scalable, high-quality data solutions
• Develop custom tools and applications using .NET to enhance database and Data Warehouse functionality
• Actively participate in agile ceremonies such as sprint planning, daily stand-ups, and retrospectives to ensure continuous improvement and team alignment
• Ensure the performance, security, and reliability of database systems

Ihr Profil:

• 5+ years of experience in SQL Server (SSIS, SSRS) and Oracle database development
• Strong expertise in ETL processes, data integration, and Data Warehouse architecture
• Proficiency in Power BI for creating advanced dashboards and visualizations as well as proficiency in PowerShell scripting for automation and database maintenance
• Hands-on experience with DevOps practices, including continuous integration, automated testing, and deployment
• Knowledge of object-oriented programming languages, particularly .NET
• 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
• Experience in automating the deployment and maintenance of Data Warehouse solutions
• Strong problem-solving and analytical skills, with a focus on performance optimization
• Fluent in English; German language skills are a plus but not required

Skills Required