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
#J-18808-Ljbffr